Pavan Gaikwad

Detail-oriented HR professional with hands-on experience in payroll processing seeking to leverage skills and knowledge as a Trainee HR (Payroll) to contribute to efficient HR operations and staff support.

Trainee HR (Payroll) at YIPL Company (2024-12 – Present)

Detail-oriented HR professional with hands-on experience in payroll processing seeking to leverage skills and knowledge as a Trainee HR (Payroll) to contribute to efficient HR operations and staff support.

• 1 Year of Experience Complete on DEC-2025
• Proficient in basic functions (SUM, AVERAGE, COUNT, etc.) and formulas
• Advanced use of pivot tables for data analysis and reporting
• Expertise in creating and managing complex macros for automation
• Ability to utilize VLOOKUP, HLOOKUP, and XLOOKUP for data retrieval across sheets
• Skilled in data visualization techniques, including charts, conditional formatting, and sparklines
• Experience with advanced data analysis tools like Power Query and Power Pivot
• Competence in using data validation and error-checking techniques for data integrity
• Knowledge of advanced statistical functions (e.g., STDEV, CORREL, FORECAST)
• Familiarity with collaborative features such as shared workbooks and co-authoring
• Ability to create and customize dashboards for interactive reporting
• Experience in data cleansing and transformation strategies
• Skilled in using Excel's What-If Analysis tools (e.g., Goal Seek, Data Tables)
• Knowledge of integrating Excel with other Microsoft Office applications and external data sources
• Ability to utilize VLOOKUP and HLOOKUP for data retrieval across sheets
• Skilled in data visualization techniques, including charts and conditional formatting
• Knowledge of creating and managing dynamic arrays and functions (e.g., FILTER, SORT, UNIQUE)
• Excel In Data Management Data Analysis

B.Com in Business Administration – K.B.C. North Maharashtra University, Jalgaon, Maharashtra (2021-07 – 2024-11)