Data -> Data Tools

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.2. Apply data analysis: Data Tools What-If Analysis

Data: Data Tools

This page begins a new discussion on the Data Tools. Data Tools analyze the information: they ask questions.

 

The best known Data Tool is the What-if? Analysis. Our lesson will begin with Goal Seek, a simple What-If.

 

Before You Begin: Open a Sample File

Open a sample spreadsheet:
Legs Eggs Pigs 2010.xlsx
Go to the sheet: Pig.

What Do You See? This is the Pig Sales for Charlotte's Website. There are three reference Cells for Price (B1), Start (B2) and Increment (B3). The formulas in Columns C, D, and E refers to these three reference Cells.

Keep going...