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

Topic A: Sort Data

Topic B: Filter Data

Topic C: Query Data with Database Functions

Topic D: Outline and Subtotal Data

Topic A: Create and Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic C: Use Advanced Chart Features

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