Good knowledge of Advance Excel and formula's ( Lookup, vlookup, double vlookup, H lookup ,vlookup + match, index+ match, vlookup+ choose, reapeted value vlookup, array vloookup, Pivottable, slicers,index, substitute, Basic Macros, Match,If,Sumif,sumifs, sum product, len, trim, Count, countif, countifs, countblank,…