Learn to use advanced formulas and work with various tools to analyze data in spreadsheets. Organize table data, create PivotTables, presentation features, and enhance the look and appeal of workbooks by adding graphical objects.

It's design is for frequent users.
 

Lesson 1: Working with Functions

•  Work with Ranges
•  Use Specialized Functions
•  Work with Logical Functions
•  Work with Date & Time Functions
•  Work with Text Functions

Lesson 2: Working with Lists

•  Sort Data
•  Filter Data
•  Query Data with Database Functions
•  Outline and Subtotal Data

Lesson 3: Analyzing Data

•  Create and Modify Tables
•  Apply Intermediate Conditional Formatting
•  Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

•  Create Charts
•  Modify and Format Charts
•  Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

• Create a PivotTable
•  Analyze PivotTable Data
•  Present Data with PivotCharts
•  Filter Data by Using Timelines and Slicers