Articles about Microsoft Excel 365, Power Query, the Data Model, Dynamic Arrays, Pivot Tables, automation, Access, and database development.
We write about the techniques we use, the features we test, and how we approach Excel development.
Using Codex in Custom Excel 365 Development Codex Desktop didn’t just write the code. It built the entire Excel solution ~ But we have a long way to go ~ The Codex Desktop application did everything the programmer would normally do, if they knew how. Codex created a solution that many Excel programmers cannot. [...]
As we move toward 2027, I see a change taking place in Excel development. I've been developing Excel solutions since 1999, and I've watched Excel development change many times. I formed Excel and Access, LLC in 2004 and have been building business solutions for clients ever since. What I'm seeing now feels different. It isn't [...]
Excel Beyond the CELL Excel is built on cells. We don't build solutions around them. At Excel and Access, LLC, we build Excel 365 solutions around the business process, the data and the result—not around individual worksheet cells. Our background in Excel, Access, SQL Server and database programming, together with Microsoft Excel MVP and [...]
ChatGPT in Excel 365 ChatGPT, Claude, and CoPilot will change how Microsoft Excel is programmed. Is that a good thing or a bad thing? It does not matter. No matter your personal opinion, nor mine, the fact is this, the ChatGPT Excel Add-in, when combined with Codex, will change how many Excel developers approach Excel [...]
Why Mastering Power Query in 2027 Matters The way Power Query is used in custom Excel development has changed over the past few years. Excel developers are learning that Power Query can do much more than transform data. Power Query can create complete reports, populate PivotTables with external data, feed Power Pivot through the Excel [...]
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. [...]
Power Query REA Form Using a Power Query Table as a Review, Edit and Append Form ( REA ) A new Method of Excel Development Using a Power Query Table as a Data Review Edit and Append Entry Form. In This Post: We demonstrate how to quickly and easily select, review, [...]
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 [...]
Pushing Excel 365 Programming to its Limits Excel 365 Desktop for the PC is the Ultimate version of Microsoft Excel, and Excel has never been more powerful than it is today. Excel 365 is not just easier to use, it is much easier to program as well, with all of the changes the Excel Team [...]
