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.

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

During a What-If Analysis, the worksheet is altered to see how the changes will affect the formulas. Scenarios, Goal Seek, and Data Tables are three types of What-If Analysis tools in Excel. With ...

An curved arrow pointing right. Don't waste time testing different values individually in Excel. Use a data table to show the results for many different possible scenarios at once. Follow BI Video ...

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals.

Susan Harkins continues her review of Excel's analysis tools with Scenario Manager.

Sean Ross is a strategic adviser at 1031x.com, Investopedia contributor, and the founder and manager of Free Lances Ltd. Charlene Rhinehart is a CPA , CFE, chair of an Illinois CPA Society committee, ...