Dynamic Arrays Article
Microsoft has been hard at work updating Excel’s calculation engine. Depending on the version of Excel you’re using, you either have—or will have when you update—access to some capabilities that are sure to change how you think about and use Excel.
I wrote about one of the new capabilities called Dynamic Arrays for California CPA Magazine. In summary, when a formula returns multiple values, the results spill out of the formula into adjacent cells (the “spill” range).
If you’d like to learn more, check out the article below.
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.