Advanced Microsoft Excel

About Course

Advanced Microsoft Excel – pivot table is a special Excel tool that allows data analysts to summarize and explore data interactively and it is useful for anyone who works data sets and for managers.

Learning Objectives

Create a pivot table.
Filter a pivot table.
Sort a pivot table.
Work with multiple value fields.
Add custom calculations to a pivot table.
Refresh and update a pivot table.
Create a PivotChart.

What will You Learn

Cleaning and preparing your data
Create, modify, and format PivotTables
Use summary functions and customized calculations
Create filters and slicers
Design Interactive Dashboard
Different ways to summarize data
Combining data from multiple worksheets for a PivotTable
Updating your data in a PivotTable and PivotChart

Methodology

Pre- Assessment
Post- Assessment
Presentations
Practical Activities