Video: Using Backstage view or the File tab

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.

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.

Using Backstage view or the File tab

When it comes time to manage your file,saving, opening, and closing, Excel 2010 just like all of the other 2010applications 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 whenyou go back to Backstage View and click this Recent section, you see it's uphere 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 filesthat 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 outof 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 openit 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 wecan 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 righthere 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 awebsite, 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 linehere showing us a page break.

So what's really nice about Backstage View is all of the Office 2010programs have them.If you go into Word or PowerPoint or Access, you'll have the Backstage View andyou'll know immediately how to use it.I think that's a really great addition to this version.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Already a member ?

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships.
Learn more

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about lynda.com and our online training library:

new course releases

newsletter

general communications

special notices

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

new course releases

newsletter

general communications

special notices

Here’s our privacy policy with more details about how we handle your information.