company logo

Advanced Excel and VBA

Mid-Level: 4 to 6 years
10L - 20L (Per Year)
Posted on Apr 13 2022

About the Job


Proficiency and minimum hands on experience of 4-6 years

·  Expert level Excel skills (Conditional Formatting, Data Validation Rules, Table Manipulation, Named Ranges, Creating/Modifying connections to external data sources, Workbook/Worksheet/Cell Data Protection)

Advanced Excel Formulas such as Pivot Table, Lookups, Conditional formatting, count IF, Sum IF, INDEX / MATCH and data tables etc.

·  Expert level Excel VBA skills (Ability to create complex forms/functions/subroutines, Experience using constants and visibility modifiers, Programmatic manipulation of objects/tables/data connections/formulas/loop)

·  Experience creating PowerPoint slide decks and along with that experience in automating the PowerPoint slide creation using excel VBA.

·  Formats extracted data based on expected report output (with batching capability and multiple data formatting requirements)

·  Consolidate and combine extracted data from multiple resources using automated tools (excel, VBA macro, SQL database), and/or from different system/tools/Database in one single database using SQL queries to standardize data structure from different data source.

·  Gathers and analyse report requirements from stakeholders. Identify the processing tool (Excel / SQL) and provide a robust solution which can be easily leveraged or extended to other domains.

·  Building complex VBA scripts to automate Excel spreadsheet processes

Tools: VBA, SQL & SSIS, Advanced Xls, Implementing PPT Packages

About the company

We are a staffing expert company with options to hire on C2H, Contract or Perm positions. We offer our clients to achieve their business goals with successfully outsourcing the business processes and functionalities. Our ability to offer high quality services in quick time makes us sustainable among the competitors. We believe in giving custom-fit, flexible and high quality solutions by deeply ...Show More


Staffing and Recruiting

Company Size

2-10 Employees