Create a Two Variable Data Table

Pubblicato il: 12 luglio 2012
sul canale di: 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
~-~~-~~~-~~-~

In questa pagina del sito puoi guardare il video online Create a Two Variable Data Table della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Doug H 12 luglio 2012, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 327,410 volte e gli è piaciuto 879 spettatori. Buona visione!

54,509