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 [...]
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 [...]
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, [...]
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, [...]
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 [...]
Mentoring Modern Excel Development with Power Query Learn how to build better Excel solutions. Excel mentoring is for people who already work in Excel and want to improve how they design and build solutions. This is not canned training. We work one-on-one, starting with what you already know, what you need to accomplish, and the [...]
Excel Dynamic Arrays for Dashboard Reporting Everyone reading this has most likely heard of Excel Dashboards. If you are an Excel programmer, you should have heard of the new Dynamic Array Functions. Knowing how to properly leverage these functions will greatly simplify your Excel programming. Here we show how to use a few of the [...]
Import Access Data into Excel via Power Query Much has changed since 2018; the year Microsoft Excel went dynamic. The way people import Access data into Excel has dramatically changed too. These days, Power Query is how data importation is done. There is no need to use VBA, no need to copy and paste. Simply [...]
