Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
Creating a formula in Excel takes just a few seconds, but there might be times when you want to find the sum or average of a series of numbers without saving that result in your worksheet. If that's the case, you can select a group of cells and have Excel display a summary operation on the status bar at the bottom of the workbook window. When you click one more cells, Excel displays a summary calculation on the status bar. The status bar is here on the bottom edge of the program window, and right now it says, Sum = 0. That's because the active cell has no value in it.
If I were to click to cell directly above it, cell C17, you see that the sum has changed, and that it is now 203,654. If I select two cells, it updates the sum to be the total of those two cells. So, for example, if I wanted to find the sum of all the cells from C2 through C17, I could just select them. And if I only wanted to know the value and didn't need it in the formula, I can look here on the status bar and see that it's 8.9 million.
Basically, any way that you select a group of cells, you can use that to update the total on the status bar. So let's say that I wanted to find the total of revenue for 2006 and 2008. To do that, I can select cells C2 through C5, which represent 2006, and then hold down the Command key and select C10 through C13. When I do, you see that Excel has updated the total, and that's just over 4 million. So clear that. You're not limited to finding a sum, though; there are other calculations that you can use.
So, for example, let's go back and select all these values here, C2 through C17, and then click the status bar's arrow. When I click that, you'll see that there's a list of calculations that you can use: Average, Count, Count Num, Max, Min, and Sum. If you want, you can change it to Average, and Excel updates the Average to 561,000 and change. If you want no summary there, you can click the arrow and click None.
Summarizing the contents of the few cells on the status bar helps you answer questions about your data without going to the trouble of creating a formula. It's a great way to perform quick summaries without altering your workbook or disrupting your workflow too much.
Find answers to the most frequently asked questions about Excel for Mac 2011 Essential Training.
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.