Excel What-If Analysis Data Table | Easy to Use Once you Learn This☝️

Описание

Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/

Use an Excel Data Table What-if Analysis to quickly create multiple results based on a formula you already have. The data table in Excel will allow you to change values in some cells and come up with different answers to the problem. This is what Microsoft Excel's What-if Analysis Data Table does best - it allows you to experiment with different input variables. A Data Table allows you to see how different input values would impact the result at one glance. It's quite a hidden Excel tip and trick. Data Tables can be confusing at first, but this tutorial explains it in simple English and in a way, you will never forget how to use this feature again.

In this example we’ll create a retirement savings plan. You'll calculate how much money you will have after saving a specific amount of money per month over a number of years. Our inputs for the calculation are the monthly payments, the number of years we're paying into the retirement fund, and the interest rate earned. We’ll use a Data Table in Excel to explore what happens to the future value of the fund if the interest rate or years changes. Data tables recalculate every time you make changes in the workbook. There is a setting you can tweak to stop data tables from calculating. Go to Formulas / Calculation Options / Automatic Except Data Tables. You can toggle this option on or off depending on your needs.

00:00 What-If Analysis in Excel - Most Simple Explanation
00:16 Data Table - 1 Variable
04:47 Bonus Trick: Custom Formatting as icon
05:55 Data Table - 2 Variables
08:07 Wrap Up

? My Online Courses ► https://www.xelplus.com/courses/

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-what-if-analysis-data-table/

? LINKS to related videos:
- Excel Goal Seek Explained in Simple Steps: https://youtu.be/OhnkuBVTcg8
- Excel Solver - Example and Step-By-Step Explanation: https://youtu.be/dRm5MEoA3OI

?☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

? Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

? Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

? GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

?Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

? This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel