Chapter 5
Advanced Techniques for Analyzing Data
In This Chapter
Generating a sparkline chart
Using conditional formats to call attention to data
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 conditional formats can help data stand out, how the Goal Seek command can help you target values in different kinds of analyses, and how you can map out different scenarios ...
Get Office 2016 All-In-One For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.