Create a Two Variable Data Table

Publicado em: 12 Julho 2012
no canal de: 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
~-~~-~~~-~~-~

Nesta página do site você pode assistir ao vídeo on-line Create a Two Variable Data Table duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Doug H 12 Julho 2012, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 327,410 vezes e gostou 879 espectadores. Boa visualização!