ADVANCE EXCEL
- Look up / V - LOOKUP / H - LOOKUP
- PMT / PPMT / SLM - METHOD / DBM - METHOD
- MATCH WITH INDEX
- IF & AND , IF & OR / IF & NOT
- CONDITIONAL FORMATTING
- LARGEST FUNCTION
- HIGHLIGHT FUNCTION / GOAL SEEK / SOLVER
- DATA TABLE & FLASH FILL
- SUMPRODUCT FUNCTION
- PIVOT CHART / PIVOT TABLE
- POWER MAP / DATA VALIDATION
- SECNARIO / NUMBER FORMATTING ETC.....