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

[A M I R]

[h=2]Getting Started with Excel

[h=4]To Get to Backstage View:
On the Ribbon, click the File tab.

Choose your desired option, or return to your workbook by clicking on any tab on the Ribbon.

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Save, Save As, Open and Close

Familiar tasks such as Save, Save As, Open and Close are now found in Backstage view.
​

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Info

Info contains information about the current workbook. You can also inspect and edit its permissions.

​

​

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Recent

For convenience, recent workbooks will appear here.

​

​

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]New

From here, you can create a new, blank workbook, or you can choose from a large selection of templates.

​

​

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Print

From the Print pane, you can change the print settings and print your workbook. You can also see a preview of your workbook.

​

​

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Save & Send

Save & Send makes it easy to email your workbook, post it on the web, or change the file format.


​

​

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Help

From here, you can access Microsoft Office Help or check for updates.

​

​

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Options

Here, you can change various Excel options. For example, you can control the spelling and

grammar check settings, AutoRecover settings, or Language preferences.
​

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Creating and Opening Workbooks
Excel files are called workbooks. Each workbook holds one or more worksheets (also known as "spreadsheets").

​

 

[A M I R]

[h=2]Getting Started with Excel

[h=4]To Create a New, Blank Workbook:

1. Click the File tab. This takes you to Backstage view.
2. Select New.
3. Select Blank workbook under Available Templates. It will be highlighted by default.
4. Click Create. A new, blank workbook appears in the Excel window.
   
   
   
   
   To save time, you can create your document from a template, which you can select under
   
   Available Templates. We will talk more about this in a later lesson.
   
   

 

[A M I R]

[h=2]Getting Started with Excel

[h=4]To Open an Existing Workbook:

1. Click the File tab. This takes you to Backstage view.
2. Select Open. The Open dialog box appears.
   
   
   
   Select your desired workbook and then click Open
   
   If you have opened the existing workbook recently, it may be easier to choose Recent from
   
   the File tab instead of Open to search for your workbook.
   
   
   
   
   

 

[A M I R]

[h=2]Getting Started with Excel

[h=3]Challenge!

• Open Excel 2010 on your computer. A new blank workbook will appear on the screen.
• Try minimizing and maximizing the Ribbon.
• Click through all of the tabs and notice how the Ribbon options change.
• Try switching page views.
• Add any commands you wish to the Quick Access Toolbar.
• Close Excel without saving the workbook.

 

[A M I R]

[h=2]Cell Basics

[h=3]Introduction

You will need to know the basic ways you can work with cells and cell content in Excel to be able to use it

to calculate, analyze, and organize data. In this lesson, you will learn how to select cells; insert content; and

delete cells and cell content. You will also learn how to cut, copy and paste cells; drag and drop cells; and fill cells using the fill handle.

​

 

[A M I R]

[h=2]Cell Basics

[h=3]Introduction to Cells and Cell Content

Cells are the basic building blocks of a worksheet. Cells can contain a variety of content

such as text, formatting attributes, formulas, and functions.
​

 

[A M I R]

[h=2]Cell Basics

[h=3]The Cell

Each rectangle in a worksheet is called a cell. A cell is the intersection of a row and a column.

Each cell has a name, or a cell address based on which column and row it intersects. The cell address

of a selected cell appears in the Name box. Here you can see that C5 is selected.

​

 

[A M I R]

[h=2]Cell Basics

[h=4]To Select a Cell:
Click on a cell to select it. When a cell is selected you will notice that the borders of the cell

appear bold

and the column heading and row heading of the cell are highlighted.


Release your mouse. The cell will stay selected until you click on another cell in the worksheet.

You can also navigate through your worksheet and select a cell by using the arrow keys on your keyboard.



​

 

[A M I R]

[h=2]Cell Basics

[h=4]To Select Multiple Cells:
Click and drag your mouse until all of the adjoining cells you want are highlighted.

Release your mouse. The cells will stay selected until you click on another cell in the worksheet.
​

 

[A M I R]

[h=2]Cell Basics

[h=3]Cell Content
Each cell can contain its own text, formatting, comments, formulas, and functions.

• Text
  Cells can contain letters, numbers, and dates.
• Formatting attributes
  Cells can contain formatting attributes that change the way letters, numbers, and dates are displayed. For example, dates can be formatted as MM/DD/YYYY or Month/D/YYYY.
• Comments
  Cells can contain comments from multiple reviewers.
• Formulas and Functions
  Cells can contain formulas and functions that calculate cell values. For example, SUM(cell 1, cell 2...) is a formula that can add the values in multiple cells.

​

 

[A M I R]

[h=2]Cell Basics

[h=4]To Insert Content:

1. Click on a cell to select it.
2. Enter content into the selected cell using your keyboard. The content appears in the cell and in the formula bar. You also can enter or edit cell content from the formula bar.