·
Minimum 5 years of experience
in developing Excel Macro using VBA
·
Advanced Excel skills (i.e.
complex formulas)
·
Able to debug/code difficult
functions/macros using VBA
·
Ability to normalize complex
data/define referential integrity in Excel/Access
·
Ability to programmatically
manipulate worksheet and cell properties using VBA
·
Use Visual Basic in Microsoft
Applications, including Excel, Access, Word and PowerPoint
·
Use Advanced Excel
capabilities, including pivot tables, lookups, and complex formulas and
graphing to streamline business processes
·
Must possess problem solving
skills and be proactive in researching solutions
·
Excellent oral and written
communication skills
·
Develop test plans and
software documentation to support new releases and code modifications
·
Confer with internal
customers to gain understanding of needs