Training Course:Excel 2007 - VBA (Certificate)School/Trainer:New Horizons Computer Learning Centers of Pakistan
Karachi, Pakistan
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' In this course, students will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.
Who Should Attend:
Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).
At Course Completion:
Upon successful completion of this course, students will be able to: - create, edit, and debug a macro. - format worksheets using macros. - create an interactive worksheet. - work with multiple worksheets. - perform calculations.
Prerequisite(s) or equivalent knowledge:
Excel 2007 - Level 1
Excel 2007 - Level 2
Excel 2007 - Level 3
Outline: Top
Lesson 1: Developing Macros
Create a Macro with the Macro Recorder
Edit a Macro
Debug a Macro
Customize the Quick Access Toolbar and Hotkeys
Work with Macro Security
Top
Lesson 2: Formatting Worksheets Using Macros
Insert Text
Format Text
Sort Data
Duplicate Data
Generate a Report
Lesson 3: Creating an Interactive Worksheet
Determine the Dialog Box Type
Capture User Input
Lesson 4: Working with Multiple Worksheets
Insert, Copy, and Delete Worksheets
Rename Worksheets
Modify the Order of Worksheets
Print Worksheets
Lesson 5: Performing Calculations
Create User-Defined Functions
Automate SUM Functions
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.nhpakistan.com.pk/
Phone:+(92) 021-4382352-3-4
School Address:
49-C, Block 6, P.E.C.H.S, Shahra-e-Faisal, Karachi, Pakistan.
Jobs & Resumes: Karachi
Houses & Roommates: Karachi
Travel Agencies: Karachi
Search other schools for Excel 2007 - VBA training resources.
Other training courses offered by New Horizons Computer Learning Centers of Pakistan:
Visual Studio 2008: ADO.NET 3.5
Visual Studio 2008: ASP.NET 3.5
Windows Vista (Español) - Nivel 2
Windows Vista (Español) - Nivel 1
Windows XP Español
Word 2007 (Español) - Nivel 1
Word 2007 (Español) - Nivel 2
Excel 2007 (Español) - Nivel 1
Excel 2007 (Español) - Nivel 2
PowerPoint 2007 (Español)
Access 2007 (Español) - Nivel 1
Access 2007 (Español) - Nivel 2
Outlook 2007 (Español)
E-Commerce Profitability: Online Merchandising Using Microsoft Office FrontPage 2003
project 2007 web access
Project 2007 Professional
Visio Professional 2007 - Level 2
Visio Professional 2007 - Level 1
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting. |
|
| 
