Friday 20 July 2012

14: Using Templates in Excel

In Excel 2007, you have many templates that can save you a lot of time. A templateis a pre-designed spreadsheet that you can use to create new spreadsheets with the same formatting and predefined formulas. With templates, you don't need to know how to do the math, or even how to write formulas -- these are already integrated into the spreadsheet. 

In this lesson, you will learn how to create a new workbook with a template, as well as basic information about how templates work in Excel 2007.







To Create New Workbooks Using Templates On Your Computer:
  • Open Excel.
  • Click the Microsoft Office Button.
  • Select New. The New Workbook Dialog Box appears.
New Workbook Dialog Box

  • Click Installed Templates. Thumbnail images of the templates that are installed on your computer appear in the center of the dialog box.
Installed Templates

  • Select a template from the center area of the dialog box. A slightly larger image of the template appears on the right side of the dialog box.
  • Click Create. The template will appear in the Excel window.

To Create New Workbooks Using Templates on Office Online:
  • Open Excel.
  • Click Microsoft Office Button.
  • Select New. The New Workbook Dialog Box appears.
  • Select a category under the Microsoft Office Online heading on the left. Thumbnail images of the templates in that category that are available through Microsoft Office Online appear in the center of the dialog box.
Online Templates

  • Select a template. A slightly larger image of the template appears on the right side of the dialog box.
  • Click Download. The download process will begin.


No comments:

Post a Comment