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 [...]
Microsoft Excel's New Dynamic Array Functions Simplify Excel Programming The Microsoft Corporation is on a tear! First, it rebuilt Excel's Calculation Engine in 2018. Then it released a series of new Dynamic Array Functions for Office 365 in 2020. Microsoft's Dynamic Array Functions simplify Excel Programming. Microsoft Excel 365 is in a constant state of [...]
Excel Users Love Drop-Down Lists aka Validation Controls Excel Users Love Using Drop-Down List because they make data entry quicker and more accurate. When it comes to working with Microsoft Excel, users like it when Excel is easy to use. The easier you can make it, the more they like working [...]
Interactive Reports in Excel Just Got Easier Until recently, when you wanted to build an interactive and dynamic Excel report, one that allowed the user to build a quick report, on the fly, you would need to write many formulas, and often you would need to add complex VBA/macros. But the times are changing. Microsoft [...]
The 4 Best Excel Budget Formulas Excel Functions for Budgeting & Forecasting in Microsoft Excel 365, in 2026 Since we published this post in 2021, much has changed in the world of Excel. How we program Microsoft Excel 365 has ENTIRELY changed. Microsoft Excel 365 Programming is now Range-Based ( Dynamic Arrays ), not Cell-Based [...]
