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