Section 8: Advanced Modeling

8.2 Working with Circular References in Excel

Creating Cell References that Span Across Worksheets

There are several reasons why you may choose to use multiple worksheets in your spreadsheet models. For example, a large model may be split into a few smaller models, each of which can be easily put on separate worksheets.

The combined results of these parts can be displayed on a summary worksheet.

This approach simplifies the presentation of the overall spreadsheet model and provides a way to include all of the complexity necessary for the large model to be meaningful and accurate.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.