namrata.bhutani24
Hi Friends, Please advice any HR Training Institute in Delhi....and also pls tell SIS TRAINING CELL Noida is worth doing?
From India, Delhi
puerile131313
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.
From United Arab Emirates, Dubai
Hemant Singh
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.

From India, Delhi
mba.jaya
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

From India, Noida
mba.jaya
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

From India, Noida
Attached Files (Download Requires Membership)
File Type: jpg sis logo.JPG (67.8 KB, 8 views)

mba.jaya
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

From India, Noida
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.