Excel 2010 Bible

Part I: Getting Started with Excel

162

FIGURE 8.1

The New page in Backstage View displays template categories.

Note
Microsoft Office Online has a wide variety of templates, and some are better than others. If you download a
few duds, don’t give up. Even though a template may not be perfect, you can often modify a template to meet
your needs. Modifying an existing template is often easier than creating a workbook from scratch. n

Creating a workbook from a template .....................................................................

To create a workbook based on a template, just locate the template and click the Create button on

the right. If the template is on Microsoft Office Online, the Create button is replaced with a

Download button.

What you do next depends on the template. Every template is different, but most are self-

explanatory. Some workbooks require customization. Just replace the generic information with

your own information.

Figure 8.2 shows a workbook based on an invoice template. This particular workbook has a few

simple formulas that perform calculations using the data that you enter. Figure 8.3 shows the

workbook after it has been customized a bit, and some items added. Notice that formulas calculate

the subtotal, sales tax, and total.