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 [...]
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 [...]
Learn Expert Excel Skills ~ From the Top Excel Experts ~ Work with our Team of Excel 365 Experts at Excel and Access, LLC, and our International Team of Associates ~ USA UK CAN AU ~ Programming Excel 365 w/ Power Query is not [...]
Quick Power Query Solutions Power Query sounds complicated, but in actuality, Power Query is quite easy to learn, and pretty easy to use. Sure, it can get complex if you press it, if you add M-Code and such, but to start, it is relatively easy to learn. You can get a great start by watching [...]
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 [...]
FLUID Excel Solutions FLUID Excel Solutions are designed around one simple idea: let the data flow. Data should move through an Excel solution as uninterrupted as possible—from its source, through any transformations and calculations, to wherever it ultimately needs to go. Using Excel Tables, Power Query, the Data Model, Pivot Tables, Dynamic Array Functions, [...]
