From the course: Excel for Financial Planning and Analysis (FP&A)

Unlock the full course today

Join today to access over 23,700 courses taught by industry experts.

Challenge: Flexing data and dynamic ranges for an FP&A model

Challenge: Flexing data and dynamic ranges for an FP&A model - Microsoft Excel Tutorial

From the course: Excel for Financial Planning and Analysis (FP&A)

Start my 1-month free trial Buy for my team

Challenge: Flexing data and dynamic ranges for an FP&A model

“

(lively music) - In this next challenge, I'm going to encourage you to capture a dynamic range using offset. If I go all the way down to the bottom, you'll recall that in a prior video we used offset starting at A34, going one column to the right, and then we have a width positive being based upon the number of months. In this next example, I'm using the same kind of functionality, except that instead of determining exactly the cell that I want to anchor at, I'm using an index function saying, let's take a look at B34 to M34, which you can see is the entirety of the range of secondary research, that one row. And then my column coordinate being determined by the month function of N2. If we were to take a look all the way over here, N2 is the starting month of January. The last argument that we have here for width is what you can see here at A49, 12 months forward into the future. But what I'm going to ask you to do…

Contents