Intermediate Excel Course

Working With Functions

Work with Ranges name

Use Specialized Functions

Work with Logical Functions

Work with Date & Time Functions

Work with Text Functions

Working With Lists

Sort Data

Filter Data

Query Data with Database Functions

Outline and Subtotal Data

Analyzing Data

Create and Modify Tables

Apply Intermediate Conditional Formatting

Apply Advanced Conditional Formatting

Visualizing Data With Charts

Create a PivotTable

Modify and Format Charts

Use Advanced Chart Features

Using PivotTables And Pivot Charts

Create and Modify Tables

Analyze PivotTable Data

Present Data with Pivot Charts

Filter Data by Using Timelines and Slicers