Hemant Singh
Associate Consultant
+2 Others

PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Hi Friends, Please advice any HR Training Institute in Delhi....and also pls tell SIS TRAINING CELL Noida is worth doing?
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
I also want to know ab' the SIS Training Cel, noida. Is it worth joining, they r saying they will also provide with 2-3interviews at the end of the course. Has anyone done this course? Please reply.
I have got training from asiawebmedia & successfully working in a mnc in delhi. I gained a valuable learnings & knowledge about hr functions implementation into corporate which you can not learn through mba colleges.
Asiawebmedia devote 95% to train hr/ accounts professionals & 5% upto the student's capability, how smartly he/ she can use that training into his career & interviews.
Asiawebmedia provides u lots of interviews opportunities to crack & resolve your doubts & mistakes you are doing in your interviews, but nobody can give you guarantee to place, its upto the students.
I would say its a right opportunity for growing professionals to learn & be competitive in the limited hr industry.
sis training cell pvt. Ltd.

specialize training provider on hr generalist practical workshop /advance excel training /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 lisence registration half year return.



Hr generalist area

manpower planning/end 2 end recruitment/joining formalities & relieving procedure/ induction policy/training & development/ er management/attrition issues, formula & retention policy/ employee engagement activites/ hr jargon.



Core hr audit domain

iso 9000/ 14000, kaizen & 55/pms, competency maping/freuently used term/policy implementation/ grieviance 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/professinal tax.



Lab session

calculation pf/esi in excel sheet/professional tax slab/ formulas & short hand 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 which is 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 colour sets/styles and themes (*)howthemes work/ using the default styles/creating custom styles

validation and protection setting cell validation/protecting cells/worksheets/grouping and outliningcell 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 screating 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 set up/monthly leave record/mark attendance/salary processing on payroll/resigned/

report- pf / esi challan/ salary register/over time/ advance register/ salary sheet/salary slip/

leave register/company setup/ create new company

incometax:- slab process/salary design/tds calculation/form 16/itr form/balance sheet/tax saving/professinal tax/

office address:e-133, sector-27, near sab mall, near atta market, nearest metro station sector 18, noida contact person: Malini banerjee 9958504877/ 9210956428
Sis training cell pvt. Ltd.

Specialize training provider on hr generalist practical workshop /advance excel training /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 lisence registration half year return.



Hr generalist area

manpower planning/end 2 end recruitment/joining formalities & relieving procedure/ induction policy/training & development/ er management/attrition issues, formula & retention policy/ employee engagement activites/ hr jargon.



Core hr audit domain

iso 9000/ 14000, kaizen & 55/pms, competency maping/freuently used term/policy implementation/ grieviance 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/professinal tax.



Lab session

calculation pf/esi in excel sheet/professional tax slab/ formulas & short hand 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 which is 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 colour sets/styles and themes (*)howthemes work/ using the default styles/creating custom styles

validation and protection setting cell validation/protecting cells/worksheets/grouping and outliningcell 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 screating 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 set up/monthly leave record/mark attendance/salary processing on payroll/resigned/

report- pf / esi challan/ salary register/over time/ advance register/ salary sheet/salary slip/

leave register/company setup/ create new company

incometax:- slab process/salary design/tds calculation/form 16/itr form/balance sheet/tax saving/professinal tax/

office address:e-133, sector-27, near sab mall, near atta market, nearest metro station sector 18, noida contact person: Malini banerjee 9958504877/ 9210956428

Attached Images
Membership is required for download. Create An Account First
File Type: jpg sis logo.JPG (67.8 KB, 7 views)

Sis training cell pvt. Ltd.

Specialize training provider on hr generalist practical workshop /advance excel training /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 lisence registration half year return.

Hr generalist area

manpower planning/end 2 end recruitment/joining formalities & relieving procedure/ induction policy/training & development/ er management/attrition issues, formula & retention policy/ employee engagement activites/ hr jargon.

Core hr audit domain

iso 9000/ 14000, kaizen & 55/pms, competency maping/freuently used term/policy implementation/ grieviance 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/professinal tax.

Lab session

calculation pf/esi in excel sheet/professional tax slab/ formulas & short hand 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 which is 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 colour sets/styles and themes (*)howthemes work/ using the default styles/creating custom styles

validation and protection setting cell validation/protecting cells/worksheets/grouping and outliningcell 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 screating 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 set up/monthly leave record/mark attendance/salary processing on payroll/resigned/

report- pf / esi challan/ salary register/over time/ advance register/ salary sheet/salary slip/

leave register/company setup/ create new company

incometax:- slab process/salary design/tds calculation/form 16/itr form/balance sheet/tax saving/professinal tax/

office address:e-133, sector-27, near sab mall, near atta market, nearest metro station sector 18, noida contact person: Malini banerjee 9958504877/ 9210956428
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™