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