PivotTables are a powerful feature in Excel used for summarizing, analysing, and exploring large datasets. They allow users to rearrange and aggregate data dynamically, enabling quick insights into trends, patterns, and relationships within the data. PivotTables provide flexibility in organizing and presenting information, making them invaluable for data analysis and reporting tasks in various domains.

Learning Objectives

At the end of the training, participants will be able to:

• create PivotTables from datasets;
• manipulate PivotTable fields and settings;
• apply filters;
• sort data;
• format data; and
• create interactive and dynamic visualization.  

Curriculum

• Introduction to PivotTables;
• creating PivotTables from data;
• filtering and sorting PivotTable data;
• calculated fields and items in PivotTables;
• PivotTable formatting and customization;
• using PivotTable slicers and timelines; and
• analysis and Visualization of data in PivotTables

Format of Learning

In-Person