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

A

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

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

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

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

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

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.


​
 
برای ارسال پاسخ شما باید وارد سیستم شوید.
بالا