Microsoft Office Tutorials and References
In Depth Information
An additional sheet that I often use is named TOC, for Table Of
Contents. With a workbook that can have 20 to 30 sheets, it’s often
difficult to find the right worksheet quickly. This worksheet
maintains annotated links to the supporting worksheets. It also is a
convenient place to add notes about the figures, including to-do
items for pages.
You never print the TOC worksheet for others. Instead, you use it to
manage your dashboard workbook.
An Overview of the Report Page
This figure shows the report that I’ll show you how to create in this
chapter. It illustrates the four elements that are common to most
dashboard reports: formatting, formulas, Camera objects, and
Figure 8-1. The dashboard report explained in this chapter.
Formatting: To a large degree, formatting makes the difference
between a dashboard report and an ordinary one with some charts