Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

U SING A T EMPLATE  D ISCUSSION

Excel provides several professionally-designed templates that you can use to create new workbooks. Templates save you time by providing layouts for common spreadsheet tasks. The templates provided on your computer when you install Excel 2016 include a Sales Invoice, Expense Report, Sales Report, Personal Monthly Budget and even a Wedding Budget!

By using templates, you can simply enter your data and instantly see results such as totals, averages and so on. When you save a workbook created from a template, the template remains intact, available to use again and again.

The New screen lists the templates installed on your computer, together with any templates you have created. If you are connected to the Internet, it also lists a wide variety of additional templates that you can download from Microsoft Office Online. You can download and install these additional templates direct from the New screen.

Use a template

NOTE When you use a template to create a new workbook, Excel downloads it to your computer and adds it to the Recent section in the New screen. You must have the rights to install new programs on your computer to be able to download new templates.

Page 58

OFFICEPRO, Inc.