Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518

Download Excel File: https://ift.tt/2O0QoBY
In this video we embark into the New World of Spilled Arrays. Which will require us to re-think how we use Excel. In this video learn about The New Office 365 Dynamic Array Formulas and the Excel Calculation engine which will allow us to create a Budgeted Income Statement either with using Standard Formulas and Mixed Cell References or with a Dynamic Spilled Array Formula.
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) https://www.youtube.com/watch?v=7jJMDGZpjSk

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.