Training Course:Excel 2007 - VBA (Certificate)School/Trainer:New Horizons Malaysia
Kuala Lumpur, Kuantan, Penang, Petaling Jaya, Malaysia
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.newhorizons.com.my/
Phone:+ 603-26946455
School Address:
3rd Floor, Wisma Thakurdas
Kuala Lumpur,16-1, Jalan Raja Laut 50350
Malaysia
Jobs & Resumes: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Houses & Roommates: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Travel Agencies: Kuala Lumpur,
Search other schools for Excel 2007 - VBA training resources.
Other training courses offered by New Horizons Malaysia:
Microsoft Exchange Server 2007
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:
Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent. |
|
|
