Pivot Tables, Power Pivot, Power Pivot/Query/BI, Tables & Data The Calendar Table (Date Dimension) Explained for Power Pivot & Power BI July 5, 201721 comments
Tips, Tips & Shortcuts Reverse Partial Match Lookup to Filter for a List in Excel June 8, 201729 comments
Tips, Tips & Shortcuts 2 Ways to Filter for List of Items in Excel + Video Tutorial May 31, 201732 comments
Macros & VBA, Tips, Tips & Shortcuts 3 Tips to Save and Close All Open Excel Workbook Files + Macro May 8, 201719 comments
Pivot Tables Create Multiple Pivot Table Reports with Show Report Filter Pages April 20, 201758 comments
Formulas, Tips, Tips & Shortcuts How to Create a List of Random Numbers with No Duplicates or Repeats April 12, 201769 comments
Keyboard Shortcuts, Tips & Shortcuts Copy Dates & Fill Series of Numbers with the Fill Handle in Excel April 6, 201731 comments
Tips, Tips & Shortcuts 2 Ways to Use the Ctrl+Enter Keyboard Shortcut in Excel March 30, 201745 comments
