Page 190 - Excel 2007 Bible

13_044039 ch09.qxp 11/21/06 12:23 PM Page 147
Using and Creating Templates
Figure 9.2 shows a workbook that’s based on an invoice template.
It’s important to understand that you’re not working with the template file. Rather, you’re
NOTE
NOTE
working with a workbook that was created from the template file. If you make any changes,
you’re not changing the template — you’re changing the workbook that’s based on the template. After you
download a template from Microsoft Office Online, that template is available in the My Templates category
in the New Workbook dialog box, so you don’t need to redownload it if you want to re-use the template.
This particular workbook has a few simple formulas that perform calculations using the data that you enter.
Figure 9.3 shows the workbook after you enter data. Notice that formulas calculate the subtotal, sales tax,
and total.
FIGURE 9.2
A workbook created from an invoice template downloaded from Microsoft Office Online.

If you want to save the workbook, click the Save button. Excel proposes a named based on the template’s 9
name, but you can use any name you like.

147