Pro Excel secrets and magic. The kind of industry knowledge to put junior finance guys out of business.
Dynamically load data in smart pivot tables.
Pandas and Excel Pt. 2
Entering the Dataverse.
Pandas & Excel, Part 1.
Excel Named Ranges and the Active Xs who Love Them.
Becoming well-versed in pivot tables to the point where it’s a problem.
Slicing your Excel data to be presentable for the less tech-savvy.
A deep dive into Excel’s implementation of IF statements and their significance.
Effectively utilize conditionals such as IF statements in your Excel workflow.