Effectively Using Excel 365 Tables It has been estimated that fewer than 5% of Excel users work with Excel 365 Tables, as part of their custom Excel business solutions. That said, the number of people currently using Excel Tables has never been greater, and it is picking up momentum by the day. As such, [...]
How to Program Excel's Dynamic Array Functions How to Program Excel Dynamic Array Functions in Microsoft Excel in 2024 is far different than it was just a few years ago. The Microsoft Corporation has been making a lot of significant changes to Microsoft Excel. First, and most importantly, Microsoft rebuilt Excel’s Calculation Engine in 2018. Since [...]
Modeling Dynamic Excel 365 in 2024 for Business It is February 2024 and the solutions I am developing right now will for my business clients will most likely be outdated within the year. Why? Because the Microsoft Excel Team has been making so many monumental changes in Excel, that Excel 365 is now called "Dynamic [...]
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 [...]
