Roll On Through: This isn't standard programming... THIS IS EXCEL! We get creative in Excel by making FOR loops without using VBA.
Dynamically load data in smart pivot tables.
Excel offers the ability to name a particular range (or collection of cells). Learn Named Ranges and the Active Xs who Love Them.
Becoming well-versed in pivot tables to the point where it’s a problem.
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.