O'Reilly logo

Excel 2013 Simplified by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

9781118517260-co1101.tif

Sort a Range or Table

Filter a Range or Table

Set Data Validation Rules

Create a Data Table

Summarize Data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required