Summary
Excel Basics 103
This is a 2-hour virtual class, and in celebration of our 30th Anniversary, it will be held for $30!
Outline
-
Lesson 1: Working with Multiple Worksheets and Workbooks
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
-
Lesson 2: Automating Workbook Functionality
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
-
Lesson 3: Using Lookup Functions and Formula Auditing
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
-
Lesson 4: Creating Sparklines and Mapping Data
- Topic A: Create Sparklines
Course Schedule
*Indicates a course that spans over multiple days.**Indicates a course that is only a half day.