How-To Geek on MSN

Why I'm swapping my PivotTables for the PIVOTBY function in Excel

PivotTables are static relics; PIVOTBY is the responsive, resilient, and fully auditable future of the modern Excel professional.
Geeky Gadgets

Master Date Functions in Excel to Save Huge Amounts of Time

If you would like to improve your Excel workflows and spreadsheets and in the process save a huge amount of time you might be interested in mastering Excel date functions. Once mastered this knowledge ...

Create Dynamic Excel Data Validation Lists Using Table Spill Ranges

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets ...