Post 1
Introduction to Excel Data Manipulation using TEXTJOIN and Macros.
Post 2
Learn to define and utilize Excel formulas.
Post 3
Unlock the secrets of Excel's Index Match.
Post 4
Pivot complex Excel spreadsheets to summarize your data.
Post 5
Power up your Excel Pivot Tables with these pro moves.
Post 6
Taking a step back to reflect on the problems Excel intends to solve.
Post 7
Cleaning data Excel in the absence of tools designed to do so.
Post 8
Dealing With Dirty Data in Excel (continued).
Post 9
Effectively utilize conditionals such as IF statements in your Excel workflow.
Post 10
A deep dive into Excel’s implementation of IF statements and their significance.
Post 11
Slicing your Excel data to be presentable for the less tech-savvy.
Post 12
Becoming well-versed in pivot tables to the point where it’s a problem.
Post 13
Excel Named Ranges and the Active Xs who Love Them.
Post 14
Dynamically load data in smart pivot tables.
Post 15
This isn't standard programming...THIS IS EXCEL!
Post 16
Learn to hate V-Lookups and H-Lookups in favor of Index Match.