Summary

You worked hard during this hour to grasp the concepts and instructions for analyzing data with Excel's sophisticated Scenario Manager and Goal Seek tools. Your hard work will pay off the first time you need to analyze data on the job. You can always refer to this session for help in setting up your worksheets and using the data analysis tools. These tools will impress your boss and co-workers, as well as help you reach the results you want.

In the upcoming hour, you delve into using pivot tables to restructure your data into tables that calculate formulas and display data just the way you want it to look.

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.