From the course: Excel: Financial Modeling with Dynamic Arrays

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Prerequisites for dynamic array modeling

Prerequisites for dynamic array modeling - Microsoft Excel Tutorial

From the course: Excel: Financial Modeling with Dynamic Arrays

Start my 1-month free trial Buy for my team

Prerequisites for dynamic array modeling

“

- [Instructor] Before we get started on our deep dive into the world of financial modeling with Excel's dynamic arrays, here are a few ways to get the most out of this course. Firstly, you should have a reasonable knowledge of Excel, be able to create formulas and use formula references. You'll need to have a recent version of Excel for Microsoft 365, 2021, or Excel for the web. You'll need one of these versions so that you can try out the techniques because dynamic arrays are not available in previous versions. This is not a sit-back-and-watch kind of course. You'll get the most out of our time together if you actually build the solutions yourself. So that you can work along with me, I've made available all the files I use for demonstration, and there's one file per chapter. You'll find the completed versions usually hidden on the same tab. Chapters five and six work you through a case study using the techniques from previous chapters. Together, we'll be building a three-way…

Contents