How to Use an Excel Data Table for “What-if” Analysis

An Excel Data Table is a great way to see the results of substituting two values in a formula. For example, to see what your monthly payment will be by changing BOTH the Interest Rate and the amount that you borrow.

However, reading about how to set up an Excel Data Table can be confusing. Where, exactly, do you place the Row Inputs and the Column Inputs?

Seeing how a Data Table is constructed is SO much easier. I invite you to watch this short Excel Training Video Lesson to see how to set up and use an Excel Data Table to analyze your data.

You can find additional resources on…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads