Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/

During this Microsoft Excel 2016 advanced training tutorial video, we will demonstrate the Autosum function and look at the aspects that can make it a very quick and efficient way of dealing with straightforward requirements.

Check out some of our other training on YouTube:

Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hzyKexLt4YW-AaIUPeiCen

Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hello again and welcome back to our course on Excel 2016 Advanced.

We’ve been looking at Functions for the last couple of sections and in this section I’d like to look at the AutoSum Functions which you’ve probably used before but you may not be aware of some aspects of their use that can make them a very quick and efficient way of dealing with straightforward requirements.

Let me show you the sort of thing that I mean. Let’s suppose that I wanted to add the numbers there in column B. Now you might be tempted to select the numbers in column B and then insert the AutoSum function as part of the formula in B6. But in fact you don’t need to select the numbers first. If you just click below the column of numbers and then go up to the Ribbon, either the Home tab or the Formulas tab, both of them have an AutoSum button on them. I’m on the Home tab, click on AutoSum and a formula is placed in B6. And what Excel 2016 has done is to work out what it believes is the range of numbers that I’m trying to sum. If I’m happy with that all I need to do is to click on Enter and there is my total.

Now of course if instead of doing that I selected those four cells first, note that I haven’t selected B6 in this case and clicked on AutoSum. That still gives me the same result. Let me Undo that. Note that if I select B2 right down to B6, click on AutoSum it achieves the same effect as well. And once again let me Undo that. And another point to bear in mind is if I select say B2 to B5 the Quick Analysis tool also has a Totals tab. And if I wanted to put the sum in using that rather than the AutoSum button I get the same result and of course the formula is exactly the same as well.

Now let me Undo that and this time what I’m going to do is to select the sales from B6 to C6 and click on AutoSum. And in this case of course it can sum both of those columns. It puts the formula in B6 for column B and the equivalent formula in C6 for column C.
Now of course this doesn’t only work for columns. If I wanted to deal with rows, let me click in G2. Click on AutoSum and I get the sum from B2 to F2. So it works on rows as well.

Let me just cancel that and delete the contents of cell F5. What would happen if I clicked the AutoSum button while cell F5 is selected? And the answer is it gives the sum from F2 to F4. Where AutoSum has an option of dealing with a column or a row it always gives precedence to columns. So that’s an important point to remember as well.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.