Data Tables in Excel


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


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.