Powerpivot

Powerful data analysis and data modeling in Excel using Power Pivot.

Microsoft Office 64-Bit

The Level-Up: What I've Learned in the Four Years Since My Last Post

A journey through Power BI, PowerPivot, PowerQuery, XLOOKUP, and all the goodies of 64-bit Microsoft Office.

PowerPivot 3: Managing the Data Model

PowerPivot 3: Managing the Data Model

Analyzing ginormous files with Microsoft PowerPivot.

PowerPivot 2: What's the Deal with Delimiters?

PowerPivot 2: What's the Deal with Delimiters?

Working with large flat files in PowerPivot.

Power to the Pivot Redux: Enter PowerPivot

Power to the Pivot Redux: Enter PowerPivot

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