Chapter 11: Analyzing Data

You can get more out of Excel by performing data analysis, which is the application of tools and techniques to organize, study, and reach conclusions about a specific collection of information. In this chapter, you learn data analysis techniques such as sorting and filtering a range, setting data validation rules, creating data tables, summarizing with subtotals, and grouping related data. You also learn how to use the Goal Seek and Scenario Manager tools and how to remove duplicate values from a range.


Sort a Range or Table

Filter a Range or Table

Set Data Validation Rules

Create a Data Table

Summarize Data ...

Get Excel 2013 Simplified now with O’Reilly online learning.

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