To format cells containing data between two given values, you need to perform the following steps:

1. Select the range of cells on which you want the conditional format to be applied on.
2. Click on Home Tab
3. Click on Conditional Formatting
4. Click on Highlight Cell Rules
5. Click on Between
6. Between dialog box opens.
7. Enter the start value. In our example, let us enter 1000.
8. Enter the end value. In our example, let us enter 2000.
9. Select the format to be applied on the cell when the given condition is satisfied.
10. Click Ok.

You will now notice that the cells which contain value between 1000 and 2000 are formatted with the format you choose.

Sum Function returns the sum of its arguments. Sum function can take multiple arguments as input. Each of the argument is separated by a comma.

For example. This data contains sales made by each of the sales persons in the month of March and April 2008. Also information on direct sales made in the month of March and April 2008 is provided. You can use the sum function to calculate the total sales for both the months.

Type the following function in the cell E13

=Sum(D4:D9,E4:E9,E11)

This function returns the sum of all sales amounts provided as arguments.

To create a simple PivotTable with a row and a data area, you need to take a look at the following data:

This particular example contains information on sales done by each sales person across the world. For example, Kim has sold for $1500 in the US, $7000 in the UK, $6000 in Australia and $8000 in New Zealand. Now let us try creating a simple PivotTable that shows the total sales made by each of the sales persons - like the one you see on your screen. Here, you need to note a few things before we create this particular PivotTable.

Here, the names of the sales persons are in the rows with corresponding data showing the sum of the sales amount for each of the people.

Let us now move to the sheet where we created a blank PivotTable, and then start adding data into that blank PivotTable.

As we noted earlier, the names of each of the sales people, are in the rows. You now need to drag the sales person field from the field list box and drop it in the PivotTable row area.

We also noted earlier, that the summary data in the report was the sum of sales amount. Therefore, you now need to drag the sales amount field from the field list box and drop it in the data area.

The report is ready. You have now learnt to create a PivotTable report with a row and a data field.