Select a Webcast

December 12, 2018
5:00PM - 7:00PM ET


December 15, 2018
3:00PM - 5:00PM ET


January 11, 2019
5:00PM - 7:00PM ET


January 19, 2019
4:00PM - 6:00PM ET


January 30, 2019
2:00PM - 4:00PM ET


Specialized Knowledge
Basic Excel proficiency

Course Description

Financial analysis is an area of opportunity and risk. Analysis should incorporate tests of sensitivity to changes in key variables using the most advanced tools available. Typical financial models do not effectively utilize these tools. This exposes the analyst to blind spots in their analysis. Analysts should obtain and become proficient with the more sophisticated 'what if' analysis tools of the trade. This course will guide you through how to unleash Excel's sensitivity tools. Improve your design and incorporate these powerful tools with ease. Enhance the ability of your models to tell the story of upside potential and downside risk like you have never seen or done before. Expand your skills in just two hours and gain superstar status.


Course Specifics

Specialized Knowledge
Sep 22, 2017
Basic Excel proficiency

Compliance Information

Qualifies for CA Fraud: No

Learning Objectives

Upon successful completion of this course, participants will be able to:

  • Cite the 20 rules of effective model design
  • Identify how to apply scroll bars to individual cells to flex them over their relevant ranges with the touch of your mouse
  • Cite how to use Goal Seek to discover how much a single variable must move to reach a desired outcome
  • Cite how to use Data Tables with one or two inputs to deliver an array of outcomes from your model in just seconds
  • Identify how the Data Tables interface works dynamically with other sensitivity tools
  • Use Solver to simultaneously manipulate multiple variables over their relevant ranges to identify pinch points and maximize efficiency and productivity
  • Use Scenario Manager to store selected groupings of inputs and resulting outcomes and to consolidate all 'versions' of your model into one file
  • Use the standard Scenario Summary to compare your scenarios automatically

Back to top