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

Unlock this course with a free trial

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

Summing across worksheets: FP&A modeling techniques

Summing across worksheets: FP&A modeling techniques - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Summing across worksheets: FP&A modeling techniques

“

- [Instructor] How many times have you done this in a consolidation? For revenue, you link yourselves to each instance on each worksheet. Chicago, Dallas, Boston, Miami, St. Louis. Chicago, Dallas, Boston, Miami, St. Louis. Then, you take this formula, copy it down, copy it down, copy it down, and then you're done, right? Wrong. What happens if you find out that you have a new facility in a new city, like Philadelphia? Well, then you got to go back over to your consolidation, add in +Philadelphia, D5, Enter. copy, paste, copy, paste, paste, paste, paste, and so on. Now, what if you could consolidate dozens of departmental budgets or business unit financial performance without a single cell reference ever needing to change? Well, that's what we're going to talk about in this lesson. I call it the sum of worksheets approach. While some people refer to it as 3D modeling, what it allows you to do is to perform consolidations across sheets with one elegant formula. It's one of the cleanest…

Contents