Max Mileaf

20 Posts

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

Max Mileaf

20 Posts

Down the block from a literal battleship

Twitter

Excel

PowerPivot 3: Managing the Data Model

Analyzing ginormous files with Microsoft PowerPivot.

Excel

PowerPivot 2: What's the Deal with Delimiters?

Working with large flat files in PowerPivot.

Excel

Power to the Pivot Redux: Enter PowerPivot

Dipping into Microsoft's PowerPivot add-on for Excel.

Excel

Create an Iterative List in Excel Without Any Real Coding

Roll On Through: This isn't standard programming... THIS IS EXCEL! We get creative in Excel by making FOR loops without using VBA.

Excel

Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamically load data in smart pivot tables.

Excel

I Owe My Job to Mr. Robot

Entering the Dataverse.

Excel

Active-X Gonna Give it to Ya

Excel offers the ability to name a particular range (or collection of cells). Learn Named Ranges and the Active Xs who Love Them.

Excel

Your Invitation to the Excel Pivot Party

Becoming well-versed in pivot tables to the point where it’s a problem.