Use What-If Analysis with Data Tables in Excel

Posted on:  12/21/2018
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 Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.