Event Details
Location and date: |
Online |
On-Demand Event |
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.
Additional options and pricing may be available. See pricing and registration for more details.
Member $155 | Non-member $185
2 CPD hour(s)
Pricing & registration
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
More Details:
You may also be interested in:
On-Demand Event
Learn how to create tabular data sets in Excel so you can better organize and analyze financial information using Microsoft 365.
On-Demand Event
Deepen your understanding of Excel’s date and time functions so you can perform complex calculations using Microsoft 365.
On-Demand Event
Learn how to use essential functions in Excel for Microsoft 365 that will help you evaluate financial data and make better business decisions.
Please contact:
Member Development and Support
Tel: 1-800-268-3793
Email: [email protected]