Editing recorded Macros:
Using Relative recording
Naming macros
Working with the Personal Workbook using the Visual Basic Editor to view and edit VBA code

Writing macros (Subroutine procedures):
Using subroutines in a macro and calling one subroutine from another
Performing actions using For-Next and Do-While loops
Creating a new toolbar and adding tool hints

Using Custom Functions:
Writing simple custom functions and functions that accept arguments
Using If, Then, Else, Else If and Select Case conditional structures

Using Help:
Using the Help files to browse for information
Using the Object Browser to find Object Properties, Methods, Events and Constants
Single stepping through a macro

Using variables and data-types:
Assigning values to variables
Defining variables using types
Declaring user defined types
Converting types
Debugging macro errors