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. [...]
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 [...]
Microsoft Excel 365 Dynamic Array Functions to use w/ Excel Tables ~ Filter ~ Unique ~ ChooseCols ~ Take ~ GroupBy ~ PivotBy ~ Use Excel DAFs to Select Data from an Excel Table If you want to extract data from an Excel Table, these Dynamic Array Functions are the ones to look at. [...]
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 [...]
Excel Transpose Methods Then and Now Microsoft Excel programmers have long used the PasteSpecial Transpose method to Transpose (Pivot) their data. While very useful, it is a manual process and such it does take more effort than desired. But that was then, this is now, and transposing Excel data just got much easier with the [...]
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 [...]
Microsoft Excel Should Be Easy to Use Based on my 37 years of programming in Microsoft Excel, I can personally tell you that there is absolutely no reason for Excel to frustrate you, or for Excel to be difficult to use. Simply put, Microsoft Excel should be easy to use. At Excel and Access, [...]
