What-If Analysis Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/what-if-analysis/ Bestselling Excel and Power BI Courses Thu, 04 May 2023 16:20:27 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png What-If Analysis Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/what-if-analysis/ 32 32 Excel What-If Analysis: Data Table Tool https://www.xelplus.com/excel-what-if-analysis-data-table/ Fri, 02 Dec 2022 16:47:00 +0000 https://www.xelplus.com/?p=8648 Excel's What-if Analysis Data Table allows you to quickly create simulations.

This tutorial takes you through a simple example of how you can create a Data Table from scratch.

The post Excel What-If Analysis: Data Table Tool appeared first on Xelplus - Leila Gharani.

]]> Excel Solver Example and Step-by-Step Explanation https://www.xelplus.com/excel-solver-example/ Thu, 28 Sep 2017 06:51:00 +0000 https://www.xelplus.com/?p=11926 Quickly find out where you can find Excel's Solver tool and how you can use it to solve for the optimal solution to your problem. It's sometimes seen as an Advanced Goal Seek.

The post Excel Solver Example and Step-by-Step Explanation appeared first on Xelplus - Leila Gharani.

]]> Excel Goal Seek Explained in Simple Steps https://www.xelplus.com/excel-goal-seek/ Thu, 21 Sep 2017 13:02:00 +0000 https://www.xelplus.com/?p=11936 Goal Seek is part of the What-If Analysis tools, which you'll find in Excel's Data tab. It allows you to find the values necessary to achieve a target. Learn all about it in this tutorial.

The post Excel Goal Seek Explained in Simple Steps appeared first on Xelplus - Leila Gharani.

]]>