1 - WORKING WITH FUNCTIONS AND COMPLEX CALCULATIONS

Summarising Data using Functions (Sum/SumIf, Count/CountIf etc.)

Work with Logical Functions

Work with Lookup Functions

Work with Date and Time Functions

Work with Text Functions

2 - WORKING WITH LISTS AND TABLES

Sort and Filter Data

Remove Duplicate Values

Group and Outline Data

Subtotal Data

3 - VISUALIZING DATA WITH CHARTS

Create and Modify Charts

Use Advanced Chart Features

Save a Custom Chart Template

4 - USING TABLES, PIVOT TABLE REPORTS AND PIVOT CHARTS

Create and Modify Tables

Use Functions to Calculate in Tables

Create a Pivot Table Report

Manipulate Pivot Tables

Present Data with Pivot Charts

Filter Data by Using Slicers and Timelines