Microsoft Office Tutorials and References
In Depth Information
CHAPTER 11: Analyzing Data
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.
Search JabSto ::




Custom Search