ChatGPT in Excel 365 Here we will share what we have learned about using ChatGPT in Excel 365. Is it accurate? Is it reliable? Is it easy to use? If you think using AI in Excel is the easy way to quick, accurate, consistent results, you are incorrect. Using AI in Excel is far from [...]
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 [...]
Excel Data Driven Solutions in 2026 Every new Excel solution we build starts with the Data, and it flows downstream from there. Understanding your data, where it comes from, cleaning it up, making sure you have all the columns you need, that is the first step in any custom Excel solution. The last step [...]
Favorite Excel 365 User Interface Techniques The user experience is a critical component in any good Excel solution. How easy can you make it on the user, to use the file? How intuitive can you make it? How automated can you make it? Well, there are tools and techniques that not only make it easier [...]
Leveraging Excel's Data Model ~ Excel Tables, Power Query, Power Pivot, and the Data Model ~ Proper Excel solutions start with Excel Tables. Advanced solutions leverage Power Query to transform the data into something useful. You could stop there, and use LAMBDA or a series of Dynamic Array Functions, onsheet, to get the results you [...]
