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

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?

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

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

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

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

I Owe My Job to Mr. Robot

Entering the Dataverse.
Excel
8 min read
August 14
Active-X Gonna Give it to Ya

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

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