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

Тәжірибелік нұсқаулар және стиль

For more MS Office tutorials (Excel, PowerPoint, Word & Access) please visit
legacyskillsgroup.com
This Excel 2010 tutorial shows various ways of using the AutoSum function including editing and copying functions.
More tutorials to follow.

Пікірлер: 123

  • @karac.4744
    @karac.47448 жыл бұрын

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

  • @alikashmar7216

    @alikashmar7216

    8 жыл бұрын

    heheh yeah true, that's what happens to me

  • @makeupbyife

    @makeupbyife

    7 жыл бұрын

    While i am taking this in ever so deeply

  • @marcangeloamaya630

    @marcangeloamaya630

    7 жыл бұрын

    Motion Training surely does!

  • @krzwis5632

    @krzwis5632

    6 жыл бұрын

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

  • @naturallytuli8536

    @naturallytuli8536

    5 жыл бұрын

    caught...thats me!

  • @erinjames5611
    @erinjames56119 жыл бұрын

    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
    @msv36303 жыл бұрын

    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!

  • @Denise0236
    @Denise02369 жыл бұрын

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

  • @TheAntonellav
    @TheAntonellav8 жыл бұрын

    Thanks to such a wonderful trainer. I always though that excel was boring and difficult. But thanks to this lessons, I am actually learning it and enjoying it too.

  • @Ebi.Adonkie
    @Ebi.Adonkie3 жыл бұрын

    What a teacher! You're amazing dear Sir

  • @cristinavalle5266
    @cristinavalle526610 жыл бұрын

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

  • @cheytul
    @cheytul9 жыл бұрын

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

  • @ANDREWEBSTER
    @ANDREWEBSTER9 жыл бұрын

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

  • @BrendonFerullo16
    @BrendonFerullo1611 жыл бұрын

    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!

  • @TheRedSoxFanChip
    @TheRedSoxFanChip8 жыл бұрын

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

  • @bsaman1
    @bsaman110 жыл бұрын

    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!

  • @gord2358
    @gord23585 жыл бұрын

    Never knew something so simple could be made so complicated.

  • @xxgogsxx
    @xxgogsxx11 жыл бұрын

    Your videos are extremely helpful. Thanks for posting!

  • @nerlande7780
    @nerlande77809 жыл бұрын

    These tutorials are so helpful...Thank you

  • @carwen40
    @carwen4011 жыл бұрын

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

  • @mgsoeng1506
    @mgsoeng15064 ай бұрын

    Thanks for different ways presented. Appreciate it sir .

  • @natalienyampruh3088
    @natalienyampruh308811 жыл бұрын

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

  • @ivoandonov3058
    @ivoandonov30589 жыл бұрын

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

  • @Sushimushi__
    @Sushimushi__ Жыл бұрын

    Really helped thanks!

  • @gashafashi08
    @gashafashi0810 жыл бұрын

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

  • @vallerieanyona3944
    @vallerieanyona39443 жыл бұрын

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

  • @oredata2k
    @oredata2k10 жыл бұрын

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

  • @JeremyUM
    @JeremyUM11 жыл бұрын

    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!

  • @msdeedaartist6385
    @msdeedaartist638511 жыл бұрын

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

  • @Richdude1983
    @Richdude198311 жыл бұрын

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

  • @Schleck71
    @Schleck7111 жыл бұрын

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

  • @shakyjake64
    @shakyjake6410 жыл бұрын

    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?

  • @moodchangetv8878
    @moodchangetv88783 жыл бұрын

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

  • @emperatriz.v.s.1702
    @emperatriz.v.s.17029 жыл бұрын

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

  • @d8p399
    @d8p39911 жыл бұрын

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

  • @Finch659
    @Finch65911 жыл бұрын

    This has been EXCELlent

  • @franzdaboi3131
    @franzdaboi31315 жыл бұрын

    this helped me on my assignment! thanks!

  • @zl99prototype30
    @zl99prototype309 жыл бұрын

    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

  • @birungijustine2717
    @birungijustine2717 Жыл бұрын

    Wow! Thank you. You have real save me.

  • @maxammedcabdi8885
    @maxammedcabdi888511 жыл бұрын

    Amazing! this is excellent tutorial videos

  • @mmakho7708
    @mmakho77085 жыл бұрын

    thank you very much. Love it

  • @sqdxb
    @sqdxb Жыл бұрын

    Great job....thank you sir

  • @devinparker6230
    @devinparker623010 жыл бұрын

    This is awesome!!!!

  • @james02Perry
    @james02Perry10 жыл бұрын

    Very cool tips. U r a genius!

  • @dinoyebrahimsalih4342
    @dinoyebrahimsalih4342 Жыл бұрын

    Wow works quite well

  • @Jackyshadow
    @Jackyshadow9 жыл бұрын

    Really useful and easy to follow videos. Thanks heaps!

  • @briansibusisomahlangu
    @briansibusisomahlangu9 жыл бұрын

    Your video was extremely helpful... Thank you

  • @abetes5422
    @abetes542211 жыл бұрын

    thanks again sir, you are really doing an excellent job helping people around the world, if keep doing what you are doing forever would be awesome:) because you are using youtube for the best effect( educating people). Thanks again!

  • @janielremitar11
    @janielremitar115 ай бұрын

    Thank you very much sir.

  • @harishn1769
    @harishn17696 жыл бұрын

    thank you bro i have learnt a lot from this video

  • @angelathornton7279
    @angelathornton72799 жыл бұрын

    Very helpful thank you

  • @Karkure
    @Karkure3 жыл бұрын

    It is a big help full your video

  • @chocolatetye797
    @chocolatetye797 Жыл бұрын

    Thank you so much

  • @Tejtd
    @Tejtd9 жыл бұрын

    thanks man!!

  • @JorgChoco
    @JorgChoco6 жыл бұрын

    you are a good teacher

  • @janielremitar11
    @janielremitar115 ай бұрын

    Yes!!! I got it.

  • @nicolehawkes9939
    @nicolehawkes99399 жыл бұрын

    thank you so much!

  • @chuang5062
    @chuang506211 жыл бұрын

    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?

  • @AsadHanifSJ
    @AsadHanifSJ9 жыл бұрын

    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 .....

  • @mx.louweaver2772
    @mx.louweaver27722 жыл бұрын

    BLESS U

  • @popoetic
    @popoetic2 жыл бұрын

    I have (Total:) in the same cell as the totals answer how do I prevent the answer from moving the word (Total:). E.g (Total:) is in the left hand side of the cell and I want the number in the right hand side of the cell.

  • @stupidcowwss
    @stupidcowwss8 жыл бұрын

    Mine keeps saying 0 whenever i calculate?

  • @hadizarbafi8910
    @hadizarbafi89109 жыл бұрын

    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.

  • @quintoflyer
    @quintoflyer5 жыл бұрын

    very good

  • @vangelova7443
    @vangelova74434 жыл бұрын

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

  • @sophiebettyclark
    @sophiebettyclark10 жыл бұрын

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

  • @shioribushin
    @shioribushin10 жыл бұрын

    Thank you so much :D

  • @mohdrehan7886
    @mohdrehan78867 жыл бұрын

    Wonderful.

  • @1000frolly
    @1000frolly9 жыл бұрын

    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?

  • @GHiNMOTO
    @GHiNMOTO6 жыл бұрын

    Fantastic

  • @tempestgaming9840
    @tempestgaming98403 жыл бұрын

    Love from India

  • @crystalthompson9828
    @crystalthompson98285 жыл бұрын

    Thank youuuuuu

  • @Thanhdung73
    @Thanhdung739 жыл бұрын

    Thankyou sir.

  • @rcx8777c
    @rcx8777c9 жыл бұрын

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

  • @TheKosssss
    @TheKosssss11 жыл бұрын

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

  • @sonu1patel
    @sonu1patel9 жыл бұрын

    Hi do you have the data file I can download

  • @joesanmiguel678
    @joesanmiguel6789 жыл бұрын

    this helped me out so much, very helpful

  • @tarikulislam6144
    @tarikulislam61446 жыл бұрын

    thanks

  • @tusharwaghmare7062
    @tusharwaghmare70627 жыл бұрын

    nice

  • @expiredid82929
    @expiredid8292911 жыл бұрын

    good one. keep it up :)

  • @buggiebars
    @buggiebars10 жыл бұрын

    life saver

  • @patelstudio4051
    @patelstudio40513 жыл бұрын

    Helpful 😉

  • @patelstudio4051

    @patelstudio4051

    3 жыл бұрын

    😉😉

  • @Ghostniggah
    @Ghostniggah10 жыл бұрын

    THANKS !

  • @jaix21
    @jaix219 жыл бұрын

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

  • @mduddin3425
    @mduddin342511 жыл бұрын

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

  • @ratuadil100
    @ratuadil10010 жыл бұрын

    Super east to follow and stays on track too.

  • @seaofclay
    @seaofclay11 жыл бұрын

    Cheers for the help mate, nice one!! X

  • @sababaratashvili8629
    @sababaratashvili86297 жыл бұрын

    Thanks for the video!

  • @tearful50
    @tearful5010 жыл бұрын

    select all of them by using ctrl or shift keys

  • @anishajain6403
    @anishajain64037 жыл бұрын

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

  • @ramizahajdarevic2060
    @ramizahajdarevic206010 жыл бұрын

    Help....when I put =sum( B1 andB5) it adds only B1 and B5 which means B2,B3 and B4 are not incl.

  • @mohammednasihb.m4542

    @mohammednasihb.m4542

    3 жыл бұрын

    Please drag down the selection

  • @doyourbst
    @doyourbst11 жыл бұрын

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

  • @hcherag-zade5553
    @hcherag-zade55536 жыл бұрын

    Brilliant, Thank you

  • @mainuddin8327
    @mainuddin83272 жыл бұрын

    👍👍👍👌👌

  • @LinaVera4
    @LinaVera410 жыл бұрын

    tHANKS SO MUCH great video

  • @whoisadrn4350
    @whoisadrn43503 жыл бұрын

    i’m taking a test. hurry up

  • @toastoneggs7356
    @toastoneggs73566 жыл бұрын

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

  • @w4yn6
    @w4yn610 жыл бұрын

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

  • @kevinjames753
    @kevinjames7538 жыл бұрын

    Good Job!

  • @fixhdfjfd3643
    @fixhdfjfd36434 жыл бұрын

    Any one here from online class

  • @jairuscyriltimbang8942
    @jairuscyriltimbang89429 ай бұрын

    😊

  • @xxylitx6996
    @xxylitx699610 жыл бұрын

    Thanks a lot !!

  • @vampiregoat69
    @vampiregoat692 жыл бұрын

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

  • @maprilganhao8117
    @maprilganhao81177 жыл бұрын

    I do like you say but my total is zeros

Келесі