Microsoft Intermediate Excel: Course Outline

  • 1: Working With Functions

    • Topic A: Work with Ranges
    • Topic B: Use Specialized Functions
    • Topic C: Work with Logical Functions
    • Topic D: Work with Date and Time Functions
    • Topic E: Work with Text Functions

    2: Working With Lists

    • Topic A: Sort Data
    • Topic B: Filter Data
    • Topic C: Query Data with Database Functions
    • Topic D: Outline and Subtotal Data

    3: Analyzing Data

    • Topic A: Create and Modify Tables
    • Topic B: Apply Intermediate Conditional Formatting
    • Topic C: Apply Advanced Conditional Formatting

    4: Visualizing Data With Charts

    • Topic A: Create Charts
    • Topic B: Modify and Format Charts
    • Topic C: Use Advanced Chart Features

    5: Analyzing Data With PivotTables and PivotCharts

    • Topic A: Create a PivotTable
    • Topic B: Analyze PivotTable Data
    • Topic C: Present Data with PivotCharts
    • Topic D: Filter Data by Using Timelines and Slicers