Sort asc desc
Post 2
How I Stopped Worrying and Learned to Love the Formula
Learn to define and utilize Excel formulas.
Post 3
Excel Showdown: Index Match vs. "The Lookups"
Learn to hate V-Lookups and H-Lookups in favor of Index Match.
Post 6
Adventures in Excel: Power to the Pivot
Power up your Excel Pivot Tables with these pro moves.
Post 7
Doing the Excel Data Dance
Taking a step back to reflect on the problems Excel intends to solve.
Post 8
Dealing with Dirty Data in Excel
Cleaning data Excel in the absence of tools designed to do so.
Post 10
Getting Iffy With it: Conditional Statements in Excel
Effectively utilize conditionals such as IF statements in your Excel workflow.
Post 11
Yes...If(And)): Excel’s Mighty “IF” Statement
A deep dive into Excel’s implementation of IF statements and their significance.