Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
The Status Bar located below the sheet tabs, at the bottom of the screen, often contains the word "Ready" in the lower left-hand corner. If you're entering a data you'll see the word Enter there, but many, many other indicators can appear in the Status Bar. Off to the right, you will see three buttons for different kinds of use, Normal, Page Layout, and Page Break Preview. To the right of that, you'll see a Zoom Slider Bar. We might want to zoom in on this worksheet to see the data large and clear that way, or may want to zoom back and see more data, although not nearly as large.
As we do different things using Excel, other indicators might pop-up as well. I might be typing and might want to use the Caps Lock Key and I'll click it, or maybe I did that by mistake. In the lower left-hand corner, we see the term "Caps Lock". As you select the data, now, I might be interested in the revenue, the total revenue here and by clicking Column I, suddenly quite a few numbers appear at the bottom of the screen. I know immediately the total revenue here for 2012 is over $22 million and it's showing me the maximum, the minimum, account of how many entries, and the average and quite a few bits of information that I'm really interested in.
If you highlight two or more cells in Excel, you will see at the bottom of the screen some of these indicators. Although possibly, you could have turned them off. If you click with the right mouse button anywhere in the Status Bar, you will see a rather large selection of check boxes with a number of features here. You want to explore these from time to time. If you want to be notified, if you accidentally clicked the Num Lock Key, then turn that check box on. The numbers that I just referred to at the bottom of the screen here are in this section right here--do you find these valuable? You might leave them all checked and then over time say, "you know, I don't use Count very much, I don't need that".
We won't see them at the bottom of the screen as we highlight data. I'd say leave them on for awhile and then come back and explore this every so often. Think about how handy it is when you're looking in a large list here. If you know your data well enough, if there's nothing else in the column. How many items did we sell this year? We'll click column H, and we sold -- and it's kind of hard to read without commas, but how many items did we sell? 389,000 items, so it's a handy feature. The Status Bar gives us a lot of good information, and from time to time, do right-click on it and consider which of these options, which of these indicators you do want to have active.
Get unlimited access to all courses for just $25/month.Become a member
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.
Your file was successfully uploaded.