Building a Parametric Excel Spreadsheet Model, Part 1

This is the first video in a two-part series. The culmination of the series is a Parametric Excel Spreadsheet model that can easily be linked to a DPL Decision model. If you'd like to follow along, open a blank Excel workbook. Use the link below to download the Excel spreadsheet you should end up with at the end of this video (Part 1 ).
https://www.syncopation.com/downloads...

This is the file you should start from if you proceed to Part 2 of this video series:
   • Building a Parametric Excel Spreadsheet Mo...  

Irrespective of industry vertical, strategic business decisions are confounded by uncertainty – uncertainty that must be accounted for and quantified. Consequently, the ability to construct a parametric Excel spreadsheet model that can flexibly capture the value of many future states of the world given the uncertain value drivers is a vital skill. The people with this ability provide critical quantitative information to decision makers.

Many of our video tutorials highlight decision analytic modeling techniques, tools, or features – during which I briefly mention the Excel spreadsheet that underlies the decision model. Within this set of tutorial videos I will show you the steps to building a flexible, parametric spreadsheet model starting from a blank Excel workbook. Such a model can be readily connected to DPL for robust scenario analysis. To request a FREE, 21-day trial of DPL Professional:
https://www.syncopation.com/products/...