Modeling, Tables & Data, Tips, Tips & Shortcuts Drop-down List Arrow Always Visible for Data Validation November 25, 201473 comments
Answers, Formulas, Modeling, Pivot Tables, Tables & Data How to Create Dependent Cascading Drop-down Lists November 18, 2014106 comments
Add-in, Formulas, Macros & VBA, Modeling, Tools SUMIFS, COUNTIFS, AVERAGEIFS Filter & Analyzer Add-in October 29, 201317 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
Charts & Dashboards, Finance, Formulas, Modeling Stacked Column Bar Chart Alternatives – Find the Missing Trends May 23, 201321 comments
Finance, Formulas, Modeling Excel Formula to Calculate Commissions with Tiered Rate Structure May 15, 201399 comments
