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