Course length: 1 day
Learn to record Macros to automate and streamline redundant tasks resulting in greater productivity. This course, over the duration of five lessons, gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel.
Prerequisites:
Students should have completed the following courses or possess equivalent knowledge before starting with this course:
Outline
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