Excel Spread Sheet Basics - Using a Formula

CHECK BELOW!!!!
How to set up a very basic spread sheet.
If you're really new to Excel, you might want to check out my REALLY BASIC video before this one, it has some valuable concepts that will help.
• Excel Spread Sheet Bas...

[@zordanxxx]

Strange enough, he is the only one that really explained basic and I actually learned what I wanted, other basic spreadsheet videos lost me within 10 seconds, thanks for clearing it so easy.

[@vhyndman]

I was SO sick when I did this video... it was actually done for a friend, and I left it so that she could remember how to use Excel... we did a quick tutorial, but I knew I was going way too fast for her to retain it all.
Posting it on youtube was an afterthought... I'm both astounded and pleased that folks like it.
And Rockfall... you make a good point.

[@SKM879]

Thank you for your simple explanation of not easy formulas.

[@bereancarpenter]

I learned more from this video than I ever have from any other video

[@annredgewell8650]

Very easy to follow, exactly what I needed. Bit confused about adding columns at the end, but in general helped a great deal.

[@Kyon65]

Thanks muchly :D
Couldn't find anything else on the internet as informative as your video.

[@annieplanet8]

Thank you Excel Master, Martin: Your lesson was extremely well explained and I liked the way you taught it. I am dyslexic and have a learning disability and flunked out of all me Excel classes because I am soooo slow. I repeat your lesson over 10 times and am able to absorb it very well. Please keep on making your Exel videos. From Annie in Los Angeles

[@ebonyfruitbat_fb7593]

Thank you so much! I took statistics years ago and forgot how to add formulas to excel. Your video has saved me so much time.

[@shazdee]

Thanks for this video, I just bought Excel 2010 and have never used a spreadsheet of any kind before and it was doing my head in. This has been very infomative and made me reconsider tossing my pc through the wall.

[@christelc2783]

Even 12 years later this video is still useful 👍🏽

[@j1j11j]

Thank you - veryhandyman? I recently inherited the treasury duty of a group with a small budget. Though it would have been more simple and appropriate to have done it on paper it came to me as Excel. Your video has enabled me to set up a similar Excel book for a 6x more complicated job. Thank you recognizing the need for and implementing a fine presentation these basic skills.

[@Englistanii]

Thanks so much mate. I'm starting a apprenticeship for business administration soon and this really helped me out as I had completely forgotten how to do formula's.
Thanks again mate, you are a life saver.

[@shugabee9307]

You taught this so well, I only had to watch half of it to do what I needed for work... BRAVO!!!

[@JacYates]

This was a very informitive tutorial about Microsoft Excel. I forgot how easy this program really was,, all it is is organizing and putting information into columns. Also solving equations if need be within the data that was typed into the spreadsheet.

[@mazr2006]

THAAAAAAAANKK YOUUUU .. see how great is that ppl thanking you for your work. this is amazing and so humane.

[@zitlalyjudithalfaro313]

watching this in 2021 and I still think is the most helpful basic excel video out there, thanks!

[@wangcandice6952]

I llike this tutor! Very humourous and smart, I like the way he speaks ;) Thanks for this vedio!

[@zordanxxx]

I was looking for samples for beginners and found spreadsheets for financial institutions that really don't help me, thanks for keeping it simple

[@heythereitsjimbo]

You make my project management prof looks like a chump, thank youuuuu

[@CroGirlZg]

Million thanks, I was already starting to go crazy with these formulas, couldn't figure it out... You're a lifesaver!

[@wizardrizk1885]

thank you, you saved my ass bullshitting my manager to think i'm actually good at this.. my hero!

[@veganchevychick]

You uploaded this back in 2007 & will probably continue to receive comments about that frighteningly loud cough of yours up until the day the Internet itself actually dies. Very helpful tutorial otherwise and definitely um...... memorable. Lol

[@mohammedjafferali693]

Lol can't stop laughing when I was reading you comment he coughed. uuuuaahhhhh!

[@hamzadesomer9840]

Bless u

[@SKM879]

Great tutorial. I agree with you about Vern's memorable cough :))) Thank you!

[@mikeg3774]

Vern, I thought I'd never understand Excel at all until I saw this video. You rock, brother. Thank you. I'm gonna tell my professor to watch it, too... anonymously of course.

[@Mscubanlink24]

thanks sooooo much i feel like i owe you some tution or something. i've learn alot thanks so much again

[@jayrsagittaruis1110]

Thank you so much for your video. I learn a lot how to used a formula to excel. Good bless you

[@lwarfield52]

This was the best excel formula, which was easy to understand and learn.Thank you Vern Hyndman! You are awesome!

[@CascadaGaming]

Great video, helping me re-learn Excel for my new job.

[@thePeziie]

This tutorial is very helpful for me, even now is already many years later. Many thanks for uploading the video :)

[@haciendabear]

Thanks for refreshing my memory...its been approximately 10 years since i used spreadsheets!

[@allain666]

Awsome man , lifesaver my homework needs to be given in tomorrow morning thnks you rock

[@adamnaughty]

thank you so much your such a great teacher you made it very basic n easy to learn .... you made it so easy

[@aazanova]

Thanks so much you just saved me 87 hours of calculations

[@kokaimanawatokuingoa8440]

2018 and still contributing to the up and coming xl noobs ...thanks a milli :)

[@xIvelisse]

Thank you so much! I'm actually certified in Excel but I don't have access to it from home so I forgot pretty much everything. I just landed a job that starts tomorrow where I basically make spread sheets for an accounting company. Time to study!

[@vhyndman]

You're absolutely right... there is nothing one cannot do u=in Excel that one cannot do with a pad and a paper, and a lot of time.
What a spreadsheet is often used for is "what if" scenarios, where an entire complex set of calculations are made, and one wants to see, for instance, what would happen if a percentage is altered, thereby changing most of the numbers in an instant. "What if" scenbarios are much harder with a pencil.

[@ianm.7929]

Good video. I learned a lot.

[@SandraSantos-rp1wp]

Vern Hyndman
Thank you very much for give your time. You are helping me a lot. THANK YOU VERY MUCH. Take good care of yourself.

[@jfesmire]

Thank you! I'm calculating the finances for a Kickstarter project and needed to make my own spreadsheet... which I'll probably share so others can use it. Anyway, this is helping me put it together quickly!

[@thomasradar1860]

Thanks. Finally a video that is totally simple and understandable.

[@lovenpeace271]

thanks-just need a basic tutorial and this one does it perfectly

[@just4NGL]

OMG Thank you sooooo much for this video. I didn't know how to copy and paste the formula from one cell to another, but now I do. You saved my day; now I can continue doing my homework :)

[@nigdyzapozno]

This is the most cryptic tutorial I've seen in my life:)

[@NoraMackey]

So easy to follow, thank you for uploading it.

[@wakelax]

Exactly what i was looking, This was so much easier than i thought.

[@ooalmondjoy00]

You showed me shortcuts!!!
Thanks for saving me time and frustration

[@CaptainBvi]

Girl friend needed help with this for school. I never took this subject but thanks to you i SCORED me some brownie points.

[@abosedeademosu4989]

Thanks so much for this. I love them simplicity in your explanation.

[@kajehn1]

Thanks. good tutorial. Exactly what I was looking for

[@genius90262]

You're amazing!! All the postings here speak for your performance. I was struggling until I ran into your video. :)

[@deidara2512]

thanks lol,i missed my today's computing class,good thing i came to this vid :)

[@TheLoFiction]

love it....has been very useful for me. doing an excel based assessment for uni and this was just what i needed. thank you!

[@StrictlyStreetMedia]

Thank you so much for this video... It just saved my ass for loosing easy marks on an assignment!

[@ALLeaseALLdayTUBE]

Thank you for this. you just saved me so much time. VERY HELPFUL!

[@Kaibil66]

Thanks for the time to make this video.. I`ll practice using it.

[@jolieandbooch]

Thank you so much for this video. I was able to finish my excel homework.

[@kmaf08]

thank so much...very well communicated and visually easy to follow!

[@playstationowner]

THANK YOU, YOU ARE A LIFE SAVER.

[@mistimo1st]

I swear You are miles better than my professor....

[@EscalanteFlyFlipper]

sweeeeeeet...saved me lots of study time on basics...cool

[@Shortmandesigner]

Thank you so much for posting this video! I just happened to be working on an Excel assignment for school and I ran into some formula trouble. Keep up the good work, and I hope you get over your cough soon. Could you do a few for Microsoft Access if at all possible too please? I'm going to be in that section soon, and I have no idea how to use it.

[@MrGazp77]

thanks for taking the time to explain many many thanks

[@ajibola35]

Thank you so much this tutorial helped me solve a defective spreadsheet my accountant sent me

[@e7venjedi]

One thing to add, this works for OpenOffice software as well, in case anyone was wondering. (thumbs up so other people can see?)
Very helpful! I never knew how powerful a tool this was for computing -- i can see why businesses started using this the moment it was invented. :-D I will probably revisit this again cuz I got the basics but it is still a lot to digest in one sitting :P Or maybe I'm just slow!

[@ailinglin5295]

Thanks, it helped! Good tutorial!

[@gemmology]

Thanks for sharing , interesting and very help in my daily office work.

[@victor070]

god bless you. you just saved a chemistry student from israeli university, shame on me i cant use excel. lol! THANK YOU!!

[@munahbell872]

Very useful. Basic but Clear! Thank you very much for sharing. x

[@KvLSilverUnicorn]

Thank you for the refresher.

[@asg3709]

best one in youtube so far

[@jaccaification]

Thanks a million you have just made my life so much easier :)

[@ebonybarbie88]

Thank u soo much I really needed this for an interview and u might have just help me get the job!

[@taraandmike1]

Very helpful!! Thanks for taking the time to do this video!

[@jamiehobbs3750]

Simple, and brilliant. Thanks a bunch!

[@AbdulWahid-xb5te]

Thanks for the video it did helped me a lot in my practical exam

[@taraknathgorai9906]

Nice dude,you help to improve my skill.

[@apsjr1]

sir,
thank you for everything i just made a grocery list formula to help me with my budget thank a lot man

[@amiduibrahim1609]

THANKS FOR THIS TUTORIAL VERY EXPLANATORY

[@KrishSanj]

That color scheme looks good :)

[@iflatland]

i like how he coughs to keep us awake. great tutorial!

[@514relaxmode]

Great refresher, Thanks!!

[@CJKeig]

Very nice, didn't realise that's what the box did. Cheers :)

[@1878Devils]

thank you so much... i had my exam tomorrow... understood most of it :)

[@alonsobello3787]

THanks for the refresher. Btw.. you might want to turn off that diesel engine in the background...

[@3opinion4all]

Thanks this tutorial helped me alot for my ict exam

[@christenlawless5284]

Thank you!! You'd think a college student would know this stuff already... DUHH!!!

[@Aldoo97]

Much love, helped me with my computing homework.

[@riotgirrrrrl]

yay!! thanks did my first excel formula
thanks!

[@shahidkhan-mb8rm]

your saved my lot of time thanku vvvvvvv much

[@bigrevkev55]

Thank you very much! 2:28-3:00 on replicating is what I have been looking for for a looong time! Finally!

[@donblaa]

helped me out alot, thanks lol, 10 years later

[@jaworskij]

I'd like to see more like this...can you do one showing the COUNTIF and VLOOKUP functions?

[@Genuina78]

Thank you so much for posting this..! It really helped me. So easy to understand! :)

[@boshi44]

Well done thanks for your time and effort.

[@AnnaMRoman-ln3fy]

Thank you so much for that excellent tutorial. It really helped me a lot.

[@vietcuzzz]

its all coming back to me now. thanks! haha

[@SarifUddin]

This excel formula is useful, thank.

[@evamariecreations]

great, exactly what I needed! thankyou so much for your pertinent information. THANKS

[@katrinasmith5024]

Thanks this was very very informative.

[@jennasbb7848]

Great video - really helpful.

[@sujantiwari950]

watching 11 years and 5 days after this was uploaded.

[@dinakarsoul]

thanks.... learnt quite a bit for a beginner👍

[@sarahsaweeris533]

Thank you so much !!! it really helped a lot

[@sarahsaweeris533]

yes!!.. I have studied it a year and a half ago, but need to remind myself the basic excel activities.

[@fahad203]

Thank you. Was very informative.