Wednesday, February 24, 2010 8:30 AM to 4:15 PM
Tuesday, March 30, 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.
Save time and increase productivity by automating mundane and repetitive tasks with Macros and VBA procedure. Skills learned in this course are immediately transferable to Word, PowerPoint and Access!
Learning Objectives
- Upon successful completion of this course, participants will be able to:
- Use the VB Recorder to create macros
- Learn and practice six different ways to run macros
- Learn how to open the Visual Basic Editor (VBE)
- Understand the VBE interface
- Use 4 simple rules for learning the Visual Basic for Application language (VBA)
- Practice simple edits in VBA using messaging tools, simple branching statements and a looping construct
- Design, program and test a custom dialog box in the VBE
- Understand VBA Events and practice automating automatic tasks
