Excel 2007 Expert – Macros, VBA, and Excel Programming


This course will explore how to automate Excel tasks with macros. We will cover
recording, running, and editing both basic and relative reference macros. Information on
assigning a keyboard shortcut to a macro and managing macro security is also included.
Then, Visual Basic tasks will be covered, including copying macros, using the Visual Basic
Editor, declaring variables, iterating over a range, prompting for user input, and using
conditional (If…Then…Else) statements.