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

[A M I R]

Excel 2003
​

​

[h=3]Excel Basics

Identifying basic parts of the Excel window

Create, open and save workbooks

Enter, edit and delete data

Moving, Copying and Deleting Cell Contents

Creating Simple Formulas

Creating Complex Formulas

Using functions

---

[h=3]Worksheet Layout and Management

Working with multiple worksheets

Inserting and Deleting Rows and Columns

Changing Column Width and Row Height

Inserting and Deleting Cells

Text and Cell Alignments

Formatting Numbers

Applying Font, Color and Borders to Cells

---

[h=3]Charting, Printing and Page Setup

Creating a Chart

Moving, Resizing, and Deleting Charts

Editing Charts

Formatting a Chart

Defining Page Setup Options

Print Management

---

[h=3]Advanced Excel Topics

Using Auto******

Sorting Lists

Inserting, Viewing, and Editing Comments

Inserting Hyperlinks

Grouping Worksheets

Applying and Modifying Cell Formats

Creating New Workbooks from Templates




​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=3]Introduction

Microsoft Excel 2003 is a spreadsheet application in the Microsoft Office Suite. A

spreadsheet is an accounting program for the computer. Spreadsheets are primarily

used to work with numbers and text. Spreadsheets can help organize information, like

alphabetizing a list of names or ordering records, or calculate and analyze information

using mathematical formulas.

---

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

• Identify the parts of the Excel window

• Understand the differences between a Workbook and a Worksheet

• Understand a cell and its importance to Excel

• Move around a workbook

​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=3]The Excel Window
Many items you see on the Excel 2003 screen are standard in most other Microsoft software

programs like Word, PowerPoint and previous versions of Excel. Some elements are specific to this version of Excel.

​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=5]Workbook Also called a spreadsheet, the Workbook is a unique file created by Excel.
[h=5]Title bar

The Title bar displays both the name of the application and the name of the spreadsheet.

[h=5]Menu bar

The Menu bar displays all the menus available for use in Excel 2003. The contents

of any menu can be displayed by clicking on the menu name with the left mouse button.

[h=5]Toolbar Some commands in the menus have pictures or icons associated with them. These pictures may also appear as shortcuts in the Toolbar.

[h=5]Column Headings

Each Excel spreadsheet contains 256 columns. Each column is named by a letter or combination of letters.

[h=5]Row Headings

Each spreadsheet contains 65,536 rows. Each row is named by a number.

[h=5]Name Box

Shows the address of the current selection or active cell.

[h=5]Formula Bar

Displays information entered-or being entered as you type-in the current

or active cell. The contents of a cell can also be edited in the Formula bar.

[h=5]Cell

A cell is an intersection of a column and row. Each cell has a unique cell address. In the

picture above, the cell address of the selected cell is B3. The heavy border around the selected cell is called the cell pointer.


​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=5]Navigation Buttons and Sheet Tabs

Navigation buttons allow you to move to another worksheet in an Excel workbook. Used to

display the first, previous, next or last worksheets in the workbook.


Sheet tabs separate a workbook into specific worksheets. A Workbook defaults to

three worksheets. A Workbook must contain at least one worksheet.



​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=3]Workbooks and Worksheets

A Workbook automatically shows in the workspace when you open Microsoft Excel 2003. Each

workbook contains three worksheets. A worksheet is a grid of cells, consisting of 65,536 rows

by 256 columns. Spreadsheet information--text, numbers or mathematical formulas--is entered in the different cells.

Column headings are referenced by alphabetic characters in the gray boxes that run

across the Excel screen, beginning with the Column A and ending with Column IV.


Rows are referenced by numbers that appear on the left and then run down the

Excel screen. The first row is named Row 1 and the last row is named 65536.



​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=3]The Cell
An Excel worksheet is made up of columns and rows. Where these columns and rows intersect, they

form little boxes called cells. The active cell, or the cell that can be acted upon, reveals a dark

border. All other cells reveal a light gray border. Each cell has a name. Its name is comprised

of two parts: the column letter and the row number

In the following picture the cell C3, formed by the intersection of column C and row 3, contains the dark border. It is the active cell.

​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=3]Moving around the worksheet




You can move around the spreadsheet in several different ways.

​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=5]To Move the Cell Pointer:

• To activate any cell, point to a cell with the mouse and click.

• To move the pointer one cell to the left, right, up, or down, use the keyboard arrow keys.

​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=5]To Scroll Through the worksheet:

The vertical scroll bar located along the right edge of the screen is used to move up or


down the spreadsheet. The horizontal scroll bar located at the bottom of the screen is used to move left or right across the spreadsheet.

The PageUp and PageDown keys on the keyboard are used to move the cursor

up or down one screen at a time. Other keys that move the active cell are Home, which

moves to the first column on the current row, and Ctrl+Home, which moves the

cursor to the top left corner of the spreadsheet or cell A1.




​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=5]To Move between worksheets



As mentioned, each Workbook defaults to three worksheets. These worksheets are

represented by tabs-named Sheet1, Sheet2 and Sheet3-that appear at the bottom of the Excel window.

​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=5]To Move from one worksheet to another worksheet:
Click on the sheet tab (Sheet1, Sheet2 or Sheet 3) that you want to display

​

 

[A M I R]

[h=2]Identifying basic parts of the Excel window

[h=3]Challenge!

• Display the contents of every menu in the menu bar and note the icons associated with specific menu choices.

• Try and find the matching pictures or shortcuts in the standard toolbar.

• Click on each of the three worksheet tabs -- Sheet1, Sheet2 and Sheet3 --to practice moving from sheet-to-sheet in the workbook.

• Practice scrolling in the worksheet by using the Page Up (PgUp) and Page Down (PgDn) keys.

• Use the horizontal and vertical scrollbars to practice scrolling up, down, left and right in the worksheet.

​

 

[A M I R]

[h=2]Create, open and save workbooks

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

• State the differences between New, Open, Close Save and Save As

• Create a workbook

• Save a workbook

• Open a workbook

• Close a workbook

​

 

[A M I R]

[h=2]Create, open and save workbooks

[h=3]Understanding File Terms

The File menu contains all the operations that we will discuss in this lesson: New, Open, Close, Save and Save As.

[h=5]New Used to create a new Workbook.
[h=5]Open Used to open an existing file from a floppy disk or hard drive of your computer.
[h=5]Close Used to close a spreadsheet.
[h=5]Save As Used to save a new file for the first time or save an existing file with a different name.
[h=5]Save Used to save a file that has had changes made to it. If you close the workbook without saving then any changes made will be lost.



​

 

[A M I R]

[h=2]Create, open and save workbooks

[h=3]Creating a workbook

A blank workbook is displayed when Microsoft Excel is first opened. You can type

information or design a layout directly in this blank workbook.
​

 

[A M I R]

[h=2]Create, open and save workbooks

[h=5]To Create an Excel Workbook:

• Choose File
  
  New from the menu bar.
  
  
  
• The New Workbook task pane opens on the right side of the screen.
  
  
  
• Choose Blank Workbook under the New category heading.

• A blank workbook opens in the Excel window. The New Workbook task pane is closed.

​

 

[A M I R]

[h=2]Create, open and save workbooks

[h=3]Saving a workbook

Every workbook created in Excel must be saved and assigned a name to

distinguish it from other workbooks. The first time you save a workbook, Excel

will prompt you to assign a name through the Save As operation. Once assigned

a name, any additional changes made to the text, numbers or formulas need to be saved using the Save operation.



​

 

[A M I R]

Create, open and save workbooks

To Save a new Workbook




Choose File

Save As from the menu bar.

• The Save As Dialog Box appears.

• Click on the Save In: dropdown menu and locate where the file will be
• saved. Choose 3 1/2 Floppy (A to save the file to a floppy disk or Local Disk (C to save the file to your computer.

• Type a name for your file in the File Name: box.

• Click the Save button.
  
  
  

​

 

[A M I R]

[h=2]Create, open and save workbooks

[h=5]To Save Changes Made to an Existing Workbook:

• Choose File
  
  Save from the menu bar, or
  
  Click the
  
  Save button on the Standard toolbar.

If you're saving the file for the first time and you do not choose a file name, Microsoft Excel will assign a file name for you.

It is a good idea to Save frequently when working in a spreadsheet. Losing

information is never fun! You can quickly save your spreadsheet by using the quick-key combination Ctrl + S.



​