Hour 6. Using Excel Templates


Hour 6. Using Excel Templates

The highlights of this hour are as follows :

  • What a template can do for you

  • How to open an Excel template

  • How to change an Excel template

  • How to create your own template

  • How to save a worksheet as a template

Excel offers a collection of templates to use in creating a workbook. Templates enable you to create a workbook based on the special text and formatting elements the templates provide. You could create these elements yourself, but the job would take some time.

Some examples of what you can use a template for include an invoice, purchase order, balance sheet, expense statement, time card, or loan amortization spreadsheet.

During this hour, you discover that creating a workbook using an Excel built-in template is easier than you think. Using a ready-made design gives you a running start on creating a professional-looking workbook. You also learn how to change the template, create your own template, and save an existing worksheet as a template.



Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours
Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours (Sams Teach Yourself in 24 Hours)
ISBN: 1435276337
EAN: 2147483647
Year: 2003
Pages: 279
Authors: Trudi Reisner

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net