Excel

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

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.

Create an Iterative List in Excel Without Any Real Coding

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.

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.

Importing Excel Datetimes Into Pandas, Part II

Importing Excel Datetimes Into Pandas, Part II

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

Hacker using a Laptop

I Owe My Job to Mr. Robot

A personal origin story about entering the Dataverse inspired by a television series.

Importing Excel Datetimes Into Pandas, Part I

Importing Excel Datetimes Into Pandas, Part I

Parse dates and times from Excel .xlsx correctly when using Pandas.

Active-X Gonna Give it to Ya

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.