Keyboard Shortcuts, Tips & Shortcuts Excel Keyboard Shortcuts for the Menu Key (Right-click Context Menu) – Convert Text to Numbers – Ignore Errors January 21, 201423 comments
Add-in, Formulas, Macros & VBA, Modeling, Tools SUMIFS, COUNTIFS, AVERAGEIFS Filter & Analyzer Add-in October 29, 201317 comments
Add-in, Macros & VBA, Tables & Data, Tools Absolute Reference Add-in – Use the F4 Key in Structured Table Formulas October 9, 201342 comments
Tables & Data Excel Tables Tutorial Video – Beginners Guide for Windows & Mac October 1, 201373 comments
Charts & Dashboards Actual vs Budget or Target Chart in Excel – Variance on Clustered Column or Bar Chart August 19, 201376 comments
Charts & Dashboards Review of the Excel Dashboard Course from My Online Training Hub July 28, 20134 comments
Modeling, Pivot Tables, Power Pivot/Query/BI, Power Query How to Structure Source Data for a Pivot Table & Unpivot July 18, 201394 comments
Add-in, Formulas, Keyboard Shortcuts, Macros & VBA, Modeling, Tips & Shortcuts Quarter Sum Formulas Add-in July 1, 201321 comments
Add-in, Keyboard Shortcuts, Macros & VBA, Tips, Tips & Shortcuts Keyboard Shortcuts to Change Font & Fill Color or Cell Style June 9, 2013137 comments