Excel 2010 Tutorial For Beginners #4 - AutoSum Function (Microsoft Excel)

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ก.ย. 2024

ความคิดเห็น • 123

  • @karac.4744
    @karac.4744 8 ปีที่แล้ว +60

    You are saving all those people who lied on their resume about being competent in Excel! Thank you, Motion Training!

    • @alikashmar7216
      @alikashmar7216 8 ปีที่แล้ว +3

      heheh yeah true, that's what happens to me

    • @makeupbyife
      @makeupbyife 7 ปีที่แล้ว +3

      While i am taking this in ever so deeply

    • @marcangeloamaya630
      @marcangeloamaya630 7 ปีที่แล้ว +1

      Motion Training surely does!

    • @krzwis5632
      @krzwis5632 6 ปีที่แล้ว +2

      I am literally watching this because I wrote "intermediate skill on Excel" instead of "beginner" on an application. This is really helpful

    • @naturallytuli8536
      @naturallytuli8536 6 ปีที่แล้ว +1

      caught...thats me!

  • @erinjames5611
    @erinjames5611 9 ปีที่แล้ว +39

    I have officially learned more in 4 excel tutorials that are 10 minutes or less than I ever did taking an entire quarter of computer science in college. Thank you sir!

  • @msv3630
    @msv3630 3 ปีที่แล้ว +2

    I don't know how anyone can dislike this video and I', 100% not Excel literate and following this video using Zoho Spreadsheets instead.
    I had to skip two videos that didn't keep my attention nor did I understand at all until I watched this video and it save me!
    Not too boring, speech was clear, understandable for someone who's not literate at all and kept my attention towards the end of the video!
    This was actually for an emergency to see how to total my income. I never had the urge to learn Excel but this video made me want to do it now! Hope there's more tutorials so I can subscribe! Total thank you!

  • @BrendonFerullo16
    @BrendonFerullo16 11 ปีที่แล้ว +3

    This guy is great! Very thorough and useful. I was going to buy a training DVD online but clearly there's no need for that since this tutorial is available.
    Thanks a lot!

  • @ANDREWEBSTER
    @ANDREWEBSTER 9 ปีที่แล้ว +2

    I just wanted to say thank you.You have made my job so much easier .

  • @cheytul
    @cheytul 9 ปีที่แล้ว +1

    These video's are very helpful and they are helping me to appreciate Excel more. Thank you!

  • @Denise0236
    @Denise0236 10 ปีที่แล้ว +6

    These videos are life saving..thank you so much for explaining everything in detail.

  • @bsaman1
    @bsaman1 10 ปีที่แล้ว +3

    Really useful and very easy to understand thanks to your teaching technique as sometimes people speak to quickly.
    Helped me a lot, Thanks very much!

  • @TheRedSoxFanChip
    @TheRedSoxFanChip 8 ปีที่แล้ว +2

    Thank you for these tutorials, they are a big help to a newb like me!

  • @gord2358
    @gord2358 6 ปีที่แล้ว +1

    Never knew something so simple could be made so complicated.

  • @msdeedaartist6385
    @msdeedaartist6385 11 ปีที่แล้ว +1

    I loved the video it was easy to understand and very thorough. I will come back to view more tutorials.

  • @JeremyUM
    @JeremyUM 11 ปีที่แล้ว +1

    You are the shit bro! I've looked at several tutorials (including some by Microsoft) and yours are, by far, the easiest to learn from. Well done! Cheers!

  • @natalienyampruh3088
    @natalienyampruh3088 11 ปีที่แล้ว +1

    Great teacher!! Really easy to understand and great pointers for people like me who has a beginnning to intermediate background with Excel

  • @cristinavalle5266
    @cristinavalle5266 10 ปีที่แล้ว +3

    Thank you for posting these tutorials! They've helped me so much!

  • @zl99prototype30
    @zl99prototype30 10 ปีที่แล้ว +1

    it really help me a lot. it also make me faster when i apply this to my exam as some method are simple and fast to apply. therefore it will spend less time in typing all the answer as is one easy step to find all the answer in one short for that question in my exam i will apply all the method i learn in your video for my exam. those method of your is easier and faster and it help me a lot. thanks! :D

  • @ivoandonov3058
    @ivoandonov3058 9 ปีที่แล้ว +2

    Thank you very much for these tutorials, they are very interesting and your explanation is very good , thank you alot

  • @mgsoeng1506
    @mgsoeng1506 6 หลายเดือนก่อน

    Thanks for different ways presented. Appreciate it sir .

  • @moodchangetv8878
    @moodchangetv8878 3 ปีที่แล้ว +1

    this helps for my studies!!!! thank you!!!!!!

  • @xxgogsxx
    @xxgogsxx 11 ปีที่แล้ว +2

    Your videos are extremely helpful. Thanks for posting!

  • @Sushimushi__
    @Sushimushi__ ปีที่แล้ว +1

    Really helped thanks!

  • @vangelova7443
    @vangelova7443 4 ปีที่แล้ว +2

    Thank you so much for your clear and amazing explanation! It does make Excel interesting!!! Thank you!

  • @theoverachiever34
    @theoverachiever34 10 ปีที่แล้ว +1

    These tutorials are so helpful...Thank you

  • @Finch659
    @Finch659 11 ปีที่แล้ว +2

    This has been EXCELlent

  • @carwen40
    @carwen40 11 ปีที่แล้ว +1

    I am SOOOOOOO excited about this!! Thank you so much!!! This is helping me!!!

  • @AsadHanifSJ
    @AsadHanifSJ 10 ปีที่แล้ว +3

    Excellent JOB Done Many Many Thanks for these Helps & I hope that you will continue helping people like me who are just in the beaning user in the MS Office Again Many Many Thanks. So Easy Not boring at all. HD video and clear voice that's help me allot THANKS .....

  • @Richdude1983
    @Richdude1983 11 ปีที่แล้ว +1

    This is very good. Thank you for both the time and effort.

  • @sophiebettyclark
    @sophiebettyclark 11 ปีที่แล้ว +1

    you need to put a colon between the 2 so it should be =sum(B1:B5) and make sure all the cells are selected

  • @franzdaboi3131
    @franzdaboi3131 6 ปีที่แล้ว +1

    this helped me on my assignment! thanks!

  • @Jackyshadow
    @Jackyshadow 10 ปีที่แล้ว +5

    Really useful and easy to follow videos. Thanks heaps!

  • @vallerieanyona3944
    @vallerieanyona3944 3 ปีที่แล้ว

    who's here in 2021 and loving it? I am

  • @oredata2k
    @oredata2k 11 ปีที่แล้ว +1

    Thank You! This is indeed helpful. Just grateful!!

  • @briansibusisomahlangu
    @briansibusisomahlangu 9 ปีที่แล้ว +7

    Your video was extremely helpful... Thank you

  • @TheKosssss
    @TheKosssss 11 ปีที่แล้ว

    I Think I am not The First Person Telling You This But Thank You Alot, You better Be lucky, 26000 people loving You Around The the World :)))))

  • @birungijustine2717
    @birungijustine2717 ปีที่แล้ว

    Wow!
    Thank you.
    You have real save me.

  • @sqdxb
    @sqdxb 2 ปีที่แล้ว

    Great job....thank you sir

  • @Karkure
    @Karkure 3 ปีที่แล้ว

    It is a big help full your video

  • @gashafashi08
    @gashafashi08 10 ปีที่แล้ว +2

    Thanks for the great tutorial. I have learn t a whole lot!

  • @d8p399
    @d8p399 11 ปีที่แล้ว

    Bang on, the best tutorial see so far... keep up the good work

  • @maxammedcabdi8885
    @maxammedcabdi8885 11 ปีที่แล้ว +1

    Amazing! this is excellent tutorial videos

  • @rcx8777c
    @rcx8777c 9 ปีที่แล้ว

    I LOVE EXCEL
    IT IS SO EASY TO USE.
    THE KEY IS USING THE CELL ADDRESS AND NOT THE CELL VALUE.

  • @dinoyebrahimsalih4342
    @dinoyebrahimsalih4342 ปีที่แล้ว

    Wow works quite well

  • @ratuadil100
    @ratuadil100 10 ปีที่แล้ว +1

    Super east to follow and stays on track too.

  • @janielremitar11
    @janielremitar11 8 หลายเดือนก่อน

    Thank you very much sir.

  • @JorgChoco
    @JorgChoco 6 ปีที่แล้ว

    you are a good teacher

  • @jaix21
    @jaix21 9 ปีที่แล้ว +4

    Hello Sir! Thank you so much for the tutorials! You're keeping it very simple and very easy to understand. However, in this 4th part of your video, it became blurry. If you would be so kind to re-upload the video? As I can't find another tutorial which is as best as you are doing. Hope for your immediate response! God bless you sir! :)

  • @Schleck71
    @Schleck71 11 ปีที่แล้ว +1

    Love it !!! Great tutorials, congrats !!!! :)

  • @hadizarbafi8910
    @hadizarbafi8910 9 ปีที่แล้ว +1

    This site is great. I have a question about subtracting. Let's say you have a number 1000 and you want to subtract 5 cells in a column from that in one action, how would you do that? I tried it intuitively but I keep getting !Value? in the box.
    Thaks in advance

    • @Araym88
      @Araym88 8 ปีที่แล้ว

      +Hadi Zarbafi cell A1=1000 and want to subtract from it cells A2-4 for ex in cell A5. You write in cell A5 like this -> =A1-(SUM(A2:A4)). If that's what you wanted to do.

  • @harishn1769
    @harishn1769 6 ปีที่แล้ว

    thank you bro i have learnt a lot from this video

  • @tempestgaming9840
    @tempestgaming9840 4 ปีที่แล้ว

    Love from India

  • @chuang5062
    @chuang5062 11 ปีที่แล้ว +1

    You are a really good teacher. Just wondering if I learn all the stuff in all your videos, is it enough for most Admin works?

  • @emperatriz.v.s.1702
    @emperatriz.v.s.1702 9 ปีที่แล้ว

    Thank you! It's a big help for my work. :)

  • @fixhdfjfd3643
    @fixhdfjfd3643 4 ปีที่แล้ว +12

    Any one here from online class

  • @stupidcowwss
    @stupidcowwss 8 ปีที่แล้ว +2

    Mine keeps saying 0 whenever i calculate?

  • @Tejtd
    @Tejtd 10 ปีที่แล้ว

    thanks man!!

  • @angelathornton7279
    @angelathornton7279 9 ปีที่แล้ว +1

    Very helpful thank you

  • @patelstudio4051
    @patelstudio4051 3 ปีที่แล้ว +1

    Helpful 😉

  • @mduddin3425
    @mduddin3425 11 ปีที่แล้ว

    your great mate helped me a lot. by far the best tutorial

  • @doyourbst
    @doyourbst 11 ปีที่แล้ว

    Great job in teaching this! I am a teacher you are great!

  • @janielremitar11
    @janielremitar11 8 หลายเดือนก่อน

    Yes!!! I got it.

  • @quintoflyer
    @quintoflyer 5 ปีที่แล้ว

    very good

  • @joesanmiguel678
    @joesanmiguel678 9 ปีที่แล้ว +1

    this helped me out so much, very helpful

  • @james02Perry
    @james02Perry 11 ปีที่แล้ว

    Very cool tips.
    U r a genius!

  • @shakyjake64
    @shakyjake64 11 ปีที่แล้ว +2

    Is it possible to lock certain cells, like the cells with text? So if multiple people are going to be using a file they can change the values in the number cells but not change the text in the cells with text in them?

  • @tearful50
    @tearful50 11 ปีที่แล้ว

    select all of them by using ctrl or shift keys

  • @mx.louweaver2772
    @mx.louweaver2772 2 ปีที่แล้ว

    BLESS U

  • @mmakho7708
    @mmakho7708 6 ปีที่แล้ว

    thank you very much. Love it

  • @GHiNMOTO
    @GHiNMOTO 6 ปีที่แล้ว

    Fantastic

  • @tarikulislam6144
    @tarikulislam6144 6 ปีที่แล้ว

    thanks

  • @devinparker6230
    @devinparker6230 11 ปีที่แล้ว

    This is awesome!!!!

  • @Thanhdung73
    @Thanhdung73 9 ปีที่แล้ว +1

    Thankyou sir.

  • @whoisadrn4350
    @whoisadrn4350 3 ปีที่แล้ว +1

    i’m taking a test. hurry up

  • @1000frolly
    @1000frolly 9 ปีที่แล้ว

    AutoSum does not work for me because all the numbers are generated by another function.
    How can I add up the column in my case?

  • @mohdrehan7886
    @mohdrehan7886 7 ปีที่แล้ว

    Wonderful.

  • @w4yn6
    @w4yn6 11 ปีที่แล้ว

    what can I say? you have great taste in movies..

  • @crystalthompson9828
    @crystalthompson9828 5 ปีที่แล้ว

    Thank youuuuuu

  • @tusharwaghmare7062
    @tusharwaghmare7062 7 ปีที่แล้ว

    nice

  • @seaofclay
    @seaofclay 11 ปีที่แล้ว

    Cheers for the help mate, nice one!! X

  • @toastoneggs7356
    @toastoneggs7356 6 ปีที่แล้ว

    WHY AM I ADDICTED TO THESE VIDEOS HOW???b!

  • @sababaratashvili8629
    @sababaratashvili8629 8 ปีที่แล้ว

    Thanks for the video!

  • @sonu1patel
    @sonu1patel 10 ปีที่แล้ว

    Hi do you have the data file I can download

  • @shioribushin
    @shioribushin 11 ปีที่แล้ว

    Thank you so much :D

  • @hcherag-zade5553
    @hcherag-zade5553 6 ปีที่แล้ว

    Brilliant, Thank you

  • @LinaVera4
    @LinaVera4 11 ปีที่แล้ว

    tHANKS SO MUCH great video

  • @buggiebars
    @buggiebars 11 ปีที่แล้ว

    life saver

  • @expiredid82929
    @expiredid82929 11 ปีที่แล้ว

    good one. keep it up :)

  • @24husemag
    @24husemag 11 ปีที่แล้ว

    too bad there is only like button on TH-cam no Love it button

  • @anishajain6403
    @anishajain6403 7 ปีที่แล้ว

    When I press enter after typing the formula it shows 0. Please help sir.

  • @vampiregoat69
    @vampiregoat69 3 ปีที่แล้ว

    in 2021 I don't have that autosum button at all

  • @kevinjames753
    @kevinjames753 8 ปีที่แล้ว

    Good Job!

  • @mainuddin8327
    @mainuddin8327 2 ปีที่แล้ว

    👍👍👍👌👌

  • @xxylitx6996
    @xxylitx6996 11 ปีที่แล้ว

    Thanks a lot !!

  • @maprilganhao8117
    @maprilganhao8117 7 ปีที่แล้ว

    I do like you say but my total is zeros

  • @jairuscyriltimbang8942
    @jairuscyriltimbang8942 11 หลายเดือนก่อน

    😊

  • @1aligsbsu
    @1aligsbsu 9 ปีที่แล้ว

    please somebody help me. in rental price when I write 2.3 it turns to the date but when I write 2,3 it calculates the income but does not auto sum. what is the problem there?

  • @nnennaenemo795
    @nnennaenemo795 4 ปีที่แล้ว

    ok

  • @ProoDevis
    @ProoDevis ปีที่แล้ว

    Gr

  • @b3astboy371
    @b3astboy371 8 ปีที่แล้ว +4

    Meh Dads Forcing MEh to Learn this

  • @Zeroforce14
    @Zeroforce14 3 ปีที่แล้ว

    =sum9

  • @djgb1980
    @djgb1980 ปีที่แล้ว

    This is the shit!

  • @blackwalker1988
    @blackwalker1988 7 ปีที่แล้ว

    anyone in high school taking a computer class ._.