Microsoft® Excel® 2010: Step by Step

Chapter 8. Analyzing Alternative Data Sets

Chapter at a Glance

In this chapter, you will learn how to
✓	Defining an Alternative Data Set.
✓	Defining Multiple Alternative Data Sets.
✓	Varying Your Data to Get a Desired Result by Using Goal Seek.
✓	Finding Optimal Solutions by Using Solver.
✓	Analyzing Data by Using Descriptive Statistics.

When you store data in a Microsoft Excel 2010 workbook, you can use that data, either by itself or as part of a calculation, to discover important information about your organization. When you track total sales on a time basis, you can find your best and worst sales periods and correlate them with outside events. For ...