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 [...]
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, [...]
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 [...]
Database Replacement Solutions in Microsoft Excel 365 with Power Query ~ All Applications lead to Excel. Why not just start there ~ Many businesses hire us to make what we term "Database Replacement Solutions" in Microsoft Excel 365, with Power Query. These are not Databases, as this is Microsoft Excel. Why it works: The advanced [...]
Here is Why I Personally use Power Query in all of my Excel 365 Solutions for Business ~ Because it is just so much easier this way ~ Power Query is why we changed our business model in 2025 ~ Excel and Access , LLC should now be Excel and Power Query, LLC ~ [...]
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 [...]
Custom Excel 365 Solutions Take a lot of Experience to Program There is a huge difference between fixing an existing Excel workbook and building a new one from scratch. ~ Knowing how Excel works and knowing how to build a 100% automated & Integrated, forward-looking, 100% custom solution, in Excel 365 for Teams are not [...]
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, [...]
