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.

Macro Buttons to Add Fields to Pivot Tables

Bottom Line: Learn how to create simple macro buttons that users can click to instantly add or remove fields to Excel pivot tables.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; top: 0; l [...]

Continue reading»

Refresh Pivot Tables Automatically When Source Data Changes

Bottom Line: Learn how to use a simple macro to refresh pivot tables automatically whenever changes are made to the source data.  I also share a non-macro solution to update the pivot tables when the file is opened.  Includes video tutorial and Excel file download.Skill Level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overf [...]

Continue reading»

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»