Max Mileaf
One of three therapists in the known universe who knows how to use a computer. Finds meaning in highly protected data, in a cave, utilizing nothing but a box of scraps.
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel
Dynamically load data in smart pivot tables.
I Owe My Job to Mr. Robot
Entering the Dataverse.
Active-X Gonna Give it to Ya
Excel Named Ranges and the Active Xs who Love Them.
Your Invitation to the Excel Pivot Party
Becoming well-versed in pivot tables to the point where it’s a problem.
Slicing Excel: The Way of The Knife
Slicing your Excel data to be presentable for the less tech-savvy.
Yes...If(And)): Excel’s Mighty “IF” Statement
A deep dive into Excel’s implementation of IF statements and their significance.
Getting Iffy With it: Conditional Statements in Excel
Effectively utilize conditionals such as IF statements in your Excel workflow.
Taking Out the Trash: Dirty Data in Excel
Dealing With Dirty Data in Excel (continued).
Dealing with Dirty Data in Excel
Cleaning data Excel in the absence of tools designed to do so.
Doing the Excel Data Dance
Taking a step back to reflect on the problems Excel intends to solve.
