Course Content
Lesson 1: Working with Multiple Worksheets and Workbooks
+ See more details
Lesson 2: Sharing and Protecting Workbooks
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
+ See more details
Lesson 3: Automating Workbook Functionality
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
+ See more details
Lesson 4: Using Lookup Functions and Formula Auditing
Lessons
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
+ See more details
Lesson 5: Forecasting Data
Lessons
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
+ See more details
Lesson 6: Creating Sparklines and Mapping Data
Lessons
- Topic A: Create Sparklines
- Topic B: Map Data
+ See more details