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