13 pages

English

Excel Tutorial

Ninol - Pc User

Le téléchargement nécessite un accès à la bibliothèque YouScribe
Tout savoir sur nos offres

13 pages

English

Le téléchargement nécessite un accès à la bibliothèque YouScribe
Tout savoir sur nos offres

A propos
Informations
Extrait

Description

www.WebBreez.comMicrosoft Excel TutorialMicrosoft Excel TutorialMicrosoft Excel TutorialHow to sort dataMicrosoft Excel has a tool to help you easily sort your data in an ascending or descending manner. Select all the data you need to sort. Excel will sort the data according to the information in the starting column. In this case, the basis for the sort will be Column A.www.WebBreez ...

Informations

Publié par	Ninol
Nombre de lectures	77
Langue	English

Extrait

www.WebBreez.com

Microsoft Excel Tutorial

Microsoft Excel Tutorial

Microsoft Excel Tutorial How to sort data Microsoft Excel has a tool to help you easily sort your data in an ascending or descending manner.

Select all the data you need to sort. Excel will sort the data according to the information in the starting column. In this case, the basis for the sort will be Column A.

www.WebBreez.com

Microsoft Excel Tutorial

Once you have selected the data, click on the appropriate button found in the tool bar.

The data is now arranged from the lowest number up to the highest.

To sort the data by last name, you would need to move the Last Name column to column A. One way to do this is to copy the entire column C.

www.WebBreez.com

Select column A, then right-click to see the menu. Click on insert.

Microsoft Excel Tutorial

This will insert a column before column A. Paste the item you copied into the empty column.

Again, select the data you wish to sort.

www.WebBreez.com

Click on the appropriate sort button from the toolbar.

The items are now listed according to their Last Name.

Microsoft Excel Tutorial

You can now delete the extra column you created. To do this, select the column you wish to delete. Right-click, then select Delete.

www.WebBreez.com

Hiding and Un-hiding cells

Select the columns or rows you want to hide.

Right-click on the row markers and select Hide from the menu.

Microsoft Excel Tutorial

www.WebBreez.com

To unhide, follow the same procedure, and click on Unhide.

Microsoft Excel Tutorial

www.WebBreez.com

Formulas

Microsoft Excel Tutorial

This is a sample worksheet to help guide you to using formulas on Excel.

You would need to fill in the costs for the two columns: the cost per person and the cost for two.

www.WebBreez.com

Microsoft Excel Tutorial

In the Transportation section, the cost listed is for each passenger. You would just need to copy the data in the cost column. To do this select the cell you want to fill in. Type in the equal sign (=), then using your mouse, select the cell you wish to copy. Press the enter key.

With this formula, the cell is instructed to copy the value inside the cell. This means that when you change the cell under the Cost column, it will automatically reflect the change in the Per Person column.

To perform simple formulas, you would have to use symbols that represent mathematical functions. The plus sign (+) is for addition, the minus/dash/hyphen for (-) subtraction, the asterisks (*) for multiplication and the slash (/) for division.

www.WebBreez.com

Microsoft Excel Tutorial

Some examples: The cost listed under the Accommodation section is for two persons. To get the cost for one person, you would need to divide the Cost by two.

In the Food Allowance section, the cost listed is the cost per person for one meal. The cost would have to be multiplied by the number of meals.

To get the Food Allowance for two persons, you can either multiply the cost per person by two or multiply the cost of each meal by the number of meals then multiply it into two. You would have to put the first part of the equation inside a parenthesis ( ) to indicate that this should be done first.

You can easily replicate the same formula by copying the cell.

Select the cells you want the formula to be copied in, then click on paste.

www.WebBreez.com