جاوا اسکریپت غیر فعال است برای تجربه بهتر، قبل از ادامه، جاوا اسکریپت را در مرورگر خود فعال کنید.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
آموزش کامل Excel 2003 -EN
[h=2]Sorting Lists
[h=5]To Sort in Ascending or Descending Order:
Select Data from the main menu.
Select Sort . The Sort dialog box will appear.
Select the category you would like to Sort by .
Select Ascending to sort in alphabetical order from A to Z.
To sort in
reverse alphabetical order from Z to A, select
Descending .
[h=2]Sorting Lists
[h=5]To Sort Multiple Categories:
Select Data from the main menu.
Select Sort . The Sort dialog box will appear.
Select the category you would like to Sort by .
Select Ascending to sort in alphabetical order from A to Z.
In the Then by section, select the second category you would like to sort.
Click OK to sort in alphabetical order and by sales region.
[h=2]Sorting Lists
[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.
Sort the employee names in alphabetical order.
Sort by the Sales Region and then by Employee Name .
Continue to sort the different categories until you are comfortable with this feature.
Save and close the spreadsheet.
[h=2]Inserting, Viewing, and Editing Comments
[h=3]Introduction[h=4]By the end of this module, learners should be able to:
[h=2]Inserting, Viewing, and Editing Comments easily insert comments in a cell, as
[h=2]Inserting, Viewing, and Editing Comments
[h=5]To Insert a Comment:
Select the cell where you would like to add a comment.
Choose Insert
Comment from the main menu.
Enter your comment into the text box that appears next to the selected cell.
Click in any other cell. The comment box will disappear.
Notice the small, red triangle in the upper-right corner of the selected cell. This triangle indicates that there is a comment associated with the cell.
[h=2]Inserting, Viewing, and Editing Comments
[h=5]To Edit, Delete, Show, or Hide a Comment:
Right-click the cell with a comment.
Select Edit Comment , Delete Comment , or Show/Hide Comments from the menu.
To hide a comment after choosing to show it, simply right-click the cell, choose
Hide Comment from the menu.
[h=2]Inserting, Viewing, and Editing Comments
[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.
Add the following comment to the cell with Jane Smith's February sales information:
Record Month -- Sold 19 cars!
Add the following comment to the cell with Thomas Morrison's June sales information:
Lowest monthly sales -- out sick.
Delete the comment associated with Jane Smith's February sales record.Save and close the spreadsheet.
[h=2]Inserting Hyperlinks
[h=3]Introduction[h=4]By the end of this module, learners should be able to
[h=2]Inserting Hyperlinks hyperlinks into a spreadsheet to access specific websites from that
[h=2]Inserting Hyperlinks
[h=5]To Insert a Hyperlink to a Website:
Select the cell where you would like to insert the hyperlink.
Select Insert
Hyperlink from the main menu. The Insert Hyperlink dialog box will appear.
Enter the text you would like to appear as your link in the Enter text to display: field.
Enter the website address in the Address: field at the bottom of the dialog box.
Click OK . The hyperlink will appear in your spreadsheet.
[h=2]Inserting Hyperlinks
[h=3]Challenge!
Download and save the
Monthly Budget spreadsheet to complete this Challenge.
Open the Monthly Budget spreadsheet.
Insert a hyperlink to a website of your choice.
Save and close the spreadsheet.
[h=2]Grouping Worksheets
[h=3]Introduction[h=4]By the end of this module, learners should be able to
Format multiple worksheets at the same time
[h=2]Grouping Worksheets group the worksheets together.
[h=2]Grouping Worksheets
[h=5]To Group and Format Worksheets:
Click the first sheet tab you would like to format.
Press and hold the Shift key on your keyboard.
Click the last sheet tab you would like to format.
would click the 2005 tab, press and hold the Shift key, and then click the 2007 tab. Both sheet tabs you clicked, and any in between, will be highlighted.
Edit one of the worksheets.
Any changes you make to one sheet will appear in
all the highlighted sheets . For example, if you
delete a row in the first sheet, that row will no longer appear in any of the highlighted sheets.
[h=2]Grouping Worksheets
[h=3]Challenge!
If you have not already done so in a previous Challenge, download and save the
Monthly Budget spreadsheet.
Open the Monthly Budget spreadsheet.
Group the three sheet tabs.
Add a column to the right of July .
Type August in the column heading.
Save and close the spreadsheet.
[h=2]Applying and Modifying Cell Formats
[h=3]Introduction[h=4]By the end of this module, learners should be able to:
Format cell styles using the Format Cells dialog box.
Format numbers, alignment, font, border, and patterns in a spreadsheet.
[h=2]Applying and Modifying Cell Formats appearance of your spreadsheet to make it more visually appealing. Excel cell formatting .
[h=2]Applying and Modifying Cell Formats
[h=5]To Apply and Modify Cell Formats:
Use your mouse to select the cells you want to modify.
Select Format
Cells from the main menu. The Format Cells dialog box will appear.
Decide how you want to format the cells.
Select the tabs that allow you to make the desired changes.
Use the Format Cells drop-down menus and tools to make the desired changes.
[h=2]Applying and Modifying Cell Formats
In the Format Cells Dialog Box You Can Change:
To sort in reverse alphabetical order from Z to A, select Descending.
