MP9002: Desktop Computing - Automating with VBA Macros > Excel 2007 Advanced

This course introduces the use of macros in Excel 2007. 

Topics:
Setting VBA security
Recording and Running Macros
Using the End Key
Filtering with Macros
Understanding VBA Code
Writing Macros
Controlling and Combining Macros

Objectives:
Enable the Developer tab on the Ribbon
Modify macro security settings
Record and run macros
Record a macro that uses an advanced filter
Customize macros for everyday use
Combine elements of written code with recorded code

Duration:
2 Hours