Create a Two Variable Data Table

Veröffentlicht am: 12 Juli 2012
auf dem Kanal: Doug H

327,410

879

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.

BTW there is a difference between creating a two variable data data and a one variable data table. To see how to create a one variable data table go to my other video at • Create a One Variable Data Table

🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 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!

🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

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

Auf dieser Seite können Sie das Online-Video Create a Two Variable Data Table mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Doug H 12 Juli 2012 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 327,410 Mal angesehen und es wurde von 879 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

132