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.
When it comes time to manage your file, saving, opening, and closing, Excel 2010 just like all of the other 2010 applications has one place where you can do it all, and that's Backstage View. Click the File tab and that brings in a Backstage View. Now let's talk about what's going on here. Some things are typical. Saving, opening, and closing. I'll just go on and open a file. Let's open up this file here called backstage view. It doesn't really matter what's on there. Here is something that's pretty cool. Let's close Backstage View.
Now, you can just click this little X here or you can press Ctrl+F, but when you go back to Backstage View and click this Recent section, you see it's up here as a recently opened file. You can just click it, and it comes up. Well, that's probably not a big deal, but here is what's kind of neat. Let's go back here to Recent, is that Excel will remember the last 50 files that you had opened. Over here, it will remember Recent Places where you work. But wait, there is more. What if this backstage view file is a file that you need to get to very often? We see this little pushpin.
If you click that pushpin, and now you notice it's blue and it's pushed in, it means that Excel is going to retain it and it's always going to be in that position. Now if you hit the Escape key on your keyboard, that kind of brings you out of Backstage View and back to the Home tab or really whatever tab you were in recently. Now again, if we close it, go back here, and you see it's there and we can open it as many times as we want. Let's go back here to Recent. When you have any of these pushpins pushed in, they will always stay at the top.
So the pushed in files will always be at the top of the list above any of these. Let's take a look at some of the other things here. If you click Info, here is all the information about this particular file. You have various properties here and you can assign permissions. We're going to come and deal with this in more detail in a later movie. Let's go to the New section and then in the New section, this is how we can create new files. We have templates, and we can create blank files. We'll also look at this in some detail later. Printing, it's right here.
This is a new Print dialog box in this version. Everything you'd need to know about printing, anything you'd need to do, is right here in this window. You notice Print Preview is over here. So this is sort of a unified dialog box. Of course, you can always press Ctrl+P to get to Print. If you go to Save & Send, this is all about collaboration. If you want to send your file to someone, if you want to save it up on a website, save it under a SharePoint portal, if you have access to it. You can change your File Type to many different file types here.
See all sorts of different options available. You can also create an Adobe Acrobat PDF directly from within Excel. We're going to come and look at all of this in more detail later. If you need help, you can click Help and get into the Help system. If you go down here to Options, this is how you can set all of the options for Excel. You see on the left side, this is broken into different categories. I'm just going to cancel out here. Notice because we went into the Print dialog box, we now have this dotted line here showing us a page break.
So what's really nice about Backstage View is all of the Office 2010 programs have them. If you go into Word or PowerPoint or Access, you'll have the Backstage View and you'll know immediately how to use it. I think that's a really great addition to this version.
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.