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.
- DAVERAGE
- DCOUNT
- DCOUNTA
- AVERAGE
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- PRODUCT
- ROUND
- SUM
- SUBTOTAL
- SUMIF (Read more in SUMIF tutorial)
- SUMPRODUCT
- LEFT
- RIGHT
- MID
- PROPER
- VLOOKUP
- HLOOKUP
- FALSE
- TRUE
- IF
- OR
- NOT
- AND
- ISBLANK
- ISERROR
- ISTEXT
0 comments:
Post a Comment