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.

    Part I: Excel Basics