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. =SORT(FILTER(CHOOSECOLS(rangeEmployeeData,1,2,3,4,5,6,7),AgeColumn>AgeSelection),3,1) Microsoft's Dynamic Array Functions are a Game [...]
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 7 Best Excel Budget Formulas - Excel Functions for Budgeting & Forecasting in Microsoft Excel We were recently asked, "What are the 7 best advanced Excel functions for forecasting and budgeting for business?" What are the best Excel budget formulas? Given the number of Excel budgeting projects we have worked on over the [...]
