Microsoft Office Tutorials and References
In Depth Information
Would your worksheet survive without you?
and certainly no less. If your worksheet contains a lot of data that your audience doesn’t
really need to see—which is almost always the case—you can create a summary sheet (like
the one shown in Figure 5-3) specifically for the purpose of mass consumption. If your
worksheet will have more than one type of audience, create different summary sheets for
each group, all using the same underlying data.
Would your worksheet survive without you?
If you are creating worksheets that might at some point be used by others, make sure they
are understandable and well documented. Most of us don’t think about documentation,
but every worksheet you create for business or personal use should be created with the
possibility in mind that others might need to figure it out someday—possibly without your
help. If you change jobs, you will be leaving a good legacy behind for the next person,
which reflects well on you. A little documentation goes a long way, as shown in Figure 5-5.
You can use the Comment command to add notes anywhere a little explanation is in order.
Figure 5-5 Make sure critical worksheets are understandable and well documented.
For information about documenting your worksheets, see “Adding comments to cells” in
Chapter 8.
You also need to prepare worksheets containing important personal records with
survivability in mind. If you were to pass away unexpectedly, you’d want to leave your family with
clear financial worksheets.
Does the worksheet rely on imported data?
Many people work with data that is compiled elsewhere as the basis for their worksheet
analyses. For example, a database located on your computer or somewhere on a network
is often the repository for specific information you extract and analyze. If this is the case,
try to make it easy on yourself. Often, people use the ad hoc approach to working—that
Search JabSto ::




Custom Search