Analyzing Data with What-if Analysis in Excel 2010

Overview/Description
Excel 2010 provides powerful data-analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. And you can use additional what-if analysis components, data tables and scenarios, to forecast worksheet outcome models and to see how changing values in formulas affect the formula results.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
1.0

Lesson Objectives

Analyzing Data with What-if Analysis in Excel 2010

use Goal Seek for data analysis

use Solver to perform data analysis

create scenarios using the Scenario Manager

manage Excel 2010 what-if scenarios

create a data table for what-if analysis

recognize how to project values in a series

use what-if analysis to find out how to achieve a desired result

use what-if analysis to determine the maximum or minimum value of one cell by changing other cells

use what-if analysis to forecast best-case and worst-case results

use what-if analysis to explore a possible set of outcomes at a glance