Excel Spread Sheet Basics - Using a Formula

Поделиться
HTML-код
  • Опубликовано: 22 фев 2007
  • 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...
  • ХоббиХобби

Комментарии • 443

  • @bereancarpenter
    @bereancarpenter 9 лет назад +1

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

  • @zordanxxx
    @zordanxxx 7 лет назад +2

    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
    @vhyndman  16 лет назад +6

    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
      @SKM879 6 лет назад

      Thank you for your simple explanation of not easy formulas.

  • @Kyon65
    @Kyon65 16 лет назад

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

  • @christelc2783
    @christelc2783 5 лет назад +1

    Even 12 years later this video is still useful 👍🏽

  • @zitlalyjudithalfaro313
    @zitlalyjudithalfaro313 2 года назад

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

  • @annredgewell8650
    @annredgewell8650 8 лет назад +5

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

  • @annieplanet8
    @annieplanet8 13 лет назад

    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

  • @shugabee9307
    @shugabee9307 8 лет назад

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

  • @ebonyfruitbat_fb7593
    @ebonyfruitbat_fb7593 4 года назад

    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
    @shazdee 14 лет назад

    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.

  • @Englistanii
    @Englistanii 12 лет назад

    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.

  • @CroGirlZg
    @CroGirlZg 10 лет назад

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

  • @mikeg3774
    @mikeg3774 9 лет назад

    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.

  • @zordanxxx
    @zordanxxx 8 лет назад

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

  • @xIvelisse
    @xIvelisse 10 лет назад +6

    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!

  • @wangcandice6952
    @wangcandice6952 9 лет назад +4

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

  • @j1j11j
    @j1j11j 15 лет назад

    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.

  • @JacYates
    @JacYates 11 лет назад

    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.

  • @Mscubanlink24
    @Mscubanlink24 16 лет назад +1

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

  • @mazr2006
    @mazr2006 15 лет назад

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

  • @haciendabear
    @haciendabear 11 лет назад

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

  • @vhyndman
    @vhyndman  15 лет назад +3

    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
      @ianm.7929 6 лет назад

      Good video. I learned a lot.

    • @SandraSantos-rp1wp
      @SandraSantos-rp1wp 6 лет назад

      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.

  • @wizardrizk1885
    @wizardrizk1885 7 лет назад +7

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

  • @nigdyzapozno
    @nigdyzapozno 8 лет назад

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

  • @bigrevkev55
    @bigrevkev55 12 лет назад

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

  • @thomasradar1860
    @thomasradar1860 4 года назад

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

  • @kokaimanawatokuingoa8440
    @kokaimanawatokuingoa8440 6 лет назад

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

  • @thePeziie
    @thePeziie 6 лет назад

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

  • @lwarfield52
    @lwarfield52 6 лет назад

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

  • @heythereitsjimbo
    @heythereitsjimbo 11 лет назад

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

  • @just4NGL
    @just4NGL 12 лет назад

    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 :)

  • @allain666
    @allain666 15 лет назад

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

  • @deidara2512
    @deidara2512 12 лет назад

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

  • @jfesmire
    @jfesmire 11 лет назад

    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!

  • @genius90262
    @genius90262 16 лет назад

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

  • @CaptainBvi
    @CaptainBvi 10 лет назад

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

  • @wakelax
    @wakelax 13 лет назад

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

  • @CascadaGaming
    @CascadaGaming 12 лет назад

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

  • @1878Devils
    @1878Devils 10 лет назад +3

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

  • @ooalmondjoy00
    @ooalmondjoy00 16 лет назад

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

  • @veganchevychick
    @veganchevychick 9 лет назад +94

    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
      @mohammedjafferali693 8 лет назад +2

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

    • @hamzadesomer9840
      @hamzadesomer9840 7 лет назад +1

      Bless u

    • @SKM879
      @SKM879 6 лет назад

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

  • @NoraMackey
    @NoraMackey 5 лет назад

    So easy to follow, thank you for uploading it.

  • @e7venjedi
    @e7venjedi 13 лет назад

    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!

  • @jayrsagittaruis1110
    @jayrsagittaruis1110 12 лет назад

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

  • @asg3709
    @asg3709 8 лет назад

    best one in youtube so far

  • @jolieandbooch
    @jolieandbooch 5 лет назад

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

  • @TheLoFiction
    @TheLoFiction 14 лет назад

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

  • @jaccaification
    @jaccaification 12 лет назад

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

  • @adamnaughty
    @adamnaughty 15 лет назад

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

  • @ailinglin5295
    @ailinglin5295 10 лет назад +4

    Thanks, it helped! Good tutorial!

  • @Shortmandesigner
    @Shortmandesigner 16 лет назад

    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.

  • @EscalanteFlyFlipper
    @EscalanteFlyFlipper 14 лет назад

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

  • @ALLeaseALLdayTUBE
    @ALLeaseALLdayTUBE 12 лет назад

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

  • @iflatland
    @iflatland 14 лет назад +1

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

  • @aazanova
    @aazanova 14 лет назад

    Thanks so much you just saved me 87 hours of calculations

  • @lovenpeace271
    @lovenpeace271 11 лет назад

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

  • @kajehn1
    @kajehn1 7 лет назад +2

    Thanks. good tutorial. Exactly what I was looking for

  • @abosedeademosu4989
    @abosedeademosu4989 6 лет назад

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

  • @jamiehobbs3750
    @jamiehobbs3750 7 лет назад

    Simple, and brilliant. Thanks a bunch!

  • @StrictlyStreetMedia
    @StrictlyStreetMedia 10 лет назад

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

  • @ebonybarbie88
    @ebonybarbie88 12 лет назад

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

  • @apsjr1
    @apsjr1 15 лет назад

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

  • @alonsobello3787
    @alonsobello3787 10 лет назад +8

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

  • @KrishSanj
    @KrishSanj 9 лет назад

    That color scheme looks good :)

  • @ajibola35
    @ajibola35 9 лет назад +3

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

  • @playstationowner
    @playstationowner 15 лет назад

    THANK YOU, YOU ARE A LIFE SAVER.

  • @Babygingersporty101
    @Babygingersporty101 12 лет назад

    I love that moment at 0:55 when a killer came in your room lol

  • @christenlawless5284
    @christenlawless5284 10 лет назад +4

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

  • @taraandmike1
    @taraandmike1 13 лет назад

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

  • @CJKeig
    @CJKeig 12 лет назад

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

  • @dannyesquiagola7978
    @dannyesquiagola7978 9 лет назад

    Very Helpful.
    smooth sailing!

  • @munahbell872
    @munahbell872 11 лет назад

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

  • @Aldoo97
    @Aldoo97 12 лет назад

    Much love, helped me with my computing homework.

  • @Kaibil66
    @Kaibil66 11 лет назад

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

  • @Genuina78
    @Genuina78 14 лет назад

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

  • @AnnaMRoman-ln3fy
    @AnnaMRoman-ln3fy 10 лет назад

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

  • @georgiaking4805
    @georgiaking4805 8 лет назад

    That was the best tutorial! Thank you :)

  • @AbdulWahid-xb5te
    @AbdulWahid-xb5te 7 лет назад

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

  • @gemmology
    @gemmology 12 лет назад

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

  • @taraknathgorai9906
    @taraknathgorai9906 7 лет назад

    Nice dude,you help to improve my skill.

  • @evamariecreations
    @evamariecreations 11 лет назад

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

  • @sarahsaweeris533
    @sarahsaweeris533 10 лет назад +2

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

    • @sarahsaweeris533
      @sarahsaweeris533 10 лет назад

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

  • @PaulyJackson
    @PaulyJackson 13 лет назад

    thank you...it helped me in my math homework=)

  • @vhyndman
    @vhyndman  14 лет назад

    @Martin8567 The easiest and safest thing to do is to select only the columns and rows you WANT to send to your customer, and print them to a PDF file.
    Another way is to select the rows and columns, copy them (either control C or rightclick copy) and then open a new sheet and "paste special" and paste in the values, rasther than the formulas. Send THIS spreadsheet to him... it's way safer than most other methods.

  • @shahidkhan-mb8rm
    @shahidkhan-mb8rm 7 лет назад

    your saved my lot of time thanku vvvvvvv much

  • @okokc11
    @okokc11 10 лет назад

    thank you for this lesson. it helped me a lot

  • @kmaf08
    @kmaf08 17 лет назад

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

  • @3opinion4all
    @3opinion4all 10 лет назад

    Thanks this tutorial helped me alot for my ict exam

  • @vhyndman
    @vhyndman  14 лет назад

    @Martin8567 The easiest and safest thing to do is to select only the columns and rows you WANT to send to your customer, and print them to a PDF file.
    Another way is to select the rows and columns, copy them (either control C or rightclick copy) and then open a new sheet and "paste special" and paste in the values, rather than the formulas. Send THIS spreadsheet to him... it's way safer than most other methods.

  • @mistimo1st
    @mistimo1st 11 лет назад

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

  • @joyherring81
    @joyherring81 10 лет назад +1

    Thank you very helpful!

  • @iqramubeen8248
    @iqramubeen8248 8 лет назад

    perfect solution of my problem Sir thank you so much

  • @MrGazp77
    @MrGazp77 14 лет назад

    thanks for taking the time to explain many many thanks

  • @sujantiwari950
    @sujantiwari950 6 лет назад +1

    watching 11 years and 5 days after this was uploaded.

  • @jaytok7
    @jaytok7 10 лет назад

    bro ur a life saver lol..thanks basic but I needed to know it :D

  • @514relaxmode
    @514relaxmode 4 года назад

    Great refresher, Thanks!!

  • @riotgirrrrrl
    @riotgirrrrrl 11 лет назад

    yay!! thanks did my first excel formula
    thanks!

  • @KvLSilverUnicorn
    @KvLSilverUnicorn 12 лет назад

    Thank you for the refresher.

  • @vietcuzzz
    @vietcuzzz 16 лет назад

    its all coming back to me now. thanks! haha