Join Bob Flisser for an in-depth discussion in this video Using Backstage view or the File tab, part of Excel 2010 Essential Training.
- View Offline
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.
- Copying and pasting techniques
- Working with formulas and functions
- Dealing with formula errors
- Creating lookup tables
- Naming cell ranges
- Formatting data and worksheets
- Finding and replacing data
- Creating SmartArt diagrams
- Creating charts and PivotTables
- Recording macros
- Sharing workbooks