This post demonstrates how to use data tables in Excel. These are very helpful in conducting automated scenario analysis on a model, and have the benefits of being live (not static), automated, and a great time saver versus running manual scenarios.
The following file is used in this demonstration: Data Tables
A recorded video showing how to use data tables in Excel can be accessed on YouTube.
©2017 Ben Etzkorn