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, [...]
Changes Continued in Dynamic Excel # in 2023 I am sitting on a train, looking out the window at the Pacific Ocean, as I make my way to Santa Barbara to celebrate the Christmas holiday with family. Nothing to do for the next 5 hours. Given that the year is coming to an end, this [...]
