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

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?

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

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

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

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

Importing Excel Datetimes Into Pandas, Part II

Import dates & times from Excel .xlsx files into Pandas!
I Owe My Job to Mr. Robot

I Owe My Job to Mr. Robot

Entering the Dataverse.
Excel
8 min read
Max
August 14
Importing Excel Datetimes Into Pandas, Part I

Importing Excel Datetimes Into Pandas, Part I

Pandas & Excel, Part 1.