Microsoft® Excel® 2010: Data Analysis and Business Modeling

Chapter 15. Three-Dimensional Formulas

Questions answered in this chapter:

• Is there an easy way to setup a multiple-worksheet workbook in which each worksheet has a similar structure? Can I easily create formulas that involve cells in multiple worksheets?

• In many business situations you have to set up workbooks in which each worksheet has a similar format or structure. Here are some examples:

• You want to track your company’s sales in each region of the country in a separate worksheet and then summarize total sales in a summary worksheet.

• You want to track your company’s sales for each month in a separate worksheet and then summarize year-to-date sales in a summary worksheet.

In this chapter, you will learn how to set up workbooks in which the individual ...