Excel Advance Formulas
Excel Advance Formulas For sophisticated computations, there are functions and advanced excel formulas that can be used. The functions are designed to make searching and organising a large pool of data simple, whereas the advanced excel formula is used to extract new data from a specific set of data. Read More
- VLOOKUP
- HLOOKUP
- SUM FUNCTION
- PRODUCT
- MAX-MIN
- FUNCTION
- IF THE FUNCTION
- PERCENTAGE
- SUMIF FUNCTION
- COUNT
- COUNT A
- COUNT BLANK
- COUNTIF FUNCTION
- AND FUNCTION
- OR FUNCTION
- LEFT FUNCTION
- RIGHT FUNCTION
- MIDDLE
- FIND
- CONCATENATION
- FUNCTION
- UPPER
- LOWER
- LENGTH
- ROUND FUNCTION
- PROPER FUNCTION
- NOW FUNCTION
- TRIM ADVANCED
- EXCEL FORMULA
- CUSTOMIZED MAX
- MIN
- CHOOSE()
- REPT()
- TYPE()
- RANDBETWEEN()
- UNIT CONVERSION
- BY CONVERT()
- PV FUNCTION
- TIME FUNCTIONS
- FREQUENCY
- INDEX & MATCH
- SUBSTITUTE
- SUMPRODUCT
