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 [...]
Remote One-On-One Microsoft Excel Training Personalized One-On-One Excel Training When it comes to learning Microsoft Excel, remote one-on-one Microsoft Excel training is the best way to learn Microsoft Excel. There literally is no faster or more effective way to learn Microsoft Excel than doing it one-on-one, how could there be? It is you, the [...]
Intermediate One-On-One Excel Training When it comes to intermediate Excel training, remote one-on-one training is simply the best way to learn Excel. For one, you don't have to leave the house. Secondly, it is you, the instructor, and your Excel file. No distractions, no other students, just you and our Excel expert. Thirdly, this is [...]
Beginner One-On-One Excel Training When it comes to learning Microsoft Excel, remote one-on-one training is the best way to learn. There literally is no faster or more effective way to learn Excel. With Beginner One-On-One Excel Training You work directly with an expert Excel instructor, focused on you and your needs. All of our Excel [...]
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 [...]
Using Excel VStack to Consolidate Datasets Let's start with this, why would you want or need to consolidate datasets in Microsoft Excel? Because your Excel programmer decided to place like data across multiple tabs and multiple workbooks. They could have just as easily if not more easily, put all of the data in one [...]
10 Intermediate Excel Programming Skills to Advance Your Career Can improving your Excel skills help to advance your career? Microsoft Excel is the most used spreadsheet application on the market today. If you work in business, or in an office, chances are that you work with Microsoft Excel on a daily basis. Knowing these [...]
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 [...]
