Overview
Statutory means “related to statutes,” which is Rules and Regulations. Compliance stands for adherence. Thus Statutory compliance means “To Follow the rules and regulations.” Statutory compliance is a legal framework under which the Company must function all its duties.
Without having much knowledge about this, would be really very difficult for HR to frame policies, guiding employees and employers about rights & limitations on their roles.
Benefits
Who can Join?
Eligibility:
Mode of Learning
Course Details
Course content
Module 1:
Statutory Compliance
EPF & ESI Filing
Profession Tax Filing
Income Tax & TDS Filing
Preparing FORM 24Q, FORM26Q
LWF Return Filing
Complete walk through on PF & ESI Portal
Complete walk-through TRACES
Corresponding Sheet Preparation & Maintenance
Different FORMs
Module 2:
ACTs
Payment of Wages Act
Payment of Bonus Act
Payment of Maternity Act
Payment of Gratuity Act
EPF & ESI Act
International Workers
Workmen Compensation Act
CLRA Act
Module 3:
Advance Excel
Application/ Scenario based training for followings
Mail Merge with TOGGLE Fields
Pivot Table
VLOOKUP
Data Validation
Charts
FORMULAS (How to use multiple functions in same formula to achieve particular task)
Providing deeper knowledge on FORMULAS
How to write complex FORMULAS like multiple nested IF ELSE, combining multiple function in single formula
Professional Sheet management using Buttons, Hyper Link & Objects
Error Validation & Data Validation through formulas
Taking complete control over excel sheet in order to avoid the manual error
Detailed walk through on Main Menus with lot of examples
Reverse engineering methods to work on certain existing files (From Non Excel Files)
50+ Formulas will be covered with detailed example