Hiring VBA Developer in one of the Leading IT Brand @Noida !!

Our Client is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Interactive, Technology and Operations services

Primary Skill : VBA Developer and Macro

Work Location : Noida

Work Timings : 11:00am to 8:30pm ( should be okay with WFO )

NP : Immediate to 15 days

Job Role:

  • Analyzing the needs of internal departments and assisting staff with development
  • Reviewing code to ensure best practices are in place
  • Analyze complex data to develop automated reporting with VBA and Excel
  • Create macros to work with a huge amount of data and for Excel reports
  • Develop VBA programs to perform tasks automatically


Requirements

  • Should have knowledge about Formula creation and should be able to develop formula dynamically
  • Should be able to suggest multiple ways of solving problem in excel
  • Should have knowledge of V-lookup and H-lookup (for example, should be able to apply logics in cases where only partial match of data is needed)
  • Should have knowledge about excel functions like Pivot, Chart, custom sort, conditional formatting etc.
  • Good to have knowledge about dynamic data source for pivot tables.
  • Should be able to generate date value based on multiple condition like today-2, 2nd date of last month, 3rd last day of next month.
  • Should be able to suggest multiple ways of solving problem in excel
  • Should have knowledge about VBA macro


Benefits

  • Monthly Fixed Salary
  • Opportunity to work in a leading IT Brand


Source link