Over a Decade of Serious Learning for Ambitious Minds. * 9.5 of 10 (over 18 k student survey results - 2020)

Find A Class in Your City:

Microsoft Excel VBA / Macros Assessment

Email this page | Print this page

Microsoft Excel VBA / Macros Assessment

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