Slicing your Excel data to be presentable for the less tech-savvy.
A deep dive into Excel’s implementation of IF statements and their significance.
Effectively utilize conditionals such as IF statements in your Excel workflow.
Dealing With Dirty Data in Excel (continued).
Cleaning data Excel in the absence of tools designed to do so.
Taking a step back to reflect on the problems Excel intends to solve.
Power up your Excel Pivot Tables with these pro moves.
Pivot complex Excel spreadsheets to summarize your data.
Unlock the secrets of Excel's Index Match.
Learn to hate V-Lookups and H-Lookups in favor of Index Match.