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

[A M I R]

Lesson 3: Creating Excel Functions, Filling Cells, and Printing

​

[h=4]Open Print Preview

​

1. Click the Office button. A menu appears.
2. Highlight Print. The Preview and Print The Document pane appears.
3. Click Print Preview. The Print Preview window appears, with your document in the center.

​

 

[A M I R]

Lesson 3: Creating Excel Functions, Filling Cells, and Printing

​

[h=4]Center Your Document

​

1. Click the Page Setup button in the Print group. The Page Setup dialog box appears.
2. Choose the Margins tab.
3. Click the Horizontally check box. Excel centers your data horizontally.
4. Click the Vertically check box. Excel centers your data vertically.
5. Click OK. The Page Setup dialog box closes.

​

 

[A M I R]

Lesson 3: Creating Excel Functions, Filling Cells, and Printing

​

[h=4]Print-2

​

1. Click the Print button. The Print dialog box appears.
2. Click the down arrow next to the name field and select the printer to which you want to print.
3. Click OK. Excel sends your worksheet to the printer.

This is the end of Lesson 3. You can save and close your file.



​

 

[A M I R]

​

[h=2]Lesson 4: Creating Charts

In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a

variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for

creating a chart is the same no matter what type of chart you choose. As you change your data, your

chart will automatically update.


You select a chart type by choosing an option from the Insert tab's Chart group. After you choose a chart type, such

as column, line, or bar, you choose a chart sub-type. For example, after you choose Column Chart, you can choose

to have your chart represented as a two-dimensional chart, a three-dimensional chart, a cylinder chart, a cone

chart, or a pyramid chart. There are further sub-types within each of these categories. As you roll your mouse

pointer over each option, Excel supplies a brief description of each chart sub-type.



​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=3]Create a Chart

​

​

To create the column chart shown above, start by creating the worksheet below exactly as shown.

​

After you have created the worksheet, you are ready to create your chart.



​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=4]EXERCISE 1

[h=4]Create a Column Chart

[h=4].

1. Select cells A3 to D6. You must select all the cells containing the data you want in your chart. You should also include the data labels.
2. Choose the Insert tab.
3. Click the Column button in the Charts group. A list of column chart sub-types types appears.
4. Click the Clustered Column chart sub-type. Excel creates a Clustered Column chart and the Chart Tools context tabs appear.

​

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=3]Apply a Chart Layout

Context tabs are tabs that only appear when you need them. Called Chart Tools, there are three chart

context tabs: Design, Layout, and Format. The tabs become available when you create a new chart or

when you click on a chart. You can use these tabs to customize your chart.
​

You can determine what your chart displays by choosing a layout. For example, the layout you

choose determines whether your chart displays a title, where the title displays, whether your

chart has a legend, where the legend displays, whether the chart has axis labels and so

on. Excel provides several layouts from which you can choose.
​

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=4]EXERCISE 2


[h=4]Apply a Chart Layout

​

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click the Quick Layout button in the Chart Layout group. A list of chart layouts appears.
4. Click Layout 5. Excel applies the layout to your chart.

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=3]Add Labels

When you apply a layout, Excel may create areas where you can insert labels. You use labels

to give your chart a title or to label your axes. When you applied layout 5, Excel created label areas for a title and for the vertical axis.

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=4]EXERCISE 3


[h=4]Add labels

	​
Before​	After ​

1. Select Chart Title. Click on Chart Title and then place your cursor before the C in Chart and hold down the Shift key while you use the right arrow key to highlight the words Chart Title.
2. Type Toy Sales. Excel adds your title.
3. Select Axis Title. Click on Axis Title. Place your cursor before the A in Axis. Hold down the Shift key while you use the right arrow key to highlight the words Axis Title.
4. Type Sales. Excel labels the axis.
5. Click anywhere on the chart to end your entry.

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=3]Switch Data

If you want to change what displays in your chart, you can switch from row data to column data and vice versa.



​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=4]EXERCISE 4
[h=4]Switch Data

	​
Before​	After​

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click the Switch Row/Column button in the Data group. Excel changes the data in your chart.

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=3]Change the Style of a Chart

A style is a set of formatting options. You can use a style to change the color and format of your

chart. Excel 2007 has several predefined styles that you can use. They are numbered from left

to right, starting with 1, which is located in the upper-left corner.



​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=4]EXERCISE 5

[h=4]Change the Style of a Chart

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click the More button
   
   in the Chart Styles group. The chart styles appear.

​

1. Click Style 42. Excel applies the style to your chart.

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=3]Change the Size and Position of a Chart




When you click a chart, handles appear on the right and left sides, the top and bottom, and

the corners of the chart. You can drag the handles on the top and bottom of the chart to

increase or decrease the height of the chart. You can drag the handles on the left and right

sides to increase or decrease the width of the chart. You can drag the handles on the

corners to increase or decrease the size of the chart proportionally. You can change

the position of a chart by clicking on an unused area of the chart and dragging.





​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=4]EXERCISE 6


[h=4]Change the Size and Position of a Chart

​

1. Use the handles to adjust the size of your chart.
2. Click an unused portion of the chart and drag to position the chart beside the data.

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=3]Move a Chart to a Chart Sheet

By default, when you create a chart, Excel embeds the chart in the active worksheet. However, you

can move a chart to another worksheet or to a chart sheet. A chart sheet is a sheet dedicated to

a particular chart. By default Excel names each chart sheet sequentially, starting with Chart1. You

can change the name.





​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=4]EXERCISE 7

[h=4]Move a Chart to a Chart Sheet

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click the Move Chart button in the Location group. The Move Chart dialog box appears.

​

1. Click the New Sheet radio button.
2. Type Toy Sales to name the chart sheet. Excel creates a chart sheet named Toy Sales and places your chart on it.

​

 

[A M I R]

Lesson 4: Creating Charts

​

[h=3]Change the Chart Type

Any change you can make to a chart that is embedded in a worksheet, you can also make to

a chart sheet. For example, you can change the chart type from a column chart to a bar chart.



​

 

[A M I R]

Lesson 4: Creating Charts



​

[h=4]EXERCISE 8

[h=4]Change the Chart Type

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click Change Chart Type in the Type group. The Chart Type dialog box appears.
4. Click Bar.
5. Click Clustered Horizontal Cylinder.
6. Click OK. Excel changes your chart type.

​

You have reached the end of Lesson 4. You can save and close your file.





​