O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

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 8. Analyzing Alternative Data Sets

Analyzing Alternative Data Sets

Chapter 8 at a Glance

In this chapter you will learn to:

✓ Define and edit an alternative data set.

✓ Define multiple alternative data sets.

✓ Vary your data to get a desired result.

✓ Use the Solver to find solutions to multivariate problems.

✓ Describe your data using the Analysis ToolPak.

When you store data in a Microsoft Excel workbook, you can use that data, either by itself or as part of a calculation, to discover important information about your business. 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 businesses like ...

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