Welcome to our free Introduction to Microsoft Excel tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2019 Training course.
In this lesson, you will learn about the Backstage View in Microsoft Excel.
The Ribbon, covered in the prior lesson, is where you find all the commands necessary to make changes to your worksheets. Clicking on the tabs in the Ribbon changes the set of commands available to you while you work in your worksheet. After clicking on the File menu, you can no longer see your worksheet or the Ribbon. Instead, you see what Microsoft calls the Backstage view. This is where you:
Many of the features of the Backstage view are covered in our intermediate and advanced Microsoft Excel classes. Only those that are essential to working with Microsoft Excel are covered in this class.
There are two ways to open a Microsoft Excel workbook from the Backstage view:
To modify document properties in an Excel workbook, select the File menu tab, and from the Info section, under Properties, type in the text boxes to add document properties.
In this exercise, you will practice opening Microsoft Excel workbooks from the File menu.
When creating a new Microsoft Excel workbook, you can choose between creating a blank workbook or creating your workbook from an existing template.
To create a new blank workbook:
A template is a predesigned Excel workbook that you can then change to suit your needs. When you create a new workbook from a template, you are creating a copy of the original template.
To create a new workbook from a template:
You can modify an Excel template:
If you are using Excel 2010, you will follow step 1, and then double click a template category, select a template to view it, and select Download to download it.
Once you've downloaded a template, it is stored in the My Templates location on your computer.
In this exercise, you will create a new workbook using a Microsoft template.
The Print window gives you access to several printing and page layout options. You will also see a preview of how your worksheet will print.
To print a Microsoft Excel worksheet:
In this exercise, you will print the agenda you created in the last exercise. You will need to have a printer connected to successfully complete this exercise.
You can personalize your copy of Microsoft Excel by adding your name. When you do so, the information is used throughout the Microsoft Office products. Excel uses this information for tracking changes and assigning comments and for prefilling data used by some of the built-in templates.
To add your name and initials to Microsoft Excel:
You can customize how Excel looks (and your other Office programs) by adding a theme. To access themes, from the File menu, select Options. Then select options from the Office Theme drop-down list. You can choose from the options available in the following screenshot: