Automating Task and Eliminating Redundant Steps using Macros & VBA
Thursday, February 25, 2010 8:30 AM to 4:15 PM
Wednesday, March 31, 2010 8:30 AM to 4:15 PM
Price: $295.00
| Use discount code “DAY1″ to register for 1st day only or Attend Level 1 and Level 2 , two days of hands on training for just $545.00 |
In its broadest sense, a macro is a sequence of instructions that automate some aspect of Excel so you can work more efficiently and with fewer errors. Many reporting and analysis task that have formerly taken hours to complete by very proficient Excel users have been completed in seconds by macros, also known as VBA programs.
Take this course to develop a strong understanding of the Excel object model used in VBA. Learn advanced Variable concepts, exploit VBA tools and functions.
Learning Objectives
Upon successful completion of this course, participants will be able to:
- Developing custom Function in VBA
- Using the Object Browser in the VBE
- Declaring and scoping variables
- Using Arrays
- Understanding object variables and using the Set statement
- Learn the features, benefits, differences and syntax of VBA’s four primary decision structures
- Understanding the scope of procedures and functions
- Using loop structures including For Each – Next loops and four flavors of Do loops
- Using VBA functions
- Learn how to build an Add-In for Excel
