Video Formulas, Macros & VBA, Power Pivot/Query/BI, Power Query, Tips, Tips & ShortcutsHow to Sort Drop Down Lists Automatically in ExcelFebruary 6, 20198 comments
Charts & Dashboards, Tips, Tips & ShortcutsWhen to Use Pie Charts – Best PracticesNovember 13, 201823 comments
Keyboard Shortcuts, Tips, Tips & Shortcuts7 Shortcuts for Working with Worksheet Tabs in ExcelOctober 17, 201813 comments
Macros & VBA, Tips, Tips & ShortcutsCreate Keyboard Shortcuts to Select the First or Last Sheet in ExcelOctober 17, 2018Add comment
Image Charts & Dashboards, Tips, Tips & ShortcutsExcel Hash: Episode 1 – Dynamic HistogramSeptember 5, 20181 comment
Video Keyboard Shortcuts, Tips, Tips & Shortcuts7 Keyboard Shortcuts for Selecting Cells and Ranges in ExcelAugust 20, 20188 comments
Video Tables & Data, Tips, Tips & ShortcutsHow to Add New Rows to Drop-down Lists Automatically – Dynamic Data Validation ListsAugust 13, 201822 comments
Video Tables & Data, Tips, Tips & ShortcutsHow to Create Drop-down Lists in Cells – Data Validation ListsAugust 8, 20187 comments