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.
of 2