Please review the outline for this class to see if you are comfortable with the technical features from this level. This is a self assessment.
Lesson 1: Developing Macros
Topic 1A: Create a Macro with the Macro Recorder
Topic 1B: Edit a Macro
Topic 1C: Debug a Macro
Topic 1D: Customize Toolbars, Menus, and Hotkeys
Lesson 2: Formatting Worksheets
Topic 2A: Sort Data
Topic 2B: Insert Rows and Columns
Topic 2C: Insert Text
Topic 2D: Format Text
Topic 2E: Duplicate Data
Topic 2F: Generate a Report
Lesson 3: Creating an Interactive Worksheet
Topic 3A: Determine Dialog Box Type
Topic 3B: Capture User Input
Lesson 4: Working with Multiple Worksheets
Topic 4A: Insert, Copy, and Delete Worksheets
Topic 4B: Rename Worksheets
Topic 4C: Modify the Order of Worksheets
Topic 4D: Print Worksheets
Lesson 5: Performing Calculations
Topic 5A: Create User-defined Functions
Topic 5B: Automate SUM Functions