Applicant should have good understanding of excel functions like Find & Replace, Vlookup etc.
Knowledge of advanced Excel worksheet functions, database functions, Nested functions, Index, Match, offset and text manipulation functions
Knows how to work with names ranges, dynamic name ranges
Formatting Numeric and Date Values.
Ability to work with pivots and slicer.
Knowledge of Dashboard designing process and ability to create appealing Visualization using customized charts.
Knowledge about advance filter, data validation, and complex conditional formatting, effective formatting/design.
He/ She must know how to declare Variable and their scope,
Have knowledge about VBA loops & logical statement
Basic knowledge of macro recording & editing
Should be able to work with arrays/dynamic arrays, and have programmatically sort data, applied formatting, functions, added/removed worksheets and opened/saved workbooks.
Understanding of user forms and standard controls like textbox, label, combo box, list box, and button.
DAO/ADO connectivity from various applications including Excel to Access or SQL.
MS SQL –
He/ She should have understanding of Basic DDL/DML statements (like Create, Select, Delete, Update, Alter, Truncate commands) with complete syntax.
Familiarity with basic RDBMS concepts including keys and data integrity rules (like Primary Key, Foreign key, unique constraints)
Knowledge about Joins and Views
Ability to created nested SQL queries
Working knowledge on Stored Procedures
Roles & Responsibilities:
Source – WIPRO Website