Excel What Ifs- One variable data tables

How to use a single variable data table to run what if sensitivities in Excel. Also explains why sometimes it looks like the data table is not working and all the numbers are the same or not changing.

------------------------------------------------------------------------------------------------------------------------------------------------------

✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/skills-assessment/
?- Test employee Excel skill levels- https://excel-skills-assessment.com/excel-skills-test-for-employment/
?- Improve you Excel Skill Levels- https://online-excel-training.auditexcel.co.za/course-category/skill-based-beg-int-adv/
??- Our main website- https://www.auditexcel.co.za/blogs/

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Single Variable data tables in Excel for What If's
00:15 Loan repayments based on different interest rates (what if interest is different)
00:42 Creating a sensitivity table showing results at the different input levels
01:00 Create a column of the different interest rates you are interested in
01:15 Specify where Excel must go find the output (repayment amount in this case)
01:23 In 1 variable data table, you can have multiple output sensitivities
01:35 Activate the Data Table
02:00 Specify to Excel where it finds the input values
02:58 Data tables are live i.e. they will continue to update as you make changes
04:24 Excel data table has all the same values
04:48 Excel not calculating until you push F9 (useful for big models)
06:10 All inputs and outputs must be on the same sheet for Data tables to work
06:28 Trick to move inputs and outputs onto same sheet