Microsoft Excel 2013: Data Analysis and Business Modeling

Chapter 14. Three-dimensional formulas

Question answered in this chapter:

• Is there an easy way to set up 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 learn how to set up workbooks in which the individual ...