Using Data Tables for WhatIf Analysis  in Excel 2016
Channel: Computer Tutoring
Date: 2018-10-12

Here you will see how using data tables for WhatIf Analysis in Excel 2016 will help you work out payments for a new car. Using Data Tables in Excel is one of the tools that come under the umbrella of WhatIf Analysis.
This data tables whatif analysis tutorial will not only show you how to use the data table feature in Excel 365 to give you different scenarios. It will also employ a drop down list, named ranges and a VLOOKUP function to give you a data table you can use. Perhaps even use in your everyday life.
Now this tutorial also makes use of the OFFSET function to create a dynamic. You might be forgiven for feeling that the function is a little complex so I've included it on our website:

https://www.computertutoring.co.uk/using-data-tables-for-whatif-analysis-excel-2016.asp

Finally you will also see how you can merge cells, rotate text and general format the spreadsheet so it looks a little more professional.
#computertutoring 

😊 Check out my website and social media to keep up to date - enjoy learning 😊

 📱 http://www.computertutoring.co.uk/ 📱 
📽 https://www.tiktok.com/@thecomptutor 📽 
👨‍👩‍👧‍👦 https://www.facebook.com/ComputerTutoring.co.uk/ 👨‍👩‍👧‍👦 
🦉 https://twitter.com/CT_Tutoring 🦉 
📷https://www.instagram.com/computer_tutoring/ 📷 
📌https://www.pinterest.co.uk/CT_Training/ 📌