Responsibilities: . In Excel 2010 manipulates, updates and troubleshoots complex formulas, macros, conditional formatting and VBA coding on multiple spreadsheets designed to support the compensation planning of 6,000 employees. . Individual will be responsible for modifying & enhancing existing spreadsheets based on new requirements and criteria. . Must be able to quickly comprehend the existing rules and structure of an established compensation planning tool (web based) in order to modify the VBA coding and functionality of excel spreadsheets that mimic tool functionality. . Document changes and enhancements made to formulas in visio. . May develop new features, pivot tables, formulas and charts to improve spreadsheet capability and functionality. . Make recommendations for enhancements to spreadsheets . Identify and resolve formula/data issues within tight timeframe with 100% accuracy. % of time: 100% creating, modifying, testing, documenting coding/macros in excel Requirements: . 2-3 years experience creating & modifying complex excel formulas, conditional formatting and VBA coding . Expert knowledge of Excel 2010 and VBA . Experience with Visio . Experience creating and modifying pivot tables, charts, graphs . Experience working with HR data a plus . Ability to identify and understand existing formulas/macros and make modifications based on new requirements and needs . Ability to work within tight deadlines