->

Lynda - Excel: Scenario Planning and Analysis

Lynda - Excel: Scenario Planning and Analysis
MP4 | Video: 720p | Duration: 2:07:25 | English | Subtitles: VTT | 267.1 MB


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

 

Lynda - Excel: Scenario Planning and Analysis


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss