Excel secrets, tricks, and magic. Learn macros and formulas to supercharge your Excel workflow to make life easy enough to take the rest of the day off.
1
Excel Data Manipulation: a Guide For Everyone
Introduction to Excel Data Manipulation using TEXTJOIN and Macros.
3 min read
2
How I Stopped Worrying and Learned to Love the Formula
Learn to define and utilize Excel formulas.
3 min read
3
Excel Showdown: Index Match vs. The Lookups
Learn to hate V-Lookups and H-Lookups in favor of Index Match.
1 min read
4
The One Excel Formula to Rule Them All
Unlock the secrets of Excel's Index Match.
4 min read
5
The Art of Excel Pivot Tables
Pivot complex Excel spreadsheets to summarize your data.
3 min read
6
Adventures in Excel: Power to the Pivot
Power up your Excel Pivot Tables with these pro moves.
6 min read
7
Doing the Excel Data Dance
Taking a step back to reflect on the problems Excel intends to solve.
3 min read
8
Dealing with Dirty Data in Excel
Cleaning data Excel in the absence of tools designed to do so.
7 min read
9
Taking Out the Trash: Dirty Data in Excel
Dealing With Dirty Data in Excel (continued).
4 min read
10
Getting Iffy With it: Conditional Statements in Excel
Effectively utilize conditionals such as IF statements in your Excel workflow.
4 min read
