Microsoft Advanced Excel: Course Outline

1: Working With Multiple Worksheets and Workbooks

• Topic A: Use Links and External References
• Topic B: Use 3-D References
• Topic C: Consolidate Data

2: Using Lookup Formulas and Formula Auditing

• Topic A: Use Lookup Functions
• Topic B: Trace Cells
• Topic C: Watch and Evaluate Formulas

3: Sharing and Protecting Workbooks

• Topic A: Collaborate on a Workbook
• Topic B: Protect Worksheets and Workbooks

4: Automating Workbook Functionality

• Topic A: Apply Data Validation
• Topic B: Search for Invalid Data and Formulas with Errors
• Topic C: Work with Macros

5: Creating Sparklines and Mapping Data

• Topic A: Create Sparklines
• Topic B: Map Data

6: Forecasting Data

• Topic A: Determine Potential Outcomes Using Data Tables
• Topic B: Determine Potential Outcomes Using Scenarios
• Topic C: Use the Goal Seek Feature
• Topic D: Forecasting Data Trends