Launch Microsoft Excel and open the workbook where you want to perform the What-If Analysis. Access the Data Tab Navigate to the “Data” tab located on the Excel ribbon at the top of the screen.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

This guide will walk you through the three primary what-if analysis tools in Excel: Scenarios, Goal Seek, and Data Tables, along with additional tools like the Solver add-in.