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
