Tables Beginner to Advanced Tables, are still a largely unknown feature in Microsoft Excel development: Most Excel users have never heard of Excel Tables. Many Excel programmers still do not use Excel Tables. Fewer of those Excel programmers work with Power Query Tables. Luckily most have used or still use Pivot Tables. A handful of [...]
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 [...]
Favorite Excel 365 User Interface Techniques The user experience is a critical component in any good Excel solution. How easy can you make it on the user, to use the file? How intuitive can you make it? How automated can you make it? Well, there are tools and techniques that not only make it easier [...]
Microsoft Excel 365 Dynamic Array Functions to use w/ Excel Tables ~ Filter ~ Unique ~ ChooseCols ~ Take ~ GroupBy ~ PivotBy ~ Use Excel DAFs to Select Data from an Excel Table If you want to extract data from an Excel Table, these Dynamic Array Functions are the ones to look at. [...]
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 [...]
How do Excel Tables remember formulas If you've used tables before you have seen your formulas automatically expand and contract with your data. This is a pretty handy feature of the tables. Some might say they just copy and paste the formulas, but this is not true. (See this blog post to see why structured [...]
Working with Microsoft Excel 365 Tables in VBA This blog post will be based on Working with Microsoft Excel tables in VBA. They present some unique issues, which has to do with how their structured in the object model. Good or bad, it's what we have. These are based on my trial and errors, [...]
Use Structured References in Excel Tables Using structured references in Excel Tables provide many benefits. By using structured references in tables, you can optimize your Excel Functions. Excel Table structured references enhance data analysis and simplify Excel programming. The results are files that are easier to use, and easier to program. We suggest you work with [...]
