Getting to Grips with PivotTables in Excel (1-Hour Recorded Webinar)
This recorded live webinar will teach you the best practices in working with PivotTables in Excel.
Our Excel expert trainer, Deb Ashby, will walk you through adding your data to Excel tables, creating a PivotTable based on an Excel table, creating a Pivot Chart, and so much more!
Deb discusses the following:
- What are PivotTables, and why are they useful?
- Understanding data
- The importance of Excel tables
- Creating a PivotTable
- Analyzing data with a PivotTable
- Grouping
- Changing how we aggregate data (Value Field Settings)
- Show Values As
- Applying number formatting
- Toggling on Sub-totals and Grand totals
- Report layouts
- Applying PivotTable styles
- Creating a Pivot Chart
- Formatting Pivot Charts
- Filtering data with slicers
- Updating PivotTable data
Watch the session here, and download the Excel file to follow along.
Getting to Grips with PivotTables in Excel – Recorded Webinar
Download the file and follow along.
Other Microsoft Webinars:
Advanced Formulas in Excel (1-Hour Recorded Webinar)
Get the Most Out of Microsoft Teams (1 Hour Recorded Webinar)
Lookup Functions in Excel – (Recorded Webinar)
Please visit our free Microsoft Office resources center for more high-quality Microsoft guides.
Simon Calder
Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!