Building a Parametric Excel Spreadsheet Model, Part 2

This is the second and final video of the two-part series. Make sure to watch Part 1 if you haven't already done so:
   • Building a Parametric Excel Spreadsheet Mo...  

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, use the Excel spreadsheet you saved from Part 1 or use the link below to download the Excel spreadsheet:
https://www.syncopation.com/downloads...

Here is the completed Excel spreadsheet which is a culmination of the 2 part series:
https://www.syncopation.com/downloads...

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