1. Strong working knowledge of office excel tool like creating macros, Pivot Table, V-Lookup, H-Lookup, if-Condition and other relevant formula and functions. • Vlookup, Hlookup, Arrays, SumIFs, CountIFs, Statistical Functions, Offset Function etc. • Concept of Relational Database. • Table, Queries, Form and Macros in Database. • Advance Queries in MS Access. • Database Creation and Maintenance in MS Access. • Import and Export of Large data in MS Access.