PivotTable Tips and Tricks – Recorded Webinar
This recorded live webinar will teach you some of the best Excel PivotTable tips and tricks.
Your expert Excel trainer, Deb Ashby, will walk you through the importance of cleaning data, working with both Excel tables and PivotTables, formatting tables, filtering and sorting data, creating a PivotChart, and so much more!
In this month’s webinar, Deb discusses the following:
- What are PivotTables?
- The importance of cleaning data
- Excel Table vs. PivotTable and why we need both
- Create a PivotTable
- Analyze data by pivoting fields
- Report layouts
- Number formatting
- Filter and sort data: Top 10 filters
- Auto-fit column widths
- Grouping PivotTable items
- Re-order a PivotTable
- Use calculated fields
- Show values as percentages
- Create a PivotChart
- Basic PivotChart formatting
- Filter data with slicers
- Modify slicer settings
- Create slicer styles
- Update a PivotTable
Watch the session here, and download the instructor demo files to follow along.
PivotTable Tips and Tricks – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
Practical Uses of Logical Formulas in Excel
New Dynamic Array Functions in Excel
Dynamic Array Functions in Excel
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!
