آموزش کامل Excel 2003 -EN

[A M I R]

[h=2]Applying and Modifying Cell Formats

[h=3]Challenge!



If you have not already done so in a previous Challenge, download and save the Employee Sales spreadsheet.

• Open the Employee Sales spreadsheet.

• Modify the font to be Verdana.

• Change the font size to 14.

• Make the column headings blue.

• Continue to format the cells until you are comfortable using the Number, Alignment, Font, Border, and Patterns tabs in the Format Cells dialog box.

• Save and close the spreadsheet.

​

 

[A M I R]

[h=2]Creating New Workbooks from Templates

[h=3]Introduction[h=4]By the end of this module, learners should be able to:

• View available templates

• Create a new workbook from a template

​

 

[A M I R]

[h=2]Creating New Workbooks from Templates

[h=3]Creating New Workbooks Using Templates





Excel allows your to create new workbooks using templates, or a predefined pattern. Several

templates are preloaded in Excel and others are located on Microsoft Office Online.

​

 

[A M I R]

[h=2]Creating New Workbooks from Templates

[h=5]To Create New Workbooks Using Templates On Your Computer:

• Open Excel.

• Select New from the menu. The New Workbook dialog box will appear.

• File
  
  New from the main menu. The New Workbook task pane will appear.

• Click On my computer... in the Templates section of the New Workbook task pane. The Templates dialog box will appear.

• Select the Spreadsheet Solutions tab.

• Select the template you wish to use.

• Click OK.

​

 

[A M I R]

[h=2]Creating New Workbooks from Templates

[h=5]To Create New Workbooks Using Templates on Office Online:

• Open Excel.

• Select File
  
  New from the main menu. The New Workbook task pane will appear.

• Click Templates on Office Online in the Templates section of the New Workbook task pane. Office Online will open in a new browser window.

• Browse the template categories and click the link of the category you wish to view.

• Click a template link.

• Click Download Now to download the template.

​

 

[A M I R]

[h=2]Creating New Workbooks from Templates

[h=3]Challenge!

• Open Excel.

• Select File
  
  New from the main menu.

• View the templates on your computer.

• Click Templates on Office Online.

• View several of the template categories on Office Online.

• Select a template.

• Download the template.

• Enter your data into the template.

• Save and close Excel.

​