Excel: Scenario Planning and Analysis – Curt Frye

Keywords List

and

A

of

the

a

The

scenario

Scenario

business

to

Summary

• 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.