Overview

Excel's Pivot Tables and Pivot Charts are invaluable data analysis and visualisation tools. They empower users to transform raw data into actionable insights, fostering better decision-making and enhancing the understanding of complex datasets. 

This course will explore the tools and techniques used to tidy raw data, how to analyse data using PivotTable and Pivot Charts, and the capability of Power Pivot. 

Whether you're a business analyst, financial planner, or researcher, mastering these features can significantly boost your data analysis capabilities.

Learning Outcomes

• Understand why and how to use PivotTables and PivotCharts is important in Excel.
• Clean the raw data in the spreadsheet using Excel tools.
• Build your first PivotTable.
• Explore Power Pivot.

Audience

Anyone looking to improve their skills using Pivot Tables and Pivot Charts in Microsoft Excel.