Excel
Pro Excel secrets and magic. The kind of industry knowledge to put junior finance guys out of business.
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel
Dynamically load data in smart pivot tables.
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.
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.
Your Invitation to the Excel Pivot Party
Becoming well-versed in pivot tables to the point where it’s a problem.
Slicing Excel: The Way of The Knife
Slicing your Excel data to be presentable for the less tech-savvy.
Yes...If(And)): Excel’s Mighty “IF” Statement
A deep dive into Excel’s implementation of IF statements and their significance.
Getting Iffy With it: Conditional Statements in Excel
Effectively utilize conditionals such as IF statements in your Excel workflow.
Taking Out the Trash: Dirty Data in Excel
Dealing With Dirty Data in Excel (continued).
