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.