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