The candidate must have a thorough understanding of designing Excel templates, simple to complex Excel built-in functions, charts, tables and have ability to apply the same to business situation. Apart from user level Excel understanding, applicant should know VBA Macros, able to apply best practices in Macros i.e. naming conventions, standardization, understanding to get data from different sources.
Excel Built-in Functions, Formulae, PivotTable, PivotChart
Extensive knowledge of Microsoft Excel Macro is required.
Knowledge of business intelligence / analytics tools like Business Objects, Tableau or similar data mining service, with ability to write variables and understand scripts.
Data mining, statistics and analytical modeling.
Strong experience with analytics in Excel, Macros, References, programming, etc.
Ability to assist users to make changes, demonstrate, recommend or guide users.
Must have the ability to think quickly on your feet in a faced paced environment.