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.
Let's talk a little bit about the Ribbon bar. If you've used older versions of Excel or other Windows programs, this looks a little new because you're probably used to drop-down menus and multiple rows of toolbars. If you use the 2007 version, this looks pretty familiar and the deal is you have about eight tabs going across here, and these are like tabs of a dialog box and you click any of these tabs, and it shows you all the different parts of the Ribbon. So there are no drop-down menus here in Excel 2010. The Home tab is the default tab and that contains all around things that you would need at just about any time.
Like dealing with the Clipboard, font formatting, alignment, dealing with formatting numbers and so on. The Insert tab is what you use to insert things. If you want to insert a picture, or a clipart, or a text box, or equations, that's what you do here. Page layout is how does your page look. Are you dealing in portrait oriented, or landscape oriented. You have page break, size of the page and so on. Formulas deals with your calculations. It might look a little intimidating if you're not familiar with this, but don't worry, we'll come back to this. The Data tab, some of this deal with connecting to external data, maybe a website, maybe a database, and on the right side here it deals with data analysis.
The Review tab is helpful if you need to collaborate with others on your work. Maybe passing comments back and forth. So if you need to work in a collaborative environment, you want to get familiar with the Review tab. The View tab, a lot of this is personal preference. How does your page look, do see the gridlines or do not see the gridlines. How far in or out are you zoomed, did you split the screen, all sorts of options. Let's get back to the Home tab here. You notice that the Ribbon bar is broken up into sections that are called groups. So we have the Clipboard group, the Font group and so on.
Now some of these like the Font group has this little launcher and if you rest your mouse pointer on it, it gives you a little bit of help. Not all groups have them, so for example, the Styles, Group, Cells, Editing, they don't have. Let's click the little arrow here at the launcher and the Font group, and you'll see that brings up the Font tab of the Format Cells dialog box. I'll just close this here. Click the launcher for the Alignment group and that brings up the Alignment tab on the same dialog box, so close that. Click the Launcher for the Number group and that brings up the Number tab of the same dialog box.
So a lot of these kind of lead to the same place, and by the way if you're familiar with the Format Cells dialog box from older versions, this hasn't changed in many, many versions. Close out of here. By the way, another way to get to that Format Cells dialog box is Ctrl+1, not F1, just the number 1, hold down Ctrl and press 1 and that will bring you into the Format Cells dialog box. I'll just cancel that. Now also you notice that we have a graphic on the screen, we have this image here. If you click that image, you see you get another little tab and you have a Picture Tools section and there's one tab underneath it.
There'll be other times when you have a section that has multiple tabs. Picture Tools has only one. Click Format. And you see this has everything to do with formatting that image. If you deselect it, click off it, you see that section goes away. Now there's another way that you could access the Ribbon bar and that is if you press the Alt key on your keyboard, you get these little letters showing these are mnemonics, so for example if you press P, that brings up the Page Layout tab. And if you press O, not zero, but the letter O, that brings up Orientation.
Now I'm just going to click over here to get rid of that. Now hit the Alt key one more time. If you've got these letters there, maybe you hit the Alt by accident, and you want to get rid of these, you can just hit the Escape key, some of you need to hit a couple of times, and that will get rid of those mnemonics. Now if you don't like Ribbon bar, I have some bad news for you. That all of the Office 2010 applications are using the Ribbon bar, but the good news is that once you learn how to deal with the Ribbon bar in Excel, it works pretty much the same way in all of the other Microsoft Office applications.
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.