Pivot Tables 3 Ways to Display (Multiple Items) Filter Criteria in a Pivot Table February 21, 201744 comments
Macros & VBA The SUBTOTAL Metrics Macro – Create a Summary Table of All Function Types February 9, 201711 comments
Formulas The Excel SUBTOTAL Function – Calculations on Filtered & Visible Cells Only February 9, 201735 comments
Library, Tips, Tips & Shortcuts How to Create a GIF Image with a Progress Bar or Timeline January 16, 20175 comments
Pivot Tables Pivot Table Defaults to Count Instead of Sum & How to Fix It December 19, 201619 comments
Library, Tables & Data How to Turn OFF Structured References in Excel Table Formulas December 1, 201616 comments