Excel Macro Programming Level I

Length: 1 day
Software Version:  2007/2010
Prerequisites: Intermediate to advanced knowledge of MS Excel required.  No programming experience necessary
Target Student:  Take this course to 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!

After completing 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

 

Click here for course cost and dates

BACK