webinar register page

Webinar banner
Deep Dive on Pivot Tables with MrExcel
As part of the More4academy learning series, we are offering our second MrExcel webinar. Registration is free and attendees who participate in the live poll questions are eligible to receive 1 CPE credit. Seats are limited!

A Pivot Table is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. In this "Deep Dive on Pivot Tables" webinar, spend an hour with Bill "MrExcel" Jelen and learn some secrets and lesser-known tricks in Microsoft Excel - all centered around this feature!

This webinar will cover:
* Setting defaults for all future pivot tables
* Easy Year-over-Year analysis with pivot tables
* Top 10 report with the correct totals using an AutoFilter hack
* Replicating a Pivot Table for each customer
* Putting a pivot table on a map
* Joining data from two different worksheets into one pivot table
* Syncing slicers from two data sets

We encourage you to share this invite with your colleagues! Register today!

Jan 19, 2022 04:00 PM in Eastern Time (US and Canada)

Webinar logo
* Required information
Loading

Speakers

Bill Jelen
MrExcel
Bill Jelen is the host of MrExcel.com and the author of 64 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel Inside Out. He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He has produced over 2400 episodes of his Excel video podcast Learn Excel from MrExcel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.