Create a Two Variable Data Table

This video is about creating a two variable data table feature. The use case for this is if you want to input two sets of varying pieces of data (two input variables) and see how the output changes. For example say you are taking out a loan and maybe not sure how much you want to take out. At the same time you are unsure of the rate you might get. What are the possibilities of monthly payments you'll have? It's almost endless because you can calculate multiple results with your two input variables. With a two variable data table you can a range of interest rate AND a range of loan amounts and let the handy-dandy data table feature figure out the different monthly payments that are possible. The example in the video will cover a mortgage loan payment scheme.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[YC-musica]

Thank you Doug!!!  I am taking an online Excel 2013 class, and the Pearson textbook lab site videos and the textbook do not explain the concepts well at all. Your instructional videos are extremely clear, concise,  and helpful.  I don't think that I could have passed most of the advanced Excel assignments for this class without your "supplemental" lectures!

[tweetums]

Thank you! Thank you! Thank you! You're a Lifesaver! How I wish my professor is as easy to comprehend as you!

[Kairenia]

Taking an online Excel class. You're 1000% better than this book. Thank you for saving my butt in understanding the basics.

[daniellelavoie]

Thank you for posting this! I've been trying to figure this out for several hours and couldn't get the correct answer. Once I watched this, I FINALLY got the right answer! Thank you again!

[SeymoreTanzarian]

you are a life saver! Im doing a 150 by 150 grid 2 variable data table and I was going column by column. thank you!

[cindyhutchison]

Saved my butt on homework due tonight by midnight. THANKS MUCH!!

[mohammadpourheydarian]

simple, up to point, no waste of time. Thank you.

[petercrawford]

Thanks! I've been trying to figure this out for hours!

[rainonyoureyes]

Thank you so much ! I really appriciate your time and effort ! Your video is more helpful to me than my expensive textbook.

[ArianaCorpuz]

Just saved my life on a homework problem. Thanks!!

[Lukec]

Thanks so much !!! try to figure this problem for so much time.

[Jennafer]

Thank you for the clear explaination!! You saved my excel test grade!

[sonjagray]

thank you for all your help. you are clear and easy to understand!!!

[chomop]

Thank you!  This was very helpful and easy to follow.

[mustaffabinhassan]

Thanks Doug. Your EXCEL videos are amazing to say the least.

[adfs]

Thank you very much for this video, I too found it very helpful!
Although it is not within the scope of this video, I'd like to add how to create the table quickly if you don't have a spreadsheet program that supports this function, meaning you would have to manually input the formulas. Eg. in Cell D9, I would use this "=PMT(D$7/12, $B$3*12, $C8)" and then drag. (I'm using Excel 2011 for mac and 2010 for windows, and this is what I have been doing, shame on me!)

[yvonnelo]

really helpful!!!your voice is good and the explanation is clear! thanks so much.

[bethred]

Thanks! Your videos are so clear, they're helping me cram in as much Excel Know How as I can in preparation for starting a new job.

[NorthJerseyGarden]

Thank you ! pretty cool and simple explanation

[bluephoenix]

Thank you!!!! Your explanation clarified where the MOS Study Guide's wording really confused me!