Course Content
Lesson 1: Automating Workbook Functionality
Topic A: Apply Data Validation
- Data Validation
- The Data Validation Dialog Box
- Data Validation Criteria
- Input Messages
- Error Alerts
- How to Apply Data Validation Criteria
- Applying Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
- Invalid Data
- The Circle Invalid Data Command
- The Error Checking Command
- Error Types
- How to Search for Invalid Data and Formulas with Errors
- Searching for Invalid Data and Formulas with Errors
Topic C: Work with Macros
- Macros
- Macro Security Settings
- Microsoft Visual Basic for Applications
- The Record Macro Dialog Box
- The Use Relative References Command
- The Macro Dialog Box
- Macro Names
- The Personal Workbook
- Copying Macros
- How to Work with Macros
- Creating a Macro
- Editing a Macro