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