MS Excel Toronto Meetup – Pivot Table Tips and Tricks – Bill Jelen

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
_______________________________________________________________________

Session recorded live on April 7, 2021

The MS Excel Toronto Meetup group is organized by

CHAPTERS: (Thank you to Gráinne Duggan for her help with this list.)

00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00: 01:15 - Celia Introduces Bill Jelen
00:04:10 - Bill introduces himself and his presentation
00:09:30 - Set up your data for Pivot Table (List format - no blank rows or columns)
00:10:50 - Accounting underline format (single and double)
00:15:20 - Create a Pivot Table and rearrange Pivot Table
00:22:30 - Drill down in Pivot Table and Custom Lists
00:24:40 – Control Pivot Table annoyances using the new Pivot Table Defaults
00:33:45 - Show values as settings and sort settings
00:36:45 - See several ways to create a Top Ten report
00:40:30 - 'The Magic Cell' - Thanks Dan from Philadelphia - AutoFilter a Pivot Table
00:45:00 - Year over Year report and change GetPivotData option
00:52:00 - Show report filter pages option - replicate a Pivot Table for each customer
00:54:00 - Compare lists
00:56:25 - Power Maps
01:04:45 - Data Model can unlock features usually unavailable in Pivot Tables (PowerPivot) - Distinct Count
01:13:30 - Control multiple Pivot Tables with slicers, even when the data is coming from different sources
01:19:20 - GetPivotData - how to copy the formula and get the correct result - change to linked cells from hard coded names
01:21:15 - Questions - Power Maps, using filters, replace Pivot Table with Dynamic Arrays, Pivot a Pivot, MrExcel Forum, preserve Pivot Table formatting, new Filter function, floating or docking the PivotTableFields box, Pivot Table layout and formatting changes, MVP's exchange ideas about learning Excel
01:57:45 - Wrap up

-----------------------
About this session:

Take a deep dive on pivot tables with MrExcel!

Control pivot table annoyances using the new Pivot Table Defaults. See several ways to create a Top Ten report or a Year over Year report. Learn how to AutoFilter a pivot table. See how the Data Model can unlock features usually unavailable in pivot tables. Control multiple pivot tables with slicers, even when the data is coming from different sources.

---------------------
About the Speaker: Bill Jellen

Find more about Bill's work and connect with him:

-----------------------

[gudlaugkarlsdottir]

Wow this is such a great lecture. I missed the live session due to time difference, dem really would have liked to see this live. Thank you for sharing this. So much fun to learn new tricks, love it :)

[florincopaci]

Thank you Mr Jelen for all the informations!

[OakleyTurvey]

Great session.
I just love all of Bill's stories that really bring things to life, as well as the Tips & Tricks (sorry Jon).
Thanks for arranging, Celia.

[usmaniqbal]

Celia, please also share data file for better practice.