company logo

Advanced Excel and VBA

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

About the Job

Skills


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

Industry

Staffing and Recruiting

Company Size

2-10 Employees

Headquarter

Bangalore