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 ...