Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

Practice the Concept: Let’s do another template search. Type work schedule into the Search for box and press Enter to start searching the Microsoft Office templates site. Select the Employee shift schedule template from the Search Results pane. Select Create to download and open the template. When the download is complete, a new workbook opens displaying the Employee shift schedule template. Close the document after viewing the new workbook without saving.

O PENING AN E XISTING W ORKBOOK  D ISCUSSION

You can view or edit an existing workbook by opening it from its storage location. You likely do not need to remember the file name because the Open screen displays a list of files you’ve worked in recently. Select the desired workbook from the list, or type the name of the workbook you want to open.

If the workbook is not in the list or resides in a different drive or folder, use the This PC option or Browse option to locate the file you want. The This PC option displays a list of folders in the default folder and Browse displays the familiar Open dialog box. When you use the This PC option, you can browse to the folders and files like in the Open screen. The current folder or the default folder appear at the top of the screen and the files and folders appear below. Click the arrow beside the folder at the top to navigate up to the higher level folders.

Open screen with This PC

The Open dialog box has a few changes that carry through to the other Office 2016 applications. The left side of the screen displays Quick Access options that include your most used folders as well as some system folders that always appear in the Quick Access list. As you scroll down, some of the same folders appear as well as network drives and cloud drives. Navigate to the

Page 60

OFFICEPRO, Inc.