Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
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.
There are currently no FAQs about Excel 2013 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.