-
توجه: در صورتی که از کاربران قدیمی ایران انجمن هستید و امکان ورود به سایت را ندارید، میتوانید با آیدی altin_admin@ در تلگرام تماس حاصل نمایید.
آموزش کامل Excel 2010-EN
- شروع کننده موضوع A M I R
- تاریخ شروع
[h=2]Formatting Cells
[h=3]Fraction
[h=3]Fraction
Fraction formats numbers as fractions separated by the forward slash.
For example, if you enter "1/4" into the cell, the cell will display the number as "1/4". If
you enter "1/4" into a cell that is formatted as General, the cell will display the number as a date, "4-Jan".
you enter "1/4" into a cell that is formatted as General, the cell will display the number as a date, "4-Jan".
[h=2]Formatting Cells
[h=3]Scientific
[h=3]Scientific
Scientific formats numbers in scientific notation.
For example, if you enter "140000" into the cell, then the cell will display the number as "1.40E+05".
Note: by default Excel will format the cell in scientific notation if it is a large integer. If you do not
want Excel to format large integers with scientific notation, then use the Number format.
want Excel to format large integers with scientific notation, then use the Number format.
[h=2]Formatting Cells
[h=3]Challenge!
[h=3]Challenge!
- Open an existing Excel 2010 document. If you want, you can use this example.
- Select a cell and change the font, size or color of the text. If you are using the example, you change the title in cell A1 to the Verdana font, size 16 with a font color of green.
- Select a portion of the content in one cell and make only that portion bold. For example, if the words "Weight (pounds)" are in a cell, make only the word "Weight" bold.
- Add a border to a group of cells. If you are using the example, add a border to the descriptions in row 3.
- Change the fill color of a group of cells. If you are using the example, add a fill color to row 3.
- Try changing the vertical and horizontal text alignment for some cells.
- Try changing the formatting of a number. If you are using the example, change the date format in column A.
[h=2]Saving
[h=3]Introduction
Are you saving a workbook for the first time? Saving it as another name? Sharing it with someone that does not have Excel 2010? There
are many ways you share and receive workbooks, which will affect how you need to save the file.
In this lesson you will learn how to use the Save and Save As commands, how to save as an Excel 97-2003 compatible workbook, and how to save as a PDF.
[h=3]Introduction
Are you saving a workbook for the first time? Saving it as another name? Sharing it with someone that does not have Excel 2010? There
are many ways you share and receive workbooks, which will affect how you need to save the file.
In this lesson you will learn how to use the Save and Save As commands, how to save as an Excel 97-2003 compatible workbook, and how to save as a PDF.
[h=2]Saving
[h=3]Saving Workbooks
[h=4]To Use the Save As Command:
Save As allows you to choose a name and location for your workbook. Use it if you are saving a workbook
for the first time or if you want to save a different version of a workbook while keeping the original.
Click the File tab.
Select Save As.
The Save As dialog box will appear. Select the location where you wish to save the workbook
Enter a name for the workbook and click Save.
If you are using Windows 7, you will most likely want to save files to your Documents library. For other
versions of Windows, you will most likely want to save files to the My Documents folder.
[h=3]Saving Workbooks
[h=4]To Use the Save As Command:
Save As allows you to choose a name and location for your workbook. Use it if you are saving a workbook
for the first time or if you want to save a different version of a workbook while keeping the original.
Click the File tab.
Select Save As.
The Save As dialog box will appear. Select the location where you wish to save the workbook
Enter a name for the workbook and click Save.
If you are using Windows 7, you will most likely want to save files to your Documents library. For other
versions of Windows, you will most likely want to save files to the My Documents folder.
[h=2]Saving
[h=4]To Use AutoRecover:
Excel automatically saves your workbooks to a temporary folder while you are working on
them. If you forget to save your changes, or if Excel crashes, you can recover the autosaved file.
Open a workbook that was previously closed without saving.
In Backstage view, click Info.
If there are autosaved versions of your workbook, they will appear under Versions. Click on the file to open it.
A yellow caution note will appear on the ribbon of the workbook. To restore this version of the workbook click Restore and then click OK.
By default, Excel autosaves every 10 minutes. If you are editing a workbook for less than 10 minutes, Excel may not create an autosaved version.
If you do not see the file you are looking for, or if you are looking for an autosaved version of a file that
has no previously saved versions, you can browse all autosaved files by clicking on the Manage Versions
button and selecting Recover Unsaved Workbooks from the drop-down menu.
[h=4]To Use AutoRecover:
Excel automatically saves your workbooks to a temporary folder while you are working on
them. If you forget to save your changes, or if Excel crashes, you can recover the autosaved file.
Open a workbook that was previously closed without saving.
In Backstage view, click Info.
If there are autosaved versions of your workbook, they will appear under Versions. Click on the file to open it.
A yellow caution note will appear on the ribbon of the workbook. To restore this version of the workbook click Restore and then click OK.
By default, Excel autosaves every 10 minutes. If you are editing a workbook for less than 10 minutes, Excel may not create an autosaved version.
If you do not see the file you are looking for, or if you are looking for an autosaved version of a file that
has no previously saved versions, you can browse all autosaved files by clicking on the Manage Versions
button and selecting Recover Unsaved Workbooks from the drop-down menu.
[h=2]Saving
[h=4]To Save As an Excel 97-2003 Workbook:
You can share your workbooks with anyone using Excel 2010 or 2007, since they use the same
file format. However, earlier versions of Excel use a different file format, so if you want to share
your workbook with someone using an earlier version of Excel, you will need to save it as an Excel 97-2003 Workbook.
Click the File tab.
Select Save As.
In the Save as type drop-down menu, select Excel 97-2003 Workbook.
Select the location you wish to save the file.
Enter a name for the file and click Save.
[h=4]To Save As an Excel 97-2003 Workbook:
You can share your workbooks with anyone using Excel 2010 or 2007, since they use the same
file format. However, earlier versions of Excel use a different file format, so if you want to share
your workbook with someone using an earlier version of Excel, you will need to save it as an Excel 97-2003 Workbook.
Click the File tab.
Select Save As.
In the Save as type drop-down menu, select Excel 97-2003 Workbook.
Select the location you wish to save the file.
Enter a name for the file and click Save.
[h=2]Saving
[h=4]To Save As a PDF:
Saving your workbook as an Adobe Acrobat Document, which is called a PDF file, can be
especially useful when your recipients do not have Excel. A PDF file will make it possible for
recipients to view the content from your workbook, but they will not be able to edit anything. If
you are not sure what a PDF file looks like, you can download our PDF example for this lesson.
Click the File tab.
Select Save As.
In the Save as type drop-down menu, select PDF.
Select the location you wish to save the file.
Enter a name for the file and click Save.
Excel defaults to saving the active worksheet only. If you have multiple worksheets and want to save all of
them in the same PDF file, click on Options. The Options dialog box will appear. Select Entire workbook from the Options dialog box and click OK.
[h=4]To Save As a PDF:
Saving your workbook as an Adobe Acrobat Document, which is called a PDF file, can be
especially useful when your recipients do not have Excel. A PDF file will make it possible for
recipients to view the content from your workbook, but they will not be able to edit anything. If
you are not sure what a PDF file looks like, you can download our PDF example for this lesson.
Click the File tab.
Select Save As.
In the Save as type drop-down menu, select PDF.
Select the location you wish to save the file.
Enter a name for the file and click Save.
Excel defaults to saving the active worksheet only. If you have multiple worksheets and want to save all of
them in the same PDF file, click on Options. The Options dialog box will appear. Select Entire workbook from the Options dialog box and click OK.
[h=2]Saving
[h=3]Challenge!
Open an existing Excel workbook. If you want, you can use this example.
Using the Save As command, save the workbook with the file name Trial.
Save the workbook as a PDF file.
Close the workbook.
Open another existing Excel 2010 workbook.
Save the workbook so that it is compatible with Excel 2003.
Close the workbook.
[h=3]Challenge!
Open an existing Excel workbook. If you want, you can use this example.
Using the Save As command, save the workbook with the file name Trial.
Save the workbook as a PDF file.
Close the workbook.
Open another existing Excel 2010 workbook.
Save the workbook so that it is compatible with Excel 2003.
Close the workbook.
[h=2]Creating Simple Formulas
[h=3]Introduction
Excel can be used to calculate numerical information. In this lesson you will learn how to create simple formulas in Excel
to add, subtract, multiply, and divide values in a workbook. Also, you will learn the various ways you can use cell references
to make working with formulas easier and more efficient.
[h=3]Introduction
Excel can be used to calculate numerical information. In this lesson you will learn how to create simple formulas in Excel
to add, subtract, multiply, and divide values in a workbook. Also, you will learn the various ways you can use cell references
to make working with formulas easier and more efficient.
[h=2]Creating Simple Formulas
[h=3]Simple Formulas
A formula is an equation that performs a calculation. Like a calculator, Excel can execute formulas that add, subtract, multiply, and divide.
One of the most useful features of Excel is its ability to calculate using a cell address to represent the value in a cell. This is called using a cell reference.
In order to maximize the capabilities of Excel, it is important to understand how to create simple formulas and use cell references.
[h=3]Simple Formulas
A formula is an equation that performs a calculation. Like a calculator, Excel can execute formulas that add, subtract, multiply, and divide.
One of the most useful features of Excel is its ability to calculate using a cell address to represent the value in a cell. This is called using a cell reference.
In order to maximize the capabilities of Excel, it is important to understand how to create simple formulas and use cell references.
[h=2]Creating Simple Formulas
[h=3]Creating Simple Formulas
Excel uses standard operators for equations, such as a plus sign for addition (+), a minus sign
for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents.
The key thing to remember when writing formulas for Excel is that all formulas must begin with an
equal sign (=). This is because the cell contains, or is equal to, the formula and its value.
[h=3]Creating Simple Formulas
Excel uses standard operators for equations, such as a plus sign for addition (+), a minus sign
for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents.
The key thing to remember when writing formulas for Excel is that all formulas must begin with an
equal sign (=). This is because the cell contains, or is equal to, the formula and its value.
[h=2]Creating Simple Formulas
[h=4]To Create a Simple Formula in Excel:
Select the cell where the answer will appear (B4, for example).
Type the equal sign (=).
Type in the formula you want Excel to calculate. For example, "75/250".
Press Enter. The formula will be calculated and the value will be displayed in the cell.
[h=2]Creating Simple Formulas
[h=3]Creating Formulas with Cell References
When a formula contains a cell address, it is called a cell reference. Creating a formula
with cell references is useful because you can update data in your worksheet without having to rewrite the values in the formula.
[h=3]Creating Formulas with Cell References
When a formula contains a cell address, it is called a cell reference. Creating a formula
with cell references is useful because you can update data in your worksheet without having to rewrite the values in the formula.