|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Excel 2007 Tutorial for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories
- Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,
|
Microsoft Excel Tips and Tricks for beginners |
|
|
| |
|
| Illustration 9: Range A10:E20. |
| |
| 10) Another way to specify cell's references. In the C9 cell, writes the equal sign, writes SUM and write an opening parenthesis. |
| |
| 11) Click in the C4 cell and, next, write a semicolon in the C9 cell. |
| |
| 12) Click in the C6 cell and, next, writes a closing parenthesis in the C9 cell. |
| |
|
| Illustration 10: Writing formulas. |
| |
| 13) Press ENTER to show the formula results. |
| |
| 14) You can directly write cell's references in the cells, or specify clicking them in the corresponding cells, which avoids write errors. |
| |
| 15) A relative cell's reference for a formula change automatically when the formula is copied in others columns or rows. |
| |
| 16) An absolute cell's reference of cells is fixed. The absolute references do not change when copying a formula of a cell in another one. |
| |
| 17) A mixed cell's reference has either an absolute column and a relative row, or an absolute row and a relative column. |
| |
|
| Illustration 11: Relative and absolutes references. |
| |
| 18) The references of relative cells change from a row to another one. |
| |
| 19) The absolute reference always makes reference to the E29 cell. |
| |
| 20) The E29 cell contains the value for the discount of the 7 percent. |
| |
| 21) Use references of absolute cells to make reference to cells that that does not wish they change when copying the formula.
|
| |
| Working with functions |
| |
| 22) Functions names allows to express writing for long formulas. |
| |
| Cell's reference | Refers to |
| AVERAGE | The average |
| MAX | The most great number |
| MIN | The minor number |
| |
| |
| 23) These predefined formulas simplify the process of calculation's introduction. The functions allow the easy and quickly formulas creation, that can
be complicated for the user. |
| |
| 24) Select the function icon from the formula bar. |
| |
|
| Illustration 12: Select the function icon. |
| |
|
| |
|
|
|
|
|
|
|
| | |
