Thursday, August 4, 2011

Create your own formula in a PivotTable

1. Select a cell in the Pivot Table report.

2. Press Alt+jt+j+f or you select option than Formulas and then Calculated Field.

3. In the Insert Calculated Field dialog box, type the formula name in the Name box.

4. In the Fields list box, select the first field name to insert and click Insert Field. The field name is copied into the Formula box.

5. Type / (in this example), repeat step 4 to insert the second field into the formula, and then click OK.

6. To format the new field, select a cell in the field and click the Field Settings icon on the Pivot Table toolbar.

see this......

Sunday, July 17, 2011

Use Excel Countif function

Use Excel Countif function when you want to see the count of a specific criteria
appear in a selected range.


For Example :

1.How many times does the name "jack"appear in a list of worker names?


2.How many prices higher than 1000 are there in a given price list?



see this video for reference





Saturday, July 16, 2011

Using multiple criteria with the “OR” functions

Hi friends this Post is Actually Posted by Mr. Amit Kumar. Specially thanks to him. Mr Amit is our new contributor and he is very happy to share his knowledge with us

The function “OR” is used in a same manner like "AND" function, but its meaning is slightly different.
Instead of checking if all its parts is met (as is the case of the “AND” function), it checks if at least one of the criteria inside it is met. If it is, then the whole “OR” is considered met.

Hence, in the following formula:
=IF(OR(C1>80,D1>80,E1>80) , “Good student” , “Average Student” )

Below here is a Demo Video of OR function with IF.


You all can get more information about if statement from the bellow links.

Subscribe Now: From your browser

Search:

Learn Office Excel