Microsoft Office Tutorials and References
In Depth Information
Who is the audience?
Figure 5-4 You can use outlining to hide the detail for summary purposes.
For information about outlining, see “Outlining worksheets” in Chapter 8, “Worksheet editing
techniques.”
If the worksheet is for auditing or reference purposes, you probably want to see everything.
Orientation is a big issue here. You can print in either landscape (horizontal) or portrait
(vertical) format, so design your worksheet accordingly. Sometimes using a landscape
orientation helps if you have lots of columns. If you have an inordinate number of columns,
you might want to try segmenting your data into an overall system of worksheets—chunks
that realistically can be printed without losing context or readability. For example, the
sheet tabs at the bottom of the workbook shown in Figure 5-3 give evidence that the
displayed summary sheet actually consolidates the data from several other sheets in the same
workbook.
Of course, there are many other ways to summarize, analyze, and otherwise distill data in
Excel, including charts, tables, PivotTables, PivotCharts, formulas, functions, and more. The
list of cross-references to the related sections in this topic would be long; just check the
table of contents.
Who is the audience?
Are you building a worksheet for your own use, or will you be sharing it with others online
or in printed form? In other words, does the worksheet need to look marvelous or is fancy
formatting optional? Do you need to create a big-picture summary or overview for others?
You definitely need to consider your audience when deciding how your worksheet is going
to look.
If you’re close to the data in your worksheet—that is, this is your job—you probably think
the details are a lot more interesting than others might. You need to think like the people
you will be presenting this information to and tell them what they need to know—no more,
Search JabSto ::




Custom Search