Curt Frye – Excel: Scenario Planning and Analysis

Keywords List

and

the

The

A

a

of

to

your

you

You

Summary

• Excel: Scenario Planning and AnalysisBy: Curt FryeLevel: IntermediateDuration: 2h 7mReleased: Nov 28, 2017Description:A multitude of factors can affect the trajectory of your business.

• Learning how to document, summarize, and present projected business scenarios can help provide a basis for insightful business analysis, and help you evaluate the impact of various choices on your organization.

• In this course, explore techniques for analyzing a series of business scenarios using the flexible and powerful capabilities built into Excel.

• The course starts with a chapter on the art and craft of scenario planning before turning to the technical capabilities of Excel.

• Tools covered include row grouping to show and hide detail, PivotTables, and functions for using the normal distribution.Topics include:Designing a scenario-planning exerciseEstimating scenario plausibility and outcomesEstablishing parameter value rangesCalculating the standard deviation of a datasetIndicating the probability of a scenario value occurringWalking through a scenario presentationPerforming retrospective analysis using a PivotTableChanging PivotTable summary operationsContents:Introduction1.