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

[A M I R]

[h=2]Create, open and save workbooks

[h=3]Opening a workbook

You can open any workbook that has previously been saved and given a name.

​

 

[A M I R]

[h=2]Create, open and save workbooks

[h=5]To Open an Existing Excel 2003 Workbook:

• Choose File
  
  Open from the menu bar.
  
  
  
• The Open dialog box opens.
  
  
  
• In the Look in list, click the drive, folder, or Internet location that contains the file you want to open.

• In the folder list, open the folder that contains the file. Once the file is displayed, click on the file you want to open.

• Click the Open button.

​

 

[A M I R]

[h=2]Create, open and save workbooks

[h=3]Closing a Workbook [h=5]To close an existing Excel 2003 Workbook:

• Choose File
  
  Close from the menu bar. The workbook in the Excel window is closed.
  
  
  

Excel 2003 will prompt you to save information if any has been typed between the last save and the time you close the file.



​

 

[A M I R]

[h=2]Create, open and save workbooks

[h=3]Challenge!

In this challenge you will create a spreadsheet that allows you to track your monthly

income and expenses. This file will be used in all of the remaining Excel 2003 challenges.



Create a new blank file and save as Monthly Budget.
Close the blank file.

Important Reminder: If you are using a public computer, such as one at a library or

learning center, you may not be able to use the same computer each time. It is very

important to understand the policies on saving documents to public computers. Some

places do not allow you to use floppy disks due to the risk of computer viruses. Ask

someone in charge of the public computers where you are. If you are unsure how you

will keep a recent copy of the assignment, you can always email a copy of the document to yourself when you finish working on the document.
​

 

[A M I R]

[h=2]Enter, edit and delete data

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

• Enter text in a cell

• Edit information in a cell

• Delete information in a cell

• Select multiple cells

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=3]Entering Text in a Cell
You can enter three types of data in a cell: text, numbers, and formulas. Text is any

entry that is not a number or formula. Numbers are values used when making

calculations. Formulas are mathematical calculations.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Enter Data into a Cell:

• Click the cell where you want to type information.

• Type the data. An insertion point appears in the cell as the data is typed.
• 
  
  
  
• The data can be typed in either the cell or the Formula bar.
  
  
  
• Data being typed appears in the both active cell and in the formula bar.
  
  
  
• Notice the Cancel and Enter buttons in the formula bar.
  
  
  

• Click the Enter button
  
  to end the entry and turn off the formula bar buttons.

Excel's AutoComplete feature keeps track of previously-entered text. If the first few



characters you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you.




​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=3]Editing Information in a Cell
Information in a spreadsheet is likely to change over time. Information

can be changed in either of two ways.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]Quick and Easy Method:

• Click the cell that contains the information to be changed.

• Type the new entry. The old entry is replaced by the new entry.

If the original entry is long and requires only a minor

adjustment (in spelling, for example), then you can directly edit the information in the cell.



​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Edit Information in a Cell:

Method 1: Direct Cell Editing

• Double-click on the cell that contains the information to be changed.

• The cell is opened for direct editing.
  
  
  
• Make the necessary corrections.

• Press Enter or click the Enter button on the Formula bar
  
  to complete the entry.

---

Method 2: Formula Bar Editing

• Click the cell that contains the information to be changed.

• Edit the entry in the formula bar.
• 
  
  
  

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=3]Deleting Information in a Cell [h=5]To Delete Data that Already Appears in a Cell:

• Click the cell that contains the information to be deleted.

• Press the Delete key, or

• Right-click and choose Clear Contents from the shortcut menu.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Delete Data Being Typed But Not Yet Added to the Cell:

Cancel an entry by pressing the Escape key.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=3]Performing Undo and Redo

Sometimes, you might do something to a spreadsheet that you didn't mean to do, like

type the wrong number in a cell. Excel 2003 allows you to undo an operation. Use the

Undo button

on the Standard toolbar to recover an error. The last single action is recoverable.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Undo Recent Actions (typing, formatting, etc), One at a Time:




Click the

Undo button.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Undo Several Recent Actions at Once:

• Click the arrow next to the Undo button.

• 
• Microsoft Excel reverses the selected action and all actions that appear in the list above it.

An Undo operation can be cancelled by applying a Redo. This is useful when an

Undo operation was mistakenly applied. Remember, a Redo is possible only

if you have not changed an Excel spreadsheet since the last Undo operation was completed

:

• Select the desired Undo operation(s) from the list.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Redo an Undo Operation:

Press the

Redo button.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Redo several recent Undo actions at once:

• Click the arrow next to Redo button.

• Select the desired Redo operation from the list.

• Microsoft Excel reverses the Undo operation.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=3]Selecting Multiple Cells

The currently-selected cell in Excel is called the active cell. You can also select a

group of adjacent cells, or a cell range. Many operations can be done against a

cell range: move it, copy, it, delete it or format it. A cell range can be defined in

different ways: select a specific range of cells, select multiple columns or rows, or select the entire worksheet.



​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Select a Range of Cells:

• Move to the first cell in the range.

• The mouse pointer becomes a large cross.

• Click-and-hold the left mouse button and drag left or right, up or down to the last cell you want to select.

• Release the mouse button.

• The cells you selected are shaded.
• 
  
  
  

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=5]To Select All Cells in a Column or Row:
Click the gray Column heading to select the entire column. (Click and drag the cursor across other column headings to select those columns).

Click the gray Row heading to select the entire row. (Click and drag the cursor down through the row headings select those rows).

​