Koofer (3)

Koofer (3) - Chapter 6 Using Excel to Support Decisions...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 6: Using Excel to Support Decisions Chapter Skills Recognize the type of data that lends itself to PivotTable (& PivotChart) analysis. Any well-structured list of data Insert -> tables -> pivot table Understand how to set up a pivot table to view the desired dimensions of the data summary. Apply sensitivity (what-if) analysis models to business scenarios. Removes decision variables from formulas to assumption cells so they are easy to change To access the scenario manager - data, data tools, what if analysis, scenario manager Click add, name and select cells to change, click okay, add new values, click OK, repeat Store scenarios of sensitivity analyses for viewing. Click summary to view all scenarios side-by-side In scenario summary, all values are text so they can be changed to be more meaningful Produce data tables to summarize inputs and outputs of a decision model. One variable- put inputs in one column (units produced product 2) and formulas for outputs in header row. Select table and click: data, data tools, what if analysis, data table , only fill column input cell with cell wanting to change (leave row input cell blank)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/31/2011 for the course 1 1 at Iowa State.

Page1 / 3

Koofer (3) - Chapter 6 Using Excel to Support Decisions...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online