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

[@karac.4744]

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

[@alikashmar7216]

heheh yeah true, that's what happens to me

[@makeupbyife]

While i am taking this in ever so deeply

[@marcangeloamaya630]

Motion Training surely does!

[@krzwis5632]

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

[@naturallytuli8536]

caught...thats me!

[@erinjames5611]

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]

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]

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!

[@cheytul]

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

[@Denise0236]

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

[@cristinavalle5266]

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

[@TheRedSoxFanChip]

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

[@TheAntonellav]

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.

[@msdeedaartist6385]

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

[@ANDREWEBSTER]

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

[@bsaman1]

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!

[@Ebi.Adonkie]

What a teacher! You're amazing dear Sir

[@ivoandonov3058]

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

[@xxgogsxx]

Your videos are extremely helpful. Thanks for posting!

[@natalienyampruh3088]

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

[@JeremyUM]

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!

[@carwen40]

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

[@Sushimushi__]

Really helped thanks!

[@theoverachiever34]

These tutorials are so helpful...Thank you

[@vangelova7443]

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

[@Jackyshadow]

Really useful and easy to follow videos. Thanks heaps!

[@gord2358]

Never knew something so simple could be made so complicated.

[@mgsoeng1506]

Thanks for different ways presented. Appreciate it sir .

[@Richdude1983]

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

[@zl99prototype30]

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

[@chuang5062]

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?

[@abetes5422]

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!

[@oredata2k]

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

[@moodchangetv8878]

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

[@franzdaboi3131]

this helped me on my assignment! thanks!

[@hadizarbafi8910]

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]

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

[@shakyjake64]

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?

[@briansibusisomahlangu]

Your video was extremely helpful... Thank you

[@d8p399]

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

[@Finch659]

This has been EXCELlent

[@Schleck71]

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

[@maxammedcabdi8885]

Amazing! this is excellent tutorial videos

[@AsadHanifSJ]

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

[@TheKosssss]

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

[@emperatriz.v.s.1702]

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

[@harishn1769]

thank you bro i have learnt a lot from this video

[@stupidcowwss]

Mine keeps saying 0 whenever i calculate?

[@mduddin3425]

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

[@sqdxb]

Great job....thank you sir

[@Karkure]

It is a big help full your video

[@birungijustine2717]

Wow! Thank you. You have real save me.

[@ratuadil100]

Super east to follow and stays on track too.

[@JorgChoco]

you are a good teacher

[@james02Perry]

Very cool tips. U r a genius!

[@1000frolly]

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?

[@sophiebettyclark]

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

[@doyourbst]

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

[@dinoyebrahimsalih4342]

Wow works quite well

[@fixhdfjfd3643]

Any one here from online class

[@vallerieanyona3944]

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

[@jaix21]

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

[@janielremitar11]

Thank you very much sir.

[@rcx8777c]

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

[@seaofclay]

Cheers for the help mate, nice one!! X

[@popoetic]

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.

[@mmakho7708]

thank you very much. Love it

[@angelathornton7279]

Very helpful thank you

[@devinparker6230]

This is awesome!!!!

[@ramizahajdarevic2060]

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

[@mohammednasihb.m4542]

Please drag down the selection

[@GHiNMOTO]

Fantastic

[@expiredid82929]

good one. keep it up :)

[@chocolatetye797]

Thank you so much

[@joesanmiguel678]

this helped me out so much, very helpful

[@tempestgaming9840]

Love from India

[@janielremitar11]

Yes!!! I got it.

[@Tejtd]

thanks man!!

[@patelstudio4051]

Helpful 😉

[@patelstudio4051]

😉😉

[@sababaratashvili8629]

Thanks for the video!

[@sonu1patel]

Hi do you have the data file I can download

[@quintoflyer]

very good

[@anishajain6403]

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

[@tearful50]

select all of them by using ctrl or shift keys

[@whoisadrn4350]

i’m taking a test. hurry up

[@LinaVera4]

tHANKS SO MUCH great video

[@shioribushin]

Thank you so much :D

[@hcherag-zade5553]

Brilliant, Thank you

[@mohdrehan7886]

Wonderful.

[@kevinjames753]

Good Job!

[@Thanhdung73]

Thankyou sir.

[@vampiregoat69]

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

[@toastoneggs7356]

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

[@mx.louweaver2772]

BLESS U

[@w4yn6]

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

[@1aligsbsu]

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?

[@buggiebars]

life saver

[@anishajain6403]

Sorry, I realized that I was typing alphabets with numbers. Sorry

[@crystalthompson9828]

Thank youuuuuu

[@xxylitx6996]

Thanks a lot !!

[@24husemag]

too bad there is only like button on KZbin no Love it button

[@maprilganhao8117]

I do like you say but my total is zeros

[@tusharwaghmare7062]

nice

[@tarikulislam6144]

thanks

[@mainuddin8327]

👍👍👍👌👌

[@b3astboy371]

Meh Dads Forcing MEh to Learn this