Introduction to PivotTables in Excel
Improve your ability to create and work with PivotTables so that you can more effectively summarize, analyze and present financial data using Microsoft 365.
PivotTables are a powerful data summarization tool within Excel that can help you add tremendous value to your financial spreadsheets.
From demonstrating how PivotTables work to how to create them, this course provides you with the fundamentals needed to present and examine your financial data from different perspectives.
This online, video-led course is presented using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.
Note: This course can be taken individually or as part of the Comprehensive Excel Certificate Program. If you are taking this course individually, we recommend that you complete our Excel tables and tabular data course prior to taking this course.
You will learn about:
- Structuring data in Excel and the importance of tabular data for PivotTables
- How PivotTables work
- Creating PivotTables
- Modifying existing PivotTables
- Applying sorting and filtering to PivotTables to examine data from different perspectives
- Creating and using Slicers to explore PivotTable data
Who should attend?
- advanced Excel users
- IT professionals
- business intelligence educators
- consultants
- financial analysts
