Microsoft Office Tutorials and References
In Depth Information
Chapter 5: Advanced Techniques for Analyzing Data
Chapter 5: Advanced Techniques
for Analyzing Data
In This Chapter
✓ Generating a sparkline chart
✓ Sorting information in a worksheet list
✓ Filtering a list to find the information you need
✓ Using the Goal Seek command to produce formula results
✓ Performing what-if analyses with data tables
✓ Examining data with a PivotTable
This chapter offers a handful of tricks for analyzing the data that you so
carefully and lovingly enter in a worksheet. Delve into this chapter to
find out what sparklines are and how to manage, sort, and filter data in lists.
You also discover how the Goal Seek command can help you target values
in different kinds of analyses, and how you can map out different scenarios
with data by using one- and two-input data tables. Finally, this chapter
explains how a PivotTable can help turn an indiscriminate list into a
meaningful source of information.
Seeing What the Sparklines Say
Maybe the easiest way to analyze information in a worksheet is to see what
the sparklines say. Figure 5-1 shows examples of sparklines. In the form of a
tiny line or bar chart, sparklines tell you about the data in a row or column.
Follow these steps to create a sparkline chart:
1. Select the cell where you want the chart to appear.
2. On the Insert tab, click the Line, Column, or Win/Loss button.
The Create Sparklines dialog box appears.
3. Drag in a row or column of your worksheet to select the cells with the
data you want to analyze.
4. Click OK in the Create Sparklines dialog box.