Microsoft Excel

Use What-If Analysis with Data Tables in Excel

Chris Menard

20 Dec 2018 — 1 min read

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

What-If analysis in Excel with a Data Table by Chris Menard

Chris Menard to Present “Executive Insights: Harnessing Excel for Strategic Analysis” at EA Ignite Conference

November 4, 2025 Microsoft MVP and productivity expert Chris Menard will be presenting a highly anticipated session titled “Executive Insights: Harnessing Excel for Strategic Analysis” at the EA Ignite Conference, held at the Renaissance Nashville Hotel. This premier event, running from November 3–5, 2025, is tailored for executive assistants

Chris Menard to Present “Mastering Microsoft 365 Copilot” at EA Ignite Conference

Chris Menard will present “Mastering Microsoft 365 Copilot” at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.