Planning and using excel function

Excel formulae are used when the calculation spread sheet or database is developed.  It is also important to know engineer or planner who involves in analyzing of performance and status. The following functions are commonly used to analyze financial and project or product data.

•  Data base functions

1. DAVERAGE
2. DCOUNT
3. DCOUNTA

•  Statistical functions

1. AVERAGE
2. COUNT
3. COUNTA
4. COUNTBLANK
5. COUNTIF  

• Mathematical functions

1. PRODUCT
2. ROUND
3. SUM
4. SUBTOTAL
5. SUMIF (Read more in SUMIF tutorial)
6. SUMPRODUCT

• Text functions

1. LEFT
2. RIGHT
3. MID
4. PROPER

• Lookup functions

1. VLOOKUP
2. HLOOKUP

• Logical functions

1. FALSE
2. TRUE
3. IF
4. OR
5. NOT
6. AND

• Information functions

1. ISBLANK
2. ISERROR
3. ISTEXT