Course length: 1-day
Course Overview
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:
Excel - Data Analysis and Forecasting
Outline
Developing Macros
- Create a Macro Using the Macro Recorder
- Edit a Macro
- Debugging a Macro
- Customizing the Quick Access Toolbar and Hotkeys
- Setting Macro Security
Formatting Worksheets Using Macros
- Insert Text
- Format Text
- Sort Data
- Duplicate Data
- Generate a Report
Creating an Interactive Worksheet
- Determine the Dialog Box Type
- Capture User Input
Working with Multiple Worksheets
- Insert, Copy, and Delete Worksheets
- Rename Worksheets
- Modify the Order of Worksheets
- Print Worksheets
Performing Calculations
- Create User-Defined Functions
- Automate SUM Functions