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

Unlock the full course today

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

Solution: Segmenting data for use in an FP&A model

Solution: Segmenting data for use in 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

Solution: Segmenting data for use in an FP&A model

“

(upbeat electronic music) - [Instructor] So how did you do? There were a lot of different options that you could have taken here to take a lot of this static functionality and make it a little bit more dynamic. I'm going to share with you some of the suggestions that I might make. So over here on the filter page, you recognize that all of this was a static range from A2 to M4977. This was a static range too from C2 to 4977. Well, take a look over here at what I did on my filter dynamic solution. If you take a look, this says filter Company_Sales. So rather than have this be a static range, I have just simply made it dynamic, which means that as you add in additional columns or additional rows into the company's sales dynamic table, this is automatically going to update. The next piece, I've added in an indirect function, which you recall takes a look at a text string and it says, let me evaluate the text string and…

Contents