Chapter 5: Advanced Techniques for Analyzing Data

In This Chapter

arrow.png Generating a sparkline chart

arrow.png Sorting information in a worksheet list

arrow.png Filtering a list to find the information you need

arrow.png Using the Goal Seek command to produce formula results

arrow.png Performing what-if analyses with data tables

arrow.png 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 ...

Get Office 2013 All-In-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.