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.
