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
You are saving all those people who lied on their resume about being competent in Excel! Thank you, Motion Training!
@alikashmar7216
8 жыл бұрын
heheh yeah true, that's what happens to me
@makeupbyife
7 жыл бұрын
While i am taking this in ever so deeply
@marcangeloamaya630
7 жыл бұрын
Motion Training surely does!
@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
5 жыл бұрын
caught...thats me!
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!
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!
These videos are life saving..thank you so much for explaining everything in detail.
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.
What a teacher! You're amazing dear Sir
Thank you for posting these tutorials! They've helped me so much!
These video's are very helpful and they are helping me to appreciate Excel more. Thank you!
I just wanted to say thank you.You have made my job so much easier .
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!
Thank you for these tutorials, they are a big help to a newb like me!
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!
Never knew something so simple could be made so complicated.
Your videos are extremely helpful. Thanks for posting!
These tutorials are so helpful...Thank you
I am SOOOOOOO excited about this!! Thank you so much!!! This is helping me!!!
Thanks for different ways presented. Appreciate it sir .
Great teacher!! Really easy to understand and great pointers for people like me who has a beginnning to intermediate background with Excel
Thank you very much for these tutorials, they are very interesting and your explanation is very good , thank you alot
Really helped thanks!
Thanks for the great tutorial. I have learn t a whole lot!
who's here in 2021 and loving it? I am
Thank You! This is indeed helpful. Just grateful!!
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!
I loved the video it was easy to understand and very thorough. I will come back to view more tutorials.
This is very good. Thank you for both the time and effort.
Love it !!! Great tutorials, congrats !!!! :)
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?
this helps for my studies!!!! thank you!!!!!!
Thank you! It's a big help for my work. :)
Bang on, the best tutorial see so far... keep up the good work
This has been EXCELlent
this helped me on my assignment! thanks!
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
Wow! Thank you. You have real save me.
Amazing! this is excellent tutorial videos
thank you very much. Love it
Great job....thank you sir
This is awesome!!!!
Very cool tips. U r a genius!
Wow works quite well
Really useful and easy to follow videos. Thanks heaps!
Your video was extremely helpful... Thank you
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!
Thank you very much sir.
thank you bro i have learnt a lot from this video
Very helpful thank you
It is a big help full your video
Thank you so much
thanks man!!
you are a good teacher
Yes!!! I got it.
thank you so much!
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?
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 .....
BLESS U
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.
Mine keeps saying 0 whenever i calculate?
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
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.
very good
Thank you so much for your clear and amazing explanation! It does make Excel interesting!!! Thank you!
you need to put a colon between the 2 so it should be =sum(B1:B5) and make sure all the cells are selected
Thank you so much :D
Wonderful.
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?
Fantastic
Love from India
Thank youuuuuu
Thankyou sir.
I LOVE EXCEL IT IS SO EASY TO USE. THE KEY IS USING THE CELL ADDRESS AND NOT THE CELL VALUE.
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 :)))))
Hi do you have the data file I can download
this helped me out so much, very helpful
thanks
nice
good one. keep it up :)
life saver
Helpful 😉
@patelstudio4051
3 жыл бұрын
😉😉
THANKS !
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! :)
your great mate helped me a lot. by far the best tutorial
Super east to follow and stays on track too.
Cheers for the help mate, nice one!! X
Thanks for the video!
select all of them by using ctrl or shift keys
When I press enter after typing the formula it shows 0. Please help sir.
Help....when I put =sum( B1 andB5) it adds only B1 and B5 which means B2,B3 and B4 are not incl.
@mohammednasihb.m4542
3 жыл бұрын
Please drag down the selection
Great job in teaching this! I am a teacher you are great!
Brilliant, Thank you
👍👍👍👌👌
tHANKS SO MUCH great video
i’m taking a test. hurry up
WHY AM I ADDICTED TO THESE VIDEOS HOW???b!
what can I say? you have great taste in movies..
Good Job!
Any one here from online class
😊
Thanks a lot !!
in 2021 I don't have that autosum button at all
I do like you say but my total is zeros