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.
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 Dynamically load data in smart pivot tables.
I Owe My Job to Mr. Robot A personal origin story about entering the Dataverse inspired by a television series.
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.
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.
