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

[A M I R]

[h=2]******ing Data

[h=4]To Clear a ******:

Click the drop-down arrow in the column from which you want to clear the ******.


Choose Clear ****** From...

The ****** will be cleared from the column. The data that was previously hidden will be on display once again.


To instantly clear all ******s from your worksheet, click the ****** command on the Data tab.




​

 

[A M I R]

******ing Data

Advanced ******ing

To ****** Using Search:



Searching for data is a convenient alternative to checking or unchecking data from the list. You

can search for data that contains an exact phrase, number, or date, or a simple fragment. For

example, searching for the exact phrase "Saris X-10 Laptop"will display only Saris X-10 Laptops. Searching

for the word "Saris," however, will display Saris X-10 Laptops, and any other Saris equipment, including

projectors, digital cameras, and more.

From the Data tab, click the ****** command.

Click the drop-down arrow in the column you would like to ******. In this example, we will ****** the Equipment Detail column to view only a specific brand.

Enter the data you would like to view in the Search box. We will enter the word "Saris" to find

all Saris brand equipment. The search results will appear automatically.

Check the boxes next to the data you want to display. We will display all the data that includes the brand name Saris.

Click OK. The worksheet will be ******ed according to your search term.

​

 

[A M I R]

[h=2]******ing Data

[h=4]To Use Advanced Text ******s:

Advanced text ******s can be used to display more specific information, such as cells that contain a

certain number of characters, or data that does not contain a word you specify. In this example, we

will use advanced text ******s to hide any equipment that is related to cameras, including digital cameras, camcorders, and more.




From the Data tab, click the ****** command.

Click the drop-down arrow in the column of text that you would like to ******. In this example, we will ****** the Equipment Detail column to view only certain kinds of equipment.

Choose Text ******s to open the advanced ******ing menu.

Choose a ******. In this example, we will choose Does Not Contain to view data that does not contain the text we specify.

The Custom Auto****** dialog box appears
.
Enter your text to the right of your ******. In this example, we will enter "cam" to view data that does not contain

those letters. That will exclude any equipment related to cameras, such as digital cameras, camcorders, camera bags, and the digicam printer.

1. Click OK. The data will be ******ed according to the ****** you chose and the text you specified.

 

[A M I R]

[h=2]******ing Data

[h=4]To Use Advanced Date ******s:
Advanced date ******s can be used to view information from a certain time period, such as last year, next

quarter, between two dates, and more. Excel automatically knows your current date and time, making this

tool very easy to use. In this example, we will use advanced date ******s to view only the equipment that has been checked out this week.




From the Data tab, click the ****** command.

Click the drop-down arrow in the column of dates that you would like to ******. In this example, we will ****** the Checked Out column to view only a certain range of dates.

Choose Date ******s to open the advanced ******ing menu.

Click a ******. We will choose This Week to view equipment that has been checked out this week.

The worksheet will be ******ed according to the date ****** you chose.

​

 

[A M I R]

[h=2]******ing Data

[h=4]To Use Advanced Number ******s:

Advanced number ******s allow you to manipulate numbered data in many different ways. For example, in a

worksheet of exam grades, you could display the top and bottom numbers to view the highest and lowest

scores. In this example, we will display only certain kinds of equipment based on the range of ID #s that have been assigned to them.





From the Data tab, click the ****** command.

Click the drop-down arrow in the column of numbers that you would like to ******. In this example, we will ****** the ID # column to view only a certain range of ID #s.

Choose Number ******s to open the advanced ******ing menu.

Choose a ******. In this example, we will choose Between to view ID #s between the numbers we specify.

Enter a number to the right of each ******. In this example, we will view ID #s greater than or

equal to 3000, but less than or equal to 4000. That will display ID #s in the 3000-4000 range.

Click OK. The data will be ******ed according to the ****** you chose and the numbers you specified.

​

 

[A M I R]

[h=2]******ing Data

​

[h=3]Challenge!





Open an existing Excel workbook. If you want, you can use this example.

****** a column of data. If you are using the example, ****** the Type column so it displays only laptops and "other" equipment.

Add another ****** by searching for the data you want. If you are using the example, search for EDI brand equipment in the Item Description column.

Clear both ******s.


Use an advanced text ****** to view data that does not contain a certain word or phrase. If you are

using the example, display data that does not contain the word "cam." (This should exclude any camera-related equipment, such as digital cameras and the camcorder.)

Use an advanced date ****** to view data from a certain time period. If you are using the example, display only the equipment that was checked out last month.

Use an advanced number ****** to view numbers less than a certain amount. If you are using the example, display all ID #s below 3000.
​

 

[A M I R]

[h=2]Formatting Tables

[h=3]Introduction

Once you have entered information into a spreadsheet, you may want to format it. Formatting your spreadsheet can not only improve the look


and feel, but also make it easier to use. In a previous lesson, we discussed many manual formatting options such as bold and italics. In

this lesson, you will learn how to format as a table, to take advantage of the tools and predefined table styles available in Excel 2010.

​

 

[A M I R]

[h=2]Formatting Tables

[h=4]To Format Information as a Table:


Select the cells you want to format as a table. In this example, an invoice, we will format the cells that contain the column headers and the order details.

Click the Format as Table command in the Styles group on the Home tab.

A list of predefined table styles will appear. Click a table style to select it.

A dialog box will appear, confirming the range of cells you have selected for your table. The cells will appear selected in the spreadsheet, and the range will appear in the dialog box.

If necessary, change the range by selecting a new range of cells directly on your spreadsheet.

If your table has headers, check the box next to My table has headers.

Click OK. The data will be formatted as a table in the style that you chose.

Tables include ******ing by default. You can ****** your data at any time using the drop-down arrows in the header.


To convert a table back into "normal" cells, click the Convert to Range command in the Tools

group. The ******s and the Design tab will then disappear, but the cells will retain their data and formatting.



​

 

[A M I R]

[h=2]Formatting Tables

[h=3]Modifying Tables [h=4]To Add Rows or Columns:



Select any cell in your table. The Design tab will appear on the Ribbon.

From the Design tab, click the Resize Table command.

Directly on your spreadsheet, select the new range of cells that you want your table to cover. You must select your original table cells as well.

Click OK. The new rows and/or columns will be added to your table.

​

 

[A M I R]

[h=2]Formatting Tables

[h=4]To Change the Table Style:

Select any cell in your table. The Design tab will appear.


Locate the Table Styles group. Click the More drop-down arrow to see all of the table styles.

Hover the mouse over the various styles to see a live preview.

Select the desired style. The table style will appear in your worksheet.

​

 

[A M I R]

[h=2]Formatting Tables

[h=4]To Change the Table Style Options:

When using an Excel table, you can turn various options on or off to change its appearance. There are

six options: Header Row, Total Row, Banded Rows, First Column, Last Column, and Banded Columns.




Select any cell in your table. The Design tab will appear.

From the Design tab, check or uncheck the desired options in the Table Style Options group.

Depending on the Table Style you're using, certain Table Style Options may have a different

effect. You may need to experiment to get the exact look you want.

​

 

[A M I R]

[h=2]Formatting Tables

[h=3]Challenge!

Open an existing Excel workbook. If you want, you can use this example.

Format a range of cells as a table. If you are using the example, format the column headers (Quantity, Description, etc.) and the order details.

Add a row or a column.

Change the table style options. If you are using the example, add a total row.

Change the table style several times. Take note of how the table options may appear different depending on the style you use.

​

 

[A M I R]

[h=2]Reviewing and Sharing Workbooks

[h=3]Introduction

Suppose someone asked you to proofread or collaborate on a worksheet they put together. If you had a hard copy, you

might use a red pen to cross out cell data, mark misspellings, or add comments in the margins. However, you could also do

all of these things in Excel using the Track Changes and Comments features.


When you've finished reviewing the worksheet, the other person can choose to automatically Accept all of your

changes, or decide whether to Accept or Reject each change one-by-one.


In this lesson, you will learn how to track changes, add comments, and compare two versions of a

worksheet. You will also learn how to prepare a final version for sharing, including how to check spelling.

​

 

[A M I R]

[h=2]Reviewing and Sharing Workbooks

[h=3]Tracking Changes
[h=4]About Track Changes



When you turn on the Track Changes option, every change you make to the worksheet will be

highlighted with a unique border and indicator. Hovering your mouse over a highlighted cell will display

the details of the change. This allows the other person to see what changes have been made before making the changes permanent.

The color of the highlights will vary depending on who is reviewing the document, so if there

are multiple reviewers, you'll be able to tell at a glance who made each change.




There are some changes that Excel cannot track. Familiarize yourself with changes that Excel does not track or highlight.




​

 

[A M I R]

[h=2]Reviewing and Sharing Workbooks

[h=4]To Turn on Track Changes:

Go to the Review tab.

Click Track Changes, then select Highlight Changes from the drop-down menu.

The Highlight Changes dialog box will appear.

Check the box next to Track changes while editing.

Verify the box is checked for Highlight changes on screen. This will highlight your changes while you work.

Click OK.

If prompted, click OK to allow Excel to save your workbook.
Change tracking is now active. Any changes you make to the worksheet will be highlighted with a unique border and indicator.

Your workbook will be "shared" automatically when you turn Track Changes on. Shared workbooks are

designed to be stored where other users (such as users on the same network) can access and edit the

workbook at the same time. However, you can also track changes in a local or personal copy, as seen throughout this lesson.






​

 

[A M I R]

[h=2]Reviewing and Sharing Workbooks

[h=4]To Turn off Track Changes:


From the Review tab, click Track Changes. Then select Highlight Changes from the drop-down menu.

Uncheck the box next to Track changes while editing.

Click Yes to confirm that you want to turn off Track Changes and stop sharing your workbook.

Turning off Track Changes will delete any tracking that has taken place in your workbook. You will

not be able to view, accept, or reject changes; instead, they will all be applied to your workbook

automatically. Always review the changes in your worksheet before turning Track Changes off.

​

 

[A M I R]

[h=2]Reviewing and Sharing Workbooks

[h=3]Adding and Deleting Comments
Sometimes, you may want to add a comment to a worksheet, to provide feedback for the author instead of

changing the contents. Comments are highlighted by a unique indicator and can be read by the original author or by any other reviewers.



​

 

[A M I R]

[h=2]Reviewing and Sharing Workbooks

[h=4]To Add a Comment:
Select the cell where you want the comment to appear.

From the Review tab, click the New Comment command.

Type your comment.

The red indicator in the upper right corner shows that there is a comment in that cell.

Hover your mouse over the cell to view the comment.

​

 

[A M I R]

[h=2]Reviewing and Sharing Workbooks

[h=4]To Edit a Comment:
Select the cell containing the comment you wish to edit.

From the Review tab, click the Edit Comment command (where the New Comment command used to be).

Edit your comment.

​

 

[A M I R]

[h=2]Reviewing and Sharing Workbooks

[h=4]To Delete a Comment:


Select the cell containing the comment you wish to delete.


From the Review tab, click the Delete command.

The comment will be deleted.

​