O'Reilly logo

Special Edition Using® Microsoft® Office Excel 2003 by Patrick Blattner

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 25. Using Analysis Tools: Goal Seek, Solver, and Data Tables

Analyzing Your Data with Excel

Many Excel users input data into a worksheet, use simple functions or formulas to calculate results, and then report those results to someone else. Although this is a perfectly legitimate use of Excel, it basically turns Excel into a calculator.

When you need to do more than just type data into a worksheet, you can use special Excel features to analyze your data and solve complex problems by employing variables and constraints. Goal Seek and Solver are two great tools included with Excel ...

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