Candidate should handle all IT operations in a company and planning, designing and evaluating computer systems and data bank of the organization. The candidate must possess thorough knowledge of advanced excel and must have hands on experience of SUMIF/SUMIFS , COUNTIF / COUNTIFS , Data Filters , Data Sorting , Pivot Tables , Cell Formatting , VLOOKUP , INDEX + MATCH , Conditional Formatting , PIVOT Tables & PIVOT Reporting , VBA & Macros . Data Tables.