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 [...]
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 [...]
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 [...]
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, [...]
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 [...]
