ore Advanced Formulas• INDEX MATCH: A flexible, powerful alternative to VLOOKUP and HLOOKUP that looks up values across rows and columns.• XNPV & XIRR: Financial functions used for calculating net present value and internal rate of return with irregular cash flow dates.• SUMIF / COUNTIF / SUMPRODUCT: Conditional math formulas used to aggregate and analyze data subsets.• OFFSET: Combines with functions like SUM or AVERAGE to build agile, shifting data ranges.
- Experience
3 Years
- No. of Openings
2
- Education
I.T.I. (Computer Operator and Programming Assistant)