Excel (page 1)
Pro-mode Excel secrets, macros, and magic. The kind of industry knowledge to put junior finance guys out of business.
Powerpivot
PowerPivot 3: Managing the Data Model
Analyzing ginormous files with Microsoft PowerPivot.
Powerpivot
PowerPivot 2: What's the Deal with Delimiters?
Working with large flat files in PowerPivot.
Powerpivot
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.
Code Snippet Corner
Importing Excel Datetimes Into Pandas, Part II
Import dates & times from Excel .xlsx files into Pandas!
Code Snippet Corner
Importing Excel Datetimes Into Pandas, Part I
Parse dates and times from Excel .xlsx correctly when using Pandas.