Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
One of Excel's best calculation tools and used in lots of formulas is the AutoSum capability. It's on the Formulas tab in the Function Library here on the left side also on the Home tab, in the Editing group on the right side AutoSum. Has little drop arrow associated with it for other related functions as well. Let's use it in its most basic form. We are in cell G2 for example we want some totals. AutoSum is designed to quickly add totals from above or from the left.
It is context sensitive. The standard way to use this would be to put the active cell here and click AutoSum, and we view what's going on and if we are relatively new with functions and formulas in Excel we might look at that for a bit and also make figure it out and say oh yeah that looks good and what do we do next? Many people press Enter and that's fine. We could also press AutoSum a second time and of course that raises the idea this could be a little bit faster couldn't it? Next time we will need this in a situation why not double-click on Autosum? Makes it a bit faster. Another way to do this too by the way is a keystroke shortcut.
Now you might say well I am using the mouse to get here. Well maybe I have used the keystrokes so the keyboard to get here. Alt+Equal, and you have to press Enter there though to complete it. So here and there, that's going to be useful as well. We might want to use AutoSum here. Another approach to AutoSum is to highlight the data first. If it's highlighted in a column like this then we can either press Alt+Equal or AutoSum once, and the total goes below it. There you go, fast and easy.
Let me do that with Alt+Equal, highlight this data, Alt+Equal and then although no better, but sometimes we do this possibly by mistake, but by design if we highlight data this way and press Alt +Equal or the AutoSum button once, we get an answer there too. Be open to the idea that sometimes rather than putting AutoSum in once and then copying it, suppose we want totals on the right-hand side of the data here down in rows 12, 13 etc.
Right here highlight the data, click AutoSum once we got our totals. What if we wanted totals in the bottom? We could have highlighted these and press AutoSum once, or as I press Ctrl+Z twice to undo these. Why not take care of both sets of totals at the same time? Highlight the data this way to include the empty cells on the right in column H and the empty cells below this in row 16, then click AutoSum once. Works just fine. If instead of totals here, if we wanted averages, we would have highlighted the data here.
Click the drop arrow use Average, we get averages on the perimeter, and obviously we need to do some formatting there. The comma button would be a quick fix possibly. But it's easy to use AutoSum, and its related drop arrow capabilities, a good quick way to take care of lots of formulas in Excel.
Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.