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.

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»

5 Reasons to Use an Excel Table as the Source of a Pivot Table

Bottom line: Learn why using an Excel Table as the source of a pivot table can save time and prevent errors.Skill level: Beginner[...]

Continue reading»

How to Stop Pivot Table Columns from Resizing on Change or Refresh

Bottom line: Learn how to prevent or disable the columns in a pivot table from resizing when the pivot table is updated, refreshed, changed, or filtered.Skill level: Beginner[...]

Continue reading»

Automatic Default Number Formatting in Excel Pivot Tables

Bottom line: Save tons of time by automatically formatting the numbers in the Values area of your pivot tables with a VBA macro.  Number formatting is automatically applied when you drag a field into the Values area in one single step.Skill level: Intermediate [...]

Continue reading»

The Calendar Table (Date Dimension) Explained for Power Pivot & Power BI

Bottom line: In this post we will learn what a Calendar Table or Date Dimension Table is, and how we can use it to create pivot table reports on multiple data sources.Skill level: Intermediate[...]

Continue reading»