Chapter+8 - situations: worst case, likely case, best case....

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

View Full Document Right Arrow Icon
Excel #8 Using Data Tables and Excel Scenarios for What-If Analysis
Background image of page 1

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

View Full DocumentRight Arrow Icon
Level I What-If Analysis Break Even Analysis Fixed costs Variable costs Sensitivity Analysis
Background image of page 2
Level I (continued) One Variable Data Table One input Many results Two Variable Data Table Two inputs One result
Background image of page 3

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

View Full DocumentRight Arrow Icon
Level II Scenario – values stored on the worksheet that describe different
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: situations: worst case, likely case, best case. Create and name input (changing cells) and output (result cells) SUMPRODUCT Level II (continued) Level II (continued) Create, view, and edit scenarios Scenario reports Scenario PivotTable Scenario PivotChart Level III OMIT...
View Full Document

Page1 / 7

Chapter+8 - situations: worst case, likely case, best case....

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

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