Getting Iffy With it: Conditional Statements in Excel
Effectively utilize conditionals such as IF statements in your Excel workflow.
Taking Out the Trash: Dirty Data in Excel
Dealing With Dirty Data in Excel (continued).
Dealing with Dirty Data in Excel
Cleaning data Excel in the absence of tools designed to do so.
Doing the Excel Data Dance
Taking a step back to reflect on the problems Excel intends to solve.
Adventures in Excel: Power to the Pivot
Power up your Excel Pivot Tables with these pro moves.
The Art of Excel Pivot Tables
Pivot complex Excel spreadsheets to summarize your data.
The One Excel Formula to Rule Them All
Unlock the secrets of Excel's Index Match.
Excel Showdown: Index Match vs. The Lookups
Learn to hate V-Lookups and H-Lookups in favor of Index Match.
How I Stopped Worrying and Learned to Love the Formula
Learn to define and utilize Excel formulas.
Excel Data Manipulation: a Guide For Everyone
Introduction to Excel Data Manipulation using TEXTJOIN and Macros.