Avenirhub offers HR payroll training program for candidates that refers to the business management especially for those who are looking to build a career in the field of HR payroll processing. HR Payroll training is a basic aspect and very significant of any HR department in a business organization and where the operator is required to calculate the salaries of his employees after making all deductions and compensating accurately and timely. The course is committed to help students understanding all the legal compliance & statutory, learning the effective tools to make payroll processing very easy and effective.
The role of Avenirhub in aim payroll processor is to assist participants in obtaining a good job in any well-established company by giving them sufficient training and needing expertise again to execute tasks.
With all these important features and benefits, it would be a wise decision to join a quality HR payroll training course. We Avenirhub are considered the best HR training institute in Lucknow. Enroll for our HR payroll training course in one go and be ready to achieve your ambition you were dreaming of.
a. Employees’ Provident Fund (EPF)
b. Employees’ State Insurance (ESI)
c. Payment of Bonus
d. Payment of Gratuity
1. PAYROLL PROCESSING
2. TAX PLANNING FOR SALARIED EMP.
2.1 – MS Excel- Lab Session
Objective: Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advanced Excel so that user can Make Advanced Analysis with the help of Those Tools
Lookup and Reference Functions:-VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’sSum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct.
Text Functions and Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.
Logical Functions:-And, Or, If, Iferror, Not, Nested If, Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min
Data Management:- Data Collection Method With Data Quality, Collaboration and Security Like Share Your Workbook On Share Drive With Quality
Analysis:- Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table,
Advanced Chart, Graph and Dashboard:- Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table
Advanced Filter, Validation and Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group and Ungroup, Data Split. Pivot Table and Charts, Import and Export Data, Protect/Unprotect Sheets/Workbooks, Worksheet Formatting and Print Display.
1. DISCIPLINARY ACTION/TERMINATION/MISCONDUCT
2. CONTRACT LABOUR (REGULATION AND ABOLITION) ACT1970
3. SHWW Act, 2013 (New Topic Added)
4. TRADE UNION
5. SHOPS and ESTABLISHMENT Act
6. FACTORY Act, 1948
7. INDUSTRIAL DISPUTES Act, 1947
8. MINIMUM WAGES Act
9. APPRENTICESHIP Act, 1961 (New Topic Added)