Post 1
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.
Post 12
Slicing Excel: The Way of The Knife
Slicing your Excel data to be presentable for the less tech-savvy.
Post 13
Your Invitation to the Excel Pivot Party
Becoming well-versed in pivot tables to the point where it’s a problem.
