Microsoft Office Tutorials and References
In Depth Information
6 Creating Templates and
Working with Multiple
Worksheets and Workbooks
Many business applications require data from several worksheets to be summarized on
one worksheet. For example, a company may keep data from various regions in differ-
ent worksheets. If you enter each region’s inventory data on a worksheet in a workbook,
you can click the sheet tabs at the bottom of the Excel window to move from worksheet
to worksheet, or region to region. On another, separate worksheet, you then can enter
formulas that reference cells on the other worksheets, which allows you to summarize
worksheet data. The process of summarizing data included on multiple worksheets on one
worksheet is called consolidation .
Another important concept presented in this chapter is the use of a template. A
template is a special workbook you can create and then use as a pattern to create new,
similar workbooks or worksheets. A template usually consists of a general format (work-
sheet title, column and row titles, and numeric format) and formulas that are common to
all the worksheets. One effi cient way to create the workbook is fi rst to create a template,
save the template, and then copy the template to a workbook as many times as necessary.
Project — Profi t Potential Worksheets with
Cone Chart
The project in the chapter follows proper design guidelines and uses Excel to create the
worksheet shown in Figure 6–1. NextDVR sells DVR (digital video recorder) equipment
to cable television providers throughout the United States. The company purchases DVR
equipment from a number of suppliers and then resells the equipment to customers in
three regional offi ces. The company’s chief operating offi cer would like to know the profi t
potential of the inventory currently stored at the three regional offi ces. She also would
like to see the regional information on separate worksheets, and then consolidated into
one worksheet.
Search JabSto ::

Custom Search