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