Excel 2013 VBA

Course Length: 1 day

Prerequisites: Knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. Students are recommended to first take the following courses or have equivalent knowledge: Microsoft Office Excel 2013: Levels 1-3.

Course Content:
Lesson 1: Developing Macros
Topic A: Create a Macro Using the Macro Recorder
Topic B: Edit a Macro
Topic C: Debug a Macro
Topic D: Customize the Quick Access Toolbar and Hotkeys
Topic E: Set Macro Security

Lesson 2: Formatting Worksheets Using Macros
Topic A: Insert Text
Topic B: Format Text
Topic C: Sort Data
Topic D: Duplicate Data
Topic E: Generate a Report

Lesson 3: Creating an Interactive Worksheet
Topic A: Determine the Dialog Box Type
Topic B: Capture User Input

Lesson 4: Working with Multiple Worksheets
Topic A: Insert, Copy, and Delete Worksheets
Topic B: Rename Worksheets
Topic C: Modify the Order of Worksheets
Topic D: Print Worksheets

Lesson 5: Performing Calculations
Topic A: Create User-Defined Functions
Topic B: Automate SUM Functions