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; [...]

Continue reading»

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 [...]

Continue reading»

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[...]

Continue reading»

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[...]

Continue reading»

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[...]

Continue reading»

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 [...]

Continue reading»