Self-Referencing Query, Explained I have heard people talk about self-referencing queries for a few years now. Up until recently, I have never had the need to try them. But then I saw a video on ExcelOffTheGrid.Com that covered them in great detail. What Mark showed really got my attention; made me think, can I use [...]
Receiving the Microsoft Excel MVP & Microsoft Access MVP Awards I am honored to share that I have been recognized as both a Microsoft Excel MVP and a Microsoft Access MVP. ( To be awarded in both Excel and Access is rare, currently there are estimated to be around 20 people worldwide with this combination. [...]
Tables Beginner to Advanced Tables, are still a largely unknown feature in Microsoft Excel development: Most Excel users have never heard of Excel Tables. Many Excel programmers still do not use Excel Tables. Fewer of those Excel programmers work with Power Query Tables. Luckily most have used or still use Pivot Tables. A handful of [...]
Power Query Joins or Lookup Functions ~ Old School Programming (Pre-2018) Versus New School Development (Post-2018) ~ Excel has Changed: Power Query has never been used more than it is now, neither have Excel Tables, both are quickly gaining acceptance and momentum. Microsoft has been very clear on the future direction of Excel 365. Online, [...]
Microsoft Excel 365 Programming Best Practices In Microsoft Excel 365 there are 10,000 ways to do anything. Well, maybe not that many, but usually there are at least 5 ways to do anything In Excel. Which way(s) are the best? Which are the best programming practices in Microsoft Excel 365 in 2026? In this [...]
Evaluating Power Query Usage in Microsoft Excel Is Power Query a viable component in a fully automated Microsoft Excel 365 Solution for Business? If so, in what capacity? How far do you take Power Query; how do you leverage its POWER. Let's find out, via a few examples What is Optimal Usage of Power [...]
Dynamic Excel 365 Development - Step by Step Index/Match or XLookup, Concatenate/Concat or TextJoin, GroupBy, Pivot Tables or PivotBy. Hundreds of cells with formulas, or just one dynamic one that Spills. How you program Excel has changed; Excel Development Step by Step will help you to get up to date. Requirement, Excel 365. It is [...]
Changes Continued in Dynamic Excel # in 2023 I am sitting on a train, looking out the window at the Pacific Ocean, as I make my way to Santa Barbara to celebrate the Christmas holiday with family. Nothing to do for the next 5 hours. Given that the year is coming to an end, this [...]
Using Excel VStack to Consolidate Datasets Let's start with this, why would you want or need to consolidate datasets in Microsoft Excel? Because your Excel programmer decided to place like data across multiple tabs and multiple workbooks. They could have just as easily if not more easily, put all of the data in one [...]
Interactive Reports in Excel Just Got Easier Until recently, when you wanted to build an interactive and dynamic Excel report, one that allowed the user to build a quick report, on the fly, you would need to write many formulas, and often you would need to add complex VBA/macros. But the times are changing. Microsoft [...]
