All programs are sent digitally but you can request us a DVD/USB drive version.

If you want more information about a product please send us a message and we will upload a screenshot of the files.

Curt Frye – Excel: Scenario Planning and Analysis


Published on: December 14, 2020
Free Digital Download Delivery
Or contact us to get a DVD version of this product.
SKU: biz4334 Category:

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 exercise
Estimating scenario plausibility and outcomes
Establishing parameter value ranges
Calculating the standard deviation of a dataset
Indicating the probability of a scenario value occurring
Walking through a scenario presentation
Performing retrospective analysis using a PivotTable
Changing PivotTable summary operations


There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.