Create a One Variable Data Table

Ever heard of a variable table? What about a one variable table? Basically it's a data table that give you different outputs based on some criteria. Some would use this as a sensitivity or what if analysis tool. A one variable table gives you the ability to put a single variable input in and see how that input affects some outputs. For example let's say you are taking out a loan and wanted to see what your payments would be at 1%, 1.5% and so on like a simple percent series. Instead of erasing and plugging in a different interest each time, you can just create a table that list the interest rates ranging from 1% to say 7% in .5% increments. This can be done with a one variable data table. View the video to see how it's done.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ 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 www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@Ronansugrue]

Dude - anytime you're feeling low just remember this simple video helps people. Found this super useful. Thanks man

[@SteveClary]

Thank you Doug. You just saved me probably an hour or two of my life!

[@johnschoenneman3783]

thank you! my TA rushed through this whole process, you saved my homework!

[@margoschmidt4526]

Thank you! I have been struggling with figuring this out and this video was simple enough that I finally understand it now!

[@DougHExcel]

Hi Margo Schmidt, glad you liked it, thanks for commenting!

[@strollie3221]

I've been checking through many tutorials about the data table function on youtube, and this is the first one that makes me understand the concept. Thank you very much.

[@DougHExcel]

Thanks for the comment!

[@tacsman]

Thank you! You explained one-variable data tables better than both my teacher and my textbook.

[@DougHExcel]

Thanks for the comment!

[@LoganGroeneveld]

Helped me out a ton. Thanks man!

[@hectorbrac100]

Almost 6 years later and still, you Sir, remain a hero! Thanks for the explanation!

[@DougHExcel]

Glad to have helped again...thanks for the comment!

[@ALi3___]

Found this very helpful and easy to follow! Thank you very much.

[@sallyannforde6559]

this helped a whole lot. was quite simple to follow. thanks

[@personofdeath]

THIS IS STILL SO HELPFUL THANK YOU!!! REALLY APPRECIATE ALL THESE VIDEOS

[@DougHExcel]

Hi personofdeath...you're welcome, glad you liked!

[@amaliafowler3350]

You have helped me study so much! Thank you!

[@LightSaberPro]

Sir, you are a lifesaver! I very much appreciated this how-to video!

[@DougHExcel]

Hi LightSaberPro, thanks for the comment!

[@JenBuilt]

Articulate and to the point. Thanks!

[@ricochetrob]

Excellent video! Thank you.

[@dr_jaymz]

for the one variable, thank you, all the examples were pf the PMT formula, mine was much more complex with stuff all over the shop, I wanted to forcast the profit for a variable number of sales and plug the result. But I didn't have a simple formula. This worked a treat.

[@4inaftermath454]

This is helpful , i had no idea what i was doing, keep making these. Thank you!

[@DougHExcel]

You’re welcome!

[@JackMoney]

Saved my sanity, thank you very much!

[@orrisfashion]

Excellent video! Thank you.

[@Namit2007]

Thank you. So easy after going through a simple example.

[@DougHExcel]

Thanks Namit Rathore!

[@lynnashrewsbury6278]

The Excel for Dummies was simply just not working for me until I found this tutorial. Thank you!

[@SenshiV]

Thanks, I needed to know how to do it, and know I do, so success.

[@16mmDJ]

That was very helpful. Thanks.

[@Loveflamingos1]

thanks for the help Doug!!! You're the best. keep posting! :)

[@DougHExcel]

Hi Loveflamingos1, thanks for the comment!

[@scotthastings6978]

Thank You co much for this simple video. Helped a lot in my college course.

[@DougHExcel]

Thanks Scott Hastings, glad it helped!

[@faithnjore9336]

Thanks. This was helpful.

[@symbianwater]

Brief & Excellent!

[@DougHExcel]

Thanks!

[@avleendhillon2949]

thank you. that was very useful !!

[@DougHExcel]

Thanks Avleen Dhillon, glad it helped!

[@qhs3711]

What a hero.

[@bryankornfeld5607]

This was 100 X better than reading Microsoft's drivel. Thanks.

[@ErikaSandovalmxl]

Very easy to understand! Gracias

[@DougHExcel]

De nada!

[@vvlove012000]

Thank you i was literally reading this book over and over trying to figure out how to do this 5 mins of you and i got it ha ha thank you

[@DougHExcel]

Thanks veronica vidana, glad it helped!

[@SixthSavior]

Thank you so much. This helped me finish my homework.

[@DougHExcel]

glad it helped!

[@rakheensingh9527]

You are the best, thank you!!

[@DougHExcel]

Hi Rakheen Singh, thanks for the comment!

[@workonyourbiznotinit]

thank you Sir !

[@Stellaih71]

Thanks so much! Got any videos on graphing a sensitivity analysis?

[@sumaia4237]

Thank you HERO

[@DougHExcel]

Hi سمية Sumaia, thanks for the kind words!

[@willpick]

Thank you!

[@DougHExcel]

You're Welcome!

[@kylesanchez425]

Thank you!!

[@DougHExcel]

Hi Kyle Sanchez, you're welcome!

[@basg6595]

thanks !!

[@manishzackryder]

Thank you sir

[@DougHExcel]

You're Welcome!

[@zack7130]

Thanks, Doug!

[@zack7130]

You're a lifesaver! #AllHailDoug

[@DougHExcel]

Hi Zack Karam, thanks for the kind words!😃

[@joeg2385]

Dude this actual is so fucking helpful. You explain both One and Two variable data tables!

[@DougHExcel]

Hi Joe G, glad you liked it, thanks for commenting!

[@sandunidilrukshika8188]

Thanks lot

[@DougHExcel]

You're Welcome!

[@waelzaini5091]

thank you

[@DougHExcel]

You're welcome!

[@EpiBound]

Do you have any tips on how to make a data variable for book publishing? That is, I'd like to number first books off the press from 1 to --, but my searches lead me to other variables, like the one you post here. Thanks for reading.

[@roanamulovhedzi5092]

UCT made me come here.

[@DougHExcel]

Hi Roana Mulovhedzi, thanks for the comment!

[@wisterwalcott]

or, you can just copy the formula down across all these rows

[@DougHExcel]

Hi venither111, thanks for adding to the thread!