Use What-If Analysis with Data Tables in Excel

Use What-If Analysis with Data Tables in Excel

A data table is a range of cells in which you can change values in some in some of the cells and come up with different answers to a problem. 

Types of What-if analysis in Excel

There are three types of what-if analysis tools in Excel:

  1. scenarios
  2. data tables
  3. goal-seek

This post and video cover data tables. Scenarios and data tables use sets of input values to calculates possible results. Goal-seek is distinctly different, it uses´╗┐ a single result and calculates possible input values that would produce that result.


YouTube Video on Data Tables

Chris Menard

Chris is a Microsoft Office Master Instructor. He trains corporate clients in Microsoft Excel, PowerPoint, Word, and Outlook. Menard is a speaker for the Georgia Society of CPAs and the University of Georgia Terry College of Business. Menard's YouTube channel has over 400 technology videos.