Max Mileaf
Max Mileaf
Max Mileaf
Down the block from a literal battleship

Former mental health professional who pulled the biggest career 180 in recent history. Currently crunches numbers using a very particular set of skills...namely creating data fires using digital twigs

PowerPivot 3: Managing the Data Model

Analyzing ginormous files with Microsoft PowerPivot.
Excel
5 min read
June 06

PowerPivot 2: What's the Deal with Delimiters?

Working with large flat files in PowerPivot.
Excel
6 min read
June 02

Power to the Pivot Redux: Enter PowerPivot

Dipping into Microsoft's PowerPivot add-on for Excel.
Excel
4 min read
May 25

Roll On Through: Create an Iterative List in Excel Without Any Real Coding

This isn't standard programming...THIS IS EXCEL!
Excel
3 min read
September 13

Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamically load data in smart pivot tables.
Excel
7 min read
September 01

I Owe My Job to Mr. Robot

Entering the Dataverse.
Excel
8 min read
August 14

Active-X Gonna Give it to Ya

Excel Named Ranges and the Active Xs who Love Them.
Excel
6 min read
August 10

Your Invitation to the Excel Pivot Party

Becoming well-versed in pivot tables to the point where it’s a problem.
Excel
4 min read
July 21

Slicing Excel: The Way of The Knife

Slicing your Excel data to be presentable for the less tech-savvy.
Excel
6 min read
July 05

Yes...If(And)): Excel’s Mighty “IF” Statement

A deep dive into Excel’s implementation of IF statements and their significance.
Excel
4 min read
June 20