Excel

Pro Excel secrets and magic. The kind of industry knowledge to put junior finance guys out of business.

PowerPivot 3: Managing the Data Model

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

PowerPivot 2: What's the Deal with Delimiters?

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

Power to the Pivot Redux: Enter PowerPivot

Dipping into Microsoft's PowerPivot add-on for Excel.
Excel
4 min read
Max
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
Max
September 13

Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

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

Importing Excel Datetimes Into Pandas, Part II

Import dates & times from Excel .xlsx files into Pandas!

I Owe My Job to Mr. Robot

Entering the Dataverse.
Excel
8 min read
Max
August 14

Importing Excel Datetimes Into Pandas, Part I

Pandas & Excel, Part 1.

Active-X Gonna Give it to Ya

Excel Named Ranges and the Active Xs who Love Them.
Excel
6 min read
Max
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
Max
July 21