Thank You!
Thank you for taking the time provide feedback. This really helps me improve my products and offerings.
Here are some of my recent posts on pivot tables.
How to Calculate Daily Averages with a Pivot Table
Bottom line: Learn how to calculate the average of a daily total amount across month, quarters, years, or even categories with a pivot table.Skill level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; [...]
How to Turn Off GETPIVOTDATA Formulas for Pivot Tables
Bottom line: Learn how to turn the GETPIVOTDATA formulas on/off when you create a formula that references a cell inside a pivot table.Skill level: Beginner.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; lef [...]
How to Change Date Formatting for Grouped Pivot Table Fields
Bottom line: Learn how to change the date formatting for a grouped field in a pivot table.Skill level: Intermediate[...]
Expand and Collapse Entire Pivot Table Fields – VBA Macro
Bottom line: Learn how to add buttons to your pivot tables and pivot charts to quickly expand/collapse entire fields using a VBA macro.Skill level: Intermediate[...]
Only Display Used Fields on Pivot Table Show Details Sheet
Bottom line: Learn how to create a Show Details Drill Down Sheet from a pivot table that only contains the fields (columns) used in the pivot table.Skill level: Intermediate[...]
Pivot Charts for Excel 2016 for Mac
Bottom line: Pivot Charts are now available on Excel 2016 for Mac (Office 365).Skill level: Beginner.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; left: 0; width: 100%; height: 100%; }Watch on YouTube [...]