课程: Excel for Financial Planning and Analysis (FP&A)

今天就学习课程吧！

今天就开通帐号，24,100 门业界名师课程任您挑！

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

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

课程: Excel for Financial Planning and Analysis (FP&A)

开始一个月试用 购买团队方案

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…

内容