Comprehensive Review of SIS Training Cell and HR Training Programs in Noida

Hi Friends,

Please advise on any HR Training Institute in Delhi, and also, please tell me if SIS TRAINING CELL in Noida is worth considering.

I also want to know about the SIS Training Cell in Noida. Is it worth joining? They are saying they will also provide 2-3 interviews at the end of the course. Has anyone done this course? Please reply.

I have received training from Asiawebmedia and am successfully working in an MNC in Delhi. I have gained valuable learnings and knowledge about HR functions' implementation in corporates, which you cannot learn through MBA colleges.

Asiawebmedia devotes 95% of its training to HR/accounts professionals and 5% based on the students' capabilities - how smartly he/she can apply that training in their careers and interviews. Asiawebmedia provides numerous interview opportunities to help you crack them and resolve any doubts or mistakes you might be making in your interviews; however, no one can guarantee placement - it's up to the students.

I would say it's a great opportunity for professionals looking to grow, learn, and stay competitive in the HR industry.

SIS Training Cell Pvt. Ltd.

SIS Training Cell Pvt. Ltd. specializes in providing training on HR generalist practical workshops, advanced Excel training, and payroll management training.

1. HR Training Content Details
Total hours: 50
Fees: 8500/-

Labour Law
Minimum Wages Act/Payment of Wages Act, Workmen Compensation Act/Maternity Benefit Act/Child Labour (Prohibition & Regulation) Act, 1986, Equal Remuneration Act, 1976/Industrial Disputes Act/Trade Union Act/Companies Act, Factory Act (process to take license registration half-year return).

HR Generalist Area
Manpower planning/end-to-end recruitment/joining formalities & relieving procedures/induction policy/training & development/ER management/attrition issues, formula & retention policy/employee engagement activities/HR jargon.

Core HR Audit Domain
ISO 9000/14000, Kaizen & 5S/PMS, competency mapping/frequently used terms/policy implementation/grievance handling procedure/benchmarking.

Statutory Compliance & Compensation
Provident Fund/ESI Act/Bonus Act/Gratuity Act/CTC designing, gross salary/net salary/leave policy/attendance sheets/income tax calculation/ITR file, Form 16/tax planning/designing salary slip/return file challan, half-yearly return, annual return file/professional tax.

Lab Session
Calculation of PF/ESI in Excel sheet/professional tax slab/formulas & shorthand keys/MIS report/VLOOKUP, HLOOKUP, pivot table, goal seek/job portal (bulk mailing, job posting, shortlisting resume), work on payroll software/IS reports, advanced Excel reports with shortcut keys and formulas, i.e., pivot table, goal seek, auto & advanced filters, VLOOKUP, splits and freeze panes used to prepare MIS reports.

2. Advance Excel Training
Total hours: 16
Fees: 4000/-

Number formatting - creating custom formats/the four parts of a format/scaling numbers.

Dates and times - how dates and times are stored/useful date/time functions/formatting dates and times.

Conditional formatting - creating/using cell rules/data bars and color sets/styles and themes - how themes work/using the default styles/creating custom styles.

Validation and protection - setting cell validation/protecting cells/worksheets/grouping and outlining cell comments.

Range names and absolute references - absolute references ($ symbol)/fixing only the row/column/creating range names/labelling ranges automatically.

If and lookup functions - the conditional (IF) function/nested IFs are evil/lookup tables.

Advanced lookup functions - using MATCH to find values/combining MATCH and INDEX/using OFFSET/the feared INDIRECT function/linking to other data/multiple worksheets/copying, moving, and renaming.

Basic Tables - table styles/using calculated columns/header rows and total rows/sorting and simple filtering/advanced tables/removing duplicates/advanced filters/creating table styles.

Pivot Table - creating pivot tables/swapping rows, columns, and pages/grouping fields drill-down/slicers - pivot table slicers/changing slicer properties.

Charts - selecting data/quick ways to create charts/formatting your chart/advanced charts/creating chart templates/combination charts/picture charts/custom chart types/regression and trendlines/sparklines - creating sparklines/changing chart types/formatting sparklines/consolidation.

Formulas - using arrays/using data consolidation/using pivot tables/recording macros/absolute/relative recording/where macros are stored/assigning macros to buttons.

3. Payroll Management Training
Total hours: 16
Fees: 4000/-

Employee master on roll/department master/designation master/earning & deduction/parameter file/leave setup/monthly leave record/mark attendance/salary processing on payroll/resigned/report - PF/ESI challan/salary register/overtime/advance register/salary sheet/salary slip/leave register/company setup/create a new company.

Income Tax - slab process/salary design/TDS calculation/Form 16/ITR form/balance sheet/tax saving/professional tax.

Office Address:
E-133, Sector-27, near Sab Mall, near Atta Market, nearest metro station Sector 18, Noida.
Contact Person: Malini Banerjee
Contact Numbers: 9958504877 / 9210956428

SIS Training Cell Pvt. Ltd.

Specializes in providing training on HR Generalist Practical Workshop, Advanced Excel Training, and Payroll Management Training.

1. HR Training Content Details
Total Hours: 50
Fees: 8500/-

Labour Law
- Minimum Wages Act/Payment of Wages Act
- Workmen Compensation Act/Maternity Benefit Act
- Child Labour (Prohibition & Regulation) Act, 1986
- Equal Remuneration Act, 1976
- Industrial Disputes Act/Trade Union Act
- Companies Act
- Factory Act (Process to take license registration half-year return)

HR Generalist Area
- Manpower Planning/End-to-End Recruitment
- Joining Formalities & Relieving Procedure
- Induction Policy
- Training & Development
- ER Management
- Attrition Issues, Formula & Retention Policy
- Employee Engagement Activities
- HR Jargon

Core HR Audit Domain
- ISO 9000/14000
- Kaizen & 5S
- PMS, Competency Mapping
- Frequently Used Terms
- Policy Implementation
- Grievance Handling Procedure
- Benchmarking

Statutory Compliance & Compensation
- Provident Fund/ESI Act/Bonus Act/Gratuity Act
- CTC Designing, Gross Salary, Net Salary
- Leave Policy, Attendance Sheets
- Income Tax Calculation/ITR File, Form 16
- Tax Planning, Designing Salary Slip
- Return File Challan, Half-Yearly Return, Annual Return File
- Professional Tax

Lab Session
- Calculation of PF/ESI in Excel Sheet
- Professional Tax Slab, Formulas & Shortcuts
- MIS Report
- VLOOKUP, HLOOKUP, Pivot Table, Goal Seek
- Job Portal (Bulk Mailing, Job Posting, Shortlisting Resume)
- Work on Payroll Software, IS Reports
- Advanced Excel Reports with Shortcut Keys and Formulas

2. Advance Excel Training
Total Hours: 16
Fees: 4000/-

- Number Formatting: Creating Custom Formats
- The Four Parts of a Format
- Scaling Numbers
- Dates and Times: How They Are Stored, Useful Functions
- Conditional Formatting: Creating Rules, Data Bars, Color Sets
- Styles and Themes
- Validation and Protection: Setting Cell Validation, Protecting Cells
- Range Names and Absolute References
- IF and LOOKUP Functions
- Advanced Lookup Functions
- Basic Tables and Pivot Tables

3. Payroll Management Training
Total Hours: 16
Fees: 4000/-

- Employee Master, Department Master, Designation Master
- Earning & Deduction Parameters
- Leave Setup, Monthly Leave Records
- Mark Attendance, Salary Processing on Payroll
- Resigned Employees
- Reports: PF/ESI Challan, Salary Register, Overtime, Advance Register, Salary Sheet, Salary Slip
- Leave Register, Company Setup

Office Address:
E-133, Sector-27, Near Sab Mall, Near Atta Market
Nearest Metro Station: Sector 18, Noida
Contact Person: Malini Banerjee
Phone: 9958504877 / 9210956428

SIS Training Cell Pvt. Ltd. is a specialized training provider focusing on HR Generalist Practical Workshop, Advanced Excel Training, and Payroll Management Training.

1. HR Training Content Details: Total hours - 50 Fees - 8500/-

Labour Law:
- Minimum Wages Act
- Payment of Wages Act
- Workmen Compensation Act
- Maternity Benefit Act
- Child Labour (Prohibition & Regulation) Act, 1986
- Equal Remuneration Act, 1976
- Industrial Disputes Act
- Trade Union Act
- Companies Act
- Factory Act (Process to take license registration, half-year return)

HR Generalist Area:
- Manpower Planning
- End-to-end Recruitment
- Joining Formalities & Relieving Procedure
- Induction Policy
- Training & Development
- ER Management
- Attrition Issues
- Formula & Retention Policy
- Employee Engagement Activities
- HR Jargon

Core HR Audit Domain:
- ISO 9000/14000
- Kaizen & 5S
- PMS
- Competency Mapping
- Frequently Used Terms
- Policy Implementation
- Grievance Handling Procedure
- Benchmarking

Statutory Compliance & Compensation:
- Provident Fund
- ESI Act
- Bonus Act
- Gratuity Act
- CTC Designing
- Gross Salary
- Net Salary
- Leave Policy
- Attendance Sheets
- Income Tax Calculation
- ITR File
- Form 16
- Tax Planning
- Designing Salary Slip
- Return File Challan
- Half-yearly Return
- Annual Return File
- Professional Tax

Lab Session:
- Calculation of PF/ESI in Excel sheet
- Professional Tax Slab
- Formulas & Shortcuts
- MIS Report
- VLOOKUP, HLOOKUP, Pivot Table
- Goal Seek
- Job Portal (Bulk Mailing, Job Posting, Shortlisting Resume)
- Work on Payroll Software
- IS Reports
- Advanced Excel Reports with Shortcut Keys and Formulas

2. Advanced Excel Training: Total hours - 16 Fees - 4000/-

Topics include number formatting, dates and times, conditional formatting, validation and protection, range names and absolute references, IF and lookup functions, advanced lookup functions, basic tables, pivot tables, charts, and formulas.

3. Payroll Management Training: Total hours - 16 Fees - 4000/-

Topics covered are employee master on roll, department master, designation master, earning & deduction, parameter file, leave set up, monthly leave record, mark attendance, salary processing on payroll, resigned employees, reporting, income tax processes, office address, and contact details.

Office Address: E-133, Sector-27, near Sab Mall, near Atta Market, nearest Metro Station Sector 18, Noida Contact Person: Malini Banerjee 9958504877 / 9210956428