Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
Now if you have completed the exercise in the movie about using the AutoSum function in the AutoSum tool, you will have a worksheet that looks pretty much like this. Well, any numbers manually using the cherry pick method is okay. Using the AutoSum tool and Auto Fill are even better but, when you have a worksheet like this that's compact, you don't have any blank columns, you don't have any blank rows, you can add up the numbers very, very quickly. You don't have to write even a single formula. So let's select all the numbers going down that column and press Delete.
Let's select the numbers going across the Total row and press Delete. So again, you have just your data and their totals. Here's what you want to do. Let's select cells starting from the very first number, select down and across. So you have not only all of your input data selected but your Total column is the last column selected and your Total row is the last row selected and all you have to do is click the AutoSum tool and you are done.
You don't have to Auto Fill, you don't have to check answers, it is done. Pretty cool, huh? Let me show one other slightly different way to do that. I am just going to press Ctrl+Z to undo. When you have that area selected, you can press Alt+Equals. Hold down the Alt key and press Equals. That's the shortcut for the AutoSum tool and if you take a look here, I am just going to press Ctrl+Tilde and now you can see that Excel has written the formulas correctly going down that column, and it's written the formulas correctly going across this row.
And I will press Ctrl+Tilde to come back. So when you have a compact worksheet like this, use that feature and you could get yourself done and in no time at all.
There are currently no FAQs about Excel 2010 Essential Training.
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.