#Adventures in Excel

Excel secrets and magic. The kind of industry knowledge that could put financial analysts out of business.

Dealing with Dirty Data in Excel

Dealing with Dirty Data in Excel

Cleaning data Excel in the absence of tools designed to do so.
Doing the Excel Data Dance

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

Adventures in Excel: Power to the Pivot

Power up your Excel Pivot Tables with these pro moves.
The Art of Excel Pivot Tables

The Art of Excel Pivot Tables

Pivot complex Excel spreadsheets to summarize your data.
The One Excel Formula to Rule Them All

The One Excel Formula to Rule Them All

Unlock the secrets of Excel's Index Match.
Excel Showdown: Index Match vs. "The Lookups"

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

How I Stopped Worrying and Learned to Love the Formula

Learn to define and utilize Excel formulas.
Excel Data Manipulation: a Guide For Everyone

Excel Data Manipulation: a Guide For Everyone

Introduction to Excel Data Manipulation using TEXTJOIN and Macros.