Uncategorized

Managerial effectiveness

It may give you happiness, but may not always be easy be a manager with staff reporting to you. Often you are promoted based on your current skills sets for a job well done and the expectation that you can perform equally well at the next higher level. You might only have seen managerial actions of others to guide you. Sometimes the transition is easy, but more often managers who now face the role of having to direct others and communicate with many different levels and departments can soon find themselves stretched.

This course is designed to help managers ‘fit the pieces together and see the bigger picture’. It is designed to develop the knowledge and skills in the manager necessary to manage and supervise staff to ensure the objectives of the organization are met, while developing the team and individuals to enhance their performance. This course will provide you with a thorough understanding of the principles of managerial excellence.

managerial-tab

6th & 7th August 2015 India Habitat CenterDetailsBrochure

Course Overview

It may give you happiness, but may not always be easy when you are promoted as a manager with staff reporting to you. Often you are promoted based on your current skills sets for a job well done and the expectation that you can perform equally well at the next higher level. You might only have seen managerial actions of others to guide you. Sometimes the transition is easy, but more often managers who now face the role of having to direct others and communicate with many different levels and departments can soon find themselves stretched.

This course is designed to help the first time manager ‘fit the pieces together and see the bigger picture’. It is designed to develop the knowledge and skills in the first time manager necessary to manage and supervise staff to ensure the objectives of the organization are met, while developing the team and individuals to enhance their performance. This course will provide you with a thorough understanding of the principles of managerial excellence.

Course Objectives

This intensive two-day course introduces the new manager to the fundamentals of the managerial role. It focuses on

the essential skills of time management, people resource management, leadership skills, performance and change
management.

At the end of the program, each participant will be able to:

• set clear targets for themselves and the team

• communicate with more clarity

• manage workplace behavior

• inspire others to give their best

• give and receive constructive feedback

• manage conflict situations

• prioritize tasks

• delegate tasks

• adapt to change

• lead the team with more effectiveness and confidence
The Course will cover

• The Roles of a Manager

• The Attributes of a Successful Manager

• The Need for Change

• Leading People and Building Teams

• Managing Conflicts in a Team

• Positive Ways to Inspire and Lead

• Communicating Effectively

• Feedback and Performance Appraisal

• Managing Meetings and Managing Time

• Managing Behaviors at the Workplace

• Recap and Conclusion

Who should attend

This Course is ideal for people who have just been promoted

— or are about to be promoted

— to their first front-line management position.

No formal prior management training is necessary.

Training Methodology

This Course will be highly participative with the participants doing exercises under the guidance of the course leader. The training method follows this general pattern:

• Trainer presentation

• Demonstration of the principles through specific examples

• Training exercises

• Syndicate work

• Skill practice/Role play

• Group discussion

• Supported with full written notes to take away

• Action planning by participants to implement back at their workplace

• Management Games

Meet The Faculity

Prof. Veena Kumar

She is a renowned Management Consultant, having 30 years of experience in Corporate Training, Research, Management Education, Consultancy and hiring solutions. She specializes in conceptualizing and executing Customer/Channel/ Employee Satisfaction Surveys developing a CSI, Marketing/Distribution Effectiveness Mapping, and Consumer Behavior & Brand Mapping. Her Consultancy projects include Strategies for future growth, Organizational Effectiveness Audit, Marketing & Branding strategies and a host of Marketing & HR Interventions.
As a corporate trainer, she has been handling experiential training workshops for both Behavioral as well as Sales & Marketing areas for senior, middle & cutting edge level as well.Her interventions have benefited various organizations all over the country. A Post Graduate in Management from Punjab University, Chandigarh, she holds a dual specialization in Marketing and HRD.

She is engaged in conducting training workshops in the Sales and Marketing as well as Behavioral disciplines for organizations like Map My India, Cowi India ,Teri, HCL Technologies Ltd., Cyber Media India Ltd, The Lodhi Hotel , Jabra Innova, HCL Infosystems Ltd., Oberoi Group Of Hotels, , JK Organisation etc

Teaching Experience
She has a very rich teaching experience as a Visiting Faculty to prestigious Management Institutes of Delhi including FMS Delhi University, Infinity Business School, IMT (Both Ghaziabad & Delhi Chapter ) FORE, NDIM, IIPM etc.
She also happens to be a member of the Academic Council of NDIM New Delhi.
She is also an approved faculty for University of Bradford, UK conducting their Management courses in India. She has been teaching a variety of papers in the field of Marketing and getting a consistent feedback of 9+ on a 10 point scale. She has also been a guide since many years for the final year management students working on their dissertations.

Timing of the Course

On Day 1 registration is between 9.00-9.30 am and the training begins at 9.30 am finishing at 5.30 pm.

On the second day training begins at 9.30 am finishing at 5.30 pm.

Registration Fees

One participant Rs.12,000/- Plus Service Tax. which includes lunch, tea, course material etc for Two Days.
For two or more participant from the same organization Rs.11,500/- Plus Service Tax per participant.

Workshop Date/Venue

6th & 7th August 2015 At India Habitat Centre, Lodhi Road, New Delhi 110003

Registration Procedure

1. Please send confirmation with your Full name ,mobile number, email-id through mail before 4th August 2015.

2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.

3. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Coordinator Ms Mohini Email : mohini@strategichrandtraining.com / strategichrandtraining@gmail.com
Seats are confirmed only after receipt of payment.

Please Send the Cheque to our office address D-321 Sector 10 Noida UP 201301

4. Early registration will be appreciated

Contact Persons : Ms. Mohini Tyagi
phone Ph: 0120 4221708, 9971114253
Uncategorized

Labour Law

There are number of labour laws applicable to run a business organisation. Therefore each organisation needs to know about them, so that they can be complied with. In case of any failure, ignorance of law will not be acceptable. In the modern times, all corporate organisations therefore make every effort to ensure that all labour laws as applicable to their kind of organisation

labour_25-August

25th August 2015 India Habitat CenterDetailsBrochure

Course Overview

There are number of labour laws applicable to run a business organisation. Therefore each organisation needs to know about them, so that they can be complied with. In case of any failure, ignorance of law will not be acceptable. In the modern times, all corporate organisations therefore make every effort to ensure that all labour laws as applicable to their kind of organisation where they are complied with.

Moreover the programme allows you to catch up on all developments in this filed with value for all those who need to stay on top of this area of law. It helps in creating a healthy work culture in organisation with employers and employees. With the objective of making the corporate managers aware about the most important of such laws and their broad provisions, the programme has been organised

Course Objectives

1. The Employees Provident Fund Act 1952 & Pension Scheme 1995.
2. The Employees State Insurance Scheme (ESIC) 1948.

3. The Contract Labour Act, 1970.

4. The Payment of Bonus Act 1948.

5. The Payment of Gratuity Act, 1972.

6. The Employee’s Compensation Act, 1923.

7. The Payment of Wages Act, 1936.

8. The Maternity Benefit Act, 1961.

The programe will cover the following aspects for above acts:

• Coverage & applicability

• Important highlights

• Compliance aspects

• Care to be taken by the employer to avoid penal consequences

• Important judicial pronouncements

• Practical issues in day to day compliance.

Take Away’s

• Contract Labour Act / PF / ESIC: – Procedure for Registration, obtaining Labour License & obtain Code Number

• Contract Employees: – Bonus; Gratuity; Retrenchment Compensation payable by whom.

• ESI, PF & Contract Labour Act are applicable to whom and their registration procedure

• Unemployment benefit – payable under the ESI Act.

• ESI Covered Employees after retirement – whether they are coverable under the Act.

• Practice, procedure and other areas of interest under PF, ESI, Employees Compensation Act.

• Calculation and Forfeiture of Gratuity and Bonus.

• Calculation of compensation Employment injury under Employees Compensation Act.

• What is the maximum limit under the Gratuity Act, for which Income tax exemption can be claimed?

• Whether voluntary coverage is possible under ESI & PF.

• Excluded Employee under Provident Fund.

• Under Employees Deposit Linked Insurance Scheme under PF what is maximum amount payable?

• Permissible deductions under the payment of wages act.

• ESI & PF payment has to be made before which date.

• When female employee is entitled for the maternity benefit and when it can be forfeited.

• Whether monthly Bonus is payable under the Bonus Act.

• What is maximum Amount payable under the Payment of Bonus Act?

• Who are not entitled for bonus under the payment of Bonus Act?

• What is salary / wages (Basic + D.A) limit and on what amount Bonus is calculated.

• Minimum number of attendance required for eligibility of bonus.

• Is there limit for ex-gratia payment?

• Whether ESIC Act is Applicable after attaining the 60 years of age.

• What is the magic salary / wages of Rs. 6500/- (Basic + D.A) under Provident Fund Act.

• Maternity Benefit Act is applicable to which establishment / factory.

• Whether annual return under Maternity Benefit Act has to be filed.

• If Gross Salary is Rs. 8500/- and Basic Salary is Less than Minimum Wages; then on which salary PF should be deducted.

Who should attend

• Corporate (Manufacturing, Trading and Service Industry)

• HR Personnel and Pay Roll Processing Personnel

• Admin and Finance Department Personnel

• Traders and Businessmen

• Labour Law Practioners

• Salary Department

• Labour Law Compliance Personnel

• Chartered Accountant, Company Secretary, Cost Accountant,

• Advocates, Chartered Financial Analyst

Contact

Contact Us Ms. Mohini Tyagi

Call 0120 4221708, 0120 4221702

Email mohini@strategichrandtraining.com

strategichrandtraining@gmail.com

Timing of the Course

Registration is between 9.00-9.30 am and the training begins at 9.30 am finishing at 5.30 pm on 25 August 2015 at Willow Hall India habitat Center.

Registration Fees

1 Participant Rs. 6,000 + Service Tax
3 or More Participants From Same Organisation Rs. 5,500 + Service Tax Per Participant

Registration Procedure

1. Please send confirmation with your Full name ,mobile number,email-id through mail before 21 August 2015
2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.
3. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Cordinator Ms Mohini Tyagi Seats are confirmed only after receipt of payment.
Please Send the Cheques to our office address D-321 Sector 10 Noida UP 201301
4. Early registration will be appreciated

Contact Persons : Ms. Mohini Tyagi
phone Ph: 0120 4221708, 9971114253
Uncategorized

Strategic Negotiation Influencing Skills

Develop your Negotiating Powers and Become an Outstanding Negotiator
(Strategic negotiations with vendors, contractors, negotiators & customers)

Influence-25-August-

26th & 27th August 2015 India Habitat CenterDetailsBrochure

Course Overview

Negotiation is a key work and life skill. Negotiation takes place with outside companies and customers, as well as internally within departments or project teams. 90% of all negotiations take place before the involved parties even get to the bargaining table. Getting better results in terms of timelines, price or quality, all contribute to bottom line profitability. Most people think of negotiations as competitive contests where one persons gain is another’s loss – a more cooperative, creative agreement is rarely achieved.

The workshop focuses on developing more collaborative outcomes in the wide variety of negotiations that we participate in every business day. This workshop is designed to groom potential and prospective future negotiators and will equip them with the attitudinal imperatives to clinch a successful deal

The 2 day workshop will provide an opportunity to understand and enhance your negotiation skills while benefiting from direct feedback. During the session, participants will have the opportunity to understand the negotiation process itself – getting the best results using a collaborative negotiation style. Our discussion will also focus on how different strategic choices and interpersonal skills drive success at the bargaining table.

These skills will help learn the structure underlying all negotiations. The workshop is packed with real life situations for role plays where participants will understand how to deploy relevant strategies, appropriate techniques, and interest sustaining tactics based on hands on experience.

Salient Features
• Experiential Methodology with live case situations and the role plays.

• Very rich content with multiple perspectives.

• Personal attention to each participant.

Course Objectives

The workshop will enable the participants to :

• Diagnose the underlying negotiation and influencing process

• Deal with tough customers.

• Successfully close the sales

• Identify, value, and strengthen their existing competencies around negotiation and influencing.

• Broaden their interpersonal and influencing skills

• Help them break deadlocks creatively

• Structure and use language to gain cooperation

• Lock-in commitment to lasting agreements

• Prepare more systematically to their advantage

• Generate strategic options

Key Takeaways & Learning Outcomes

• Learn the structure underlying all negotiations

• Identify appropriate skills and when to use them for negotiations

• Achieve a measurable improvement in performance

• Negotiate your way out of conflict

• Use active listening techniques to pick up signals Before too long

• Make, pitch and respond to proposals you’ll find

• Assess concessions and analyze priorities yourself making

• Defuse aggression and confrontation

• Handle deadlocks

• Identifying win-win agreements – expanding the pie.

• Developing the skill of asking questions

• Build partnership relationships with clients or suppliers

• Learn the secrets of win/win decision

• Conventional Vs Principled Negotiation

• Understanding the 4Ds of Negotiation .

• Dealing with difficult tactics.

Workshop Date/Venue

26th & 27th August 2015 At Deck Suite (5th Floor) India Habitat Centre, Lodhi Road, New Delhi 110003

Who should attend

This Programme has been specifically designed for Junior, Middle or Senior level Managers irrespective of their functions, designation, position and business involvement – be it in private/public sector organisations, multinational companies or government organisations who want to maximise ability to negotiate more effectively and build stronger, longer-lasting relationships with clients, colleagues, suppliers and others..

Methodology

The entire approach for covering the focus areas would be semi-structured in nature wherein effort would be on co-creation. The participation of the trainees will become the subject matter for discussion and analysis. However, the faculty and her associate would provide structured inputs for learning and reinforcement purposes.

The deliverance would include:

1. Structured Inputs

2. Customized training booklet acting both as a reference material and a learning diary.

3. Videos

4. Experiential Exercises

5. Self-Assessment Questionnaires

6. Business Games

7. Role plays (video recorded and played back)

8. Group Exercises

9. Situation based case lets


Timing of the Course

On Day 1 registration is between 9.00-9.30 am and the training begins at 9.30 am finishing at 5.30 pm.

On the second day training begins at 9.30 am finishing at 5.30 pm.

Registration Fees

One participant Rs.12,000/- Plus Service Tax. which includes lunch, tea, course material etc for Two Days.

For two or more participant from the same organization Rs.11,500/- Plus Service Tax per participant.

Registration Procedure

1. Please send confirmation with your Full name ,mobile number, email-id through mail before 21 August 2015.

2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.

3. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Coordinator Ms Mohini Tyagi Email : mohini@strategichrandtraining.com / strategichrandtraining@gmail.com

Seats are confirmed only after receipt of payment.

Please Send the Cheques to our office address D-321 Sector 10 Noida UP 201301
4. Early registration will be appreciated

Contact Persons : Ms. Mohini Tyagi
phone Ph: 0120 4221708, 9971114253
Uncategorized

Competency Mapping and Interviewing Skills 9 April 2015

Human capital is labeled as an invaluable asset of an organization. Right fit of people with their roles (based on Competency requirements) alone can make tangible, visible and valuable contribution to the top-line and bottom-line.
Competencies now lie at the heart of most organizations’

Competency-Mapping

9 April 2015India Habitat Center

Course Objectives

Human capital is labeled as an invaluable asset of an organization. Right fit of people with their roles (based on Competency requirements) alone can make tangible, visible and valuable contribution to the top-line and bottom-line.
Competencies now lie at the heart of most organizations’ recruitment and development activities. Recruitment can be a very costly activity, so it is important to get it right the first time. The biggest challenge with recruitment process is not the unavailability of skilled people; it’s our inability to map right people for the right job. Anyone involved in the recruitment or staff selection process will find this a very useful course packed with practical skills and tools to help you recruit successfully.
This capsule provides the skills, knowledge and the process to define, develop and map competencies and then using competency based interviewing techniques in order to select and recruit the right person for the job whilst ensuring a fair and transparent process.
Competency Mapping And Interviewing skills will focus on how to develop, define and measure competencies and select the candidates who are the most competent or have the potential to be so.
This workshop will equip you with the tools and techniques to conduct effective competency based interviews, enhancing your ability to select the right people for the right roles in the best possible manner

Objectives

Through the workshop, participants will learn how to:

• Define, develop and map competencies.

• Identify various types of competency descriptors.

• Manage the process of competency identification.

• Conduct structured and effective interviews utilizing the competencies relevant to a job role

• Ensure higher productivity with right people fit on right jobs

• Improve employee retention and minimize cost of recruitment

• Systematically evaluate information from a competency based interview.

Course Overview

The current program is designed to be conducted in a workshop style offering participants an opportunity to cognitively understand behavioral & competency framework and also use it for selection interviews.

Participants will get a first-hand experience of developing various competencies, and designing appropriate questions for ascertaining competencies by conducting mock selection interviews in a simulated environment during the workshop.

Who should attend

• Business and Operations Managers –engaged in selection interviews

• Project Managers-responsible for building and ensuring high productivity from teams

• HR Manager and Recruiters, Recruitment consultants

Training Methodology

The entire approach for covering the focus areas would be semi-structured in nature wherein effort would be on co-creation. The participation of the trainees will become the subject matter for discussion and analysis. However, the faculty and her associate would provide structured inputs for learning and reinforcement purposes.

A number of simulation exercises and role-plays will be designed for the trainees.

The program design would include:

• Structured Inputs

• Customized training booklet acting both as a reference material and a learning diary

• Video

• Experiential Exercises

• Self-Assessment Questionnaires

• Business Games

• Role plays & mock interviews (video recorded and played back

Workshop Contents

Session I

Competency Framework

• Concept of competencies, competency frameworks and how they benefit the organization and their people.

o Job description Vs Competencies

o Managerial vs functional competencies

o Competency Identification Process

o Multiple Competency descriptors

Session II

• Competency mapping and measurement

• Positioning of Competency Based Interviewing

• Position description and Competency definition

Session III

Structuring competency based interviews

o Interviewing Process,

o Interview Decision making model

o Limitations of an interview

o Time and structure needed to explore each competency

Session IV

Behavioral Event Interview – questioning & listening skills

o Detailed Behavioral descriptors

o Framing questions based on Competencies

o How to field questions & probe for BEI?

o L imitations and Challenges of a BEI

o Handling candidate responses to questions

o Observing candidate behaviours, recording and summarising the responses
Session V Conducting a competency based interview

o Practicing skills of interviewer, note taker and observer

o Mock-Role plays – Interviews based on BEI

o Video Replay and Feedback

Session VI

Making the selection decision

o Evaluating and rating evidence

o Using a rating scale

o Recommending the next stage in the selection process

o Review and evaluation of candidates responses

o Assigning a rating and recommendations

o Closing an Interview

o Review and next steps

– Applying the learning

– Individual exercise and group review

– Action plan for learning implementation.

Timing of the Course

On 7th May 2015 registration is between 9.00-9.30 am and the training begins at 9.30 am finishing at 5.30 pm for Both the days.

Registration Procedure

1. Please send confirmation with your Full name ,mobile number,email-id through mail before 05 May 2015

2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.

3. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Cordinator Ms Mohini Tyagi
Seats are confirmed only after receipt of payment.
Please Send the Cheques to our office address D-321 Sector 10 Noida UP 201301

4. Early registration will be appreciated

Contact Persons : Ms. Mohini Tyagi
phone Ph: 0120 4221708, 9971114253
Uncategorized

Excelling As A Manager 16 April 2015

It may give you happiness, but may not always be easy be a manager with staff reporting to you. Often you are promoted based on your current skills sets for a job well done and the expectation that you can perform equally well at the next higher level. You might only have seen managerial actions of others to guide you. Sometimes the transition is easy, but more often managers who now face the role of having to direct others and communicate with many different levels and departments can soon find themselves stretched.

This course is designed to help managers ‘fit the pieces together and see the bigger picture’. It is designed to develop the knowledge and skills in the manager necessary to manage and supervise staff to ensure the objectives of the organization are met, while developing the team and individuals to enhance their performance. This course will provide you with a thorough understanding of the principles of managerial excellence.

excelling-first-time-managers

16th & 17th May 2015 India Habitat Center

Course Overview

It may give you happiness, but may not always be easy when you are promoted as a manager with staff reporting to you. Often you are promoted based on your current skills sets for a job well done and the expectation that you can perform equally well at the next higher level. You might only have seen managerial actions of others to guide you. Sometimes the transition is easy, but more often managers who now face the role of having to direct others and communicate with many different levels and departments can soon find themselves stretched.

This course is designed to help the first time manager ‘fit the pieces together and see the bigger picture’. It is designed to develop the knowledge and skills in the first time manager necessary to manage and supervise staff to ensure the objectives of the organization are met, while developing the team and individuals to enhance their performance. This course will provide you with a thorough understanding of the principles of managerial excellence.

Course Objectives

This intensive two-day course introduces the new manager to the fundamentals of the managerial role. It focuses on

the essential skills of time management, people resource management, leadership skills, performance and change
management.

At the end of the program, each participant will be able to:

• set clear targets for themselves and the team

• communicate with more clarity

• manage workplace behavior

• inspire others to give their best

• give and receive constructive feedback

• manage conflict situations

• prioritize tasks

• delegate tasks

• adapt to change

• lead the team with more effectiveness and confidence
The Course will cover

• The Roles of a Manager

• The Attributes of a Successful Manager

• The Need for Change

• Leading People and Building Teams

• Managing Conflicts in a Team

• Positive Ways to Inspire and Lead

• Communicating Effectively

• Feedback and Performance Appraisal

• Managing Meetings and Managing Time

• Managing Behaviors at the Workplace

• Recap and Conclusion

Who should attend

This Course is ideal for people who have just been promoted

— or are about to be promoted

— to their first front-line management position.

No formal prior management training is necessary.

Training Methodology

This Course will be highly participative with the participants doing exercises under the guidance of the course leader. The training method follows this general pattern:

• Trainer presentation

• Demonstration of the principles through specific examples

• Training exercises

• Syndicate work

• Skill practice/Role play

• Group discussion

• Supported with full written notes to take away

• Action planning by participants to implement back at their workplace

• Management Games

Meet The Faculity

Dr. BRINDA BALAKRISHNAN

An HR professional, with over 16 years of experience in SAIL and 12 years consulting/training /teaching as a freelancer; with an academic background in Economics. Currently engaged in teaching as visiting/adjunct faculty in HR/OB areas; research and consulting in Competency Mapping & Assessment Centers, Manpower Planning and Organization design, developing HR policies and Personnel Manual including designing compensation structures; corporate training in soft skills; and in facilitating NGO’s in social entrepreneurship by designing interventions integrating conventional HRD with OD approaches for capacity building.

WORK EXPERIENCE:

Over 16 years’ in HR in SAIL, having opted for Voluntary retirement as DGM (HR). Consequent to my VR, I was Director (HR & Fund Raising) at Spastics Society of Northern India (now AADI) and presently freelancing with training, consultancy, teaching assignments and supporting NGO’s. I am currently a Director on the Board of ARUNIM, an affiliate of National Trust of India.

AREAS OF EXPERTISE:

• Organization Development through HR interventions-strategies, structure, policies and culture building

• Capacity Building and Talent Management using Competency Mapping and Assessment centers

• MIS –monitoring, evaluation and control tools to facilitate operational zing strategic plans and assessing
gaps in the actions taken and the implementation results.

• Developing Social Entrepreneurship projects –creating business models and plans incorporating
financials and human resources to make it self- sustainable.

• Training in managerial tools and techniques for organizational effectiveness.

• Development and use of psychological tests and psychometric instruments

CONSULTING

i. Central Bank of India -Conduced Assessment centers and Competency Mapping for the senior managerial cadre (chief managers and above-350) of in addition to creating Job descriptions, identifying training needs , developing training modules and recommending changes in Performance Appraisal.

ii. Assessment Center for IHHR (ANANDA_ISTA group of hotels).

iii. Moser Baer-Developed HR policies and the Organization structure with Job descriptions and reviewed the compensation structure on the basis of Job worth.

iv. IIPL Ltd- Developed MIS for manpower planning and HR Strategies for this Software Company-

v. Developed OD interventions/HR strategies for Muthoot Group-Northern Region,

vi. Created on the spot electronically processed psychometric tests for selection of sales personnel for Tata Motors distribution outlets.

vii. Developed personnel manual and sorted out the structural anomalies in the salary structure based on assessment of role job fit , redesigned compensation structure for both managerial and non-managerial staff for Jewanram Sheoduttrai group in Kolkatta

TEACHING:

Courses taught include: OB, OD & Change, Organisation Structure & Design, Manpower Planning, HRM, Competency Mapping, Performance & Compensation Management, Industrial Relations & Labour Laws, Work Psychology, Group Dynamics, Counseling Skills for Managers, Cross Cultural Management, QT, Business Research, and Business Communication. Institutes taught include: FORE, BIMTEC, ICFAI, AIMA, IILM, ITM, SCIR, IIPM, JIMS, IAMR and YMCA. Teaching 2 LSE (London School of Economics) UG courses (BSc in Eco & Management) at ITM- Org Theory and HRM

Training- Conducted training programs on ‘Negotiation Skills’,’Counselling & Mentoring’, ‘Disciplinary Action & Proceedings’, ‘HR for Line Managers’, ‘Training of Trainers’ and “Team Building”. OD workshops for IIPL on development of Vision, Mission, Strategies and Goals, Communication and Team working. Conducted a training program on Labour Law Implementation strategies in association with Gurgaon Management Association,Conducted training sessions and given lectures for KATHA using the Indian Short Stories as Case studies on Management Concepts for IIFT students, Entrepreneurial training workshops at the Katha School of Entrepreneurial School of Management. Invited for training sessions by PSU’s viz NTPC, KRIBHCO, PEC etc. Have been on the Interview Board for Recruitment in some private Companies on turnkey basis
Corporate Clients include: UTCS (Union Territory Civil Services) training college, IIFCO-Tokio, IOCL, Kribhco, Maruti Udyog, MMTC, NTPC, NHPC, ONGC, Central Bank of India Quipo , Fire Capital, Sudhir Gensets, TERI, CSIR, Carl Zeiss, IHHR and Fire Capital.

Research /Publications- Team Building: The Dynamics within, Compensation strategies, Published articles include: Development & Growth: A Human competence perspective, Innovations & Creativity-nurturing in Management, Organizational Goals & its linkage to Strategies, Structures and Systems, HRM in NGO’s- is it different? Training and Developmental needs for managers in NGO’s, ‘Social entrepreneurship’, ‘Retention- A Behavioral Perspective’.

Timing of the Course

On Day 1 registration is between 9.00-9.30 am and the training begins at 9.30 am finishing at 5.30 pm.

On the second day training begins at 9.30 am finishing at 5.30 pm.

Registration Fees

One participant Rs.12,000/- Plus Service Tax. which includes lunch, tea, course material etc for Two Days.
For two or more participant from the same organization Rs.11,500/- Plus Service Tax per participant.

Workshop Date/Venue

27th & 28th May 2015 At India Habitat Centre, Lodhi Road, New Delhi 110003

Registration Procedure

1. Please send confirmation with your Full name ,mobile number, email-id through mail before 25 May 2015.

2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.

3. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Coordinator Ms Mohini Email : mohini@strategichrandtraining.com / strategichrandtraining@gmail.com
Seats are confirmed only after receipt of payment.

Please Send the Cheque to our office address D-321 Sector 10 Noida UP 201301

4. Early registration will be appreciated

Contact Persons : Ms. Mohini Tyagi
phone Ph: 0120 4221708, 9971114253
Uncategorized

Advance MS Excel 15 May 2015

This program is designed for executives who want to build on Microsoft Excel skills. This course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing.Getting Excel to make decisions using the ‘If’ function and conditional formatting, You’ll learn how to create templates for commonly used worksheets. This course will also enable you to create, build and customise graphs.

Ms-B

15 May 2015India Habitat Center

Course Overview

This program is designed for executives who want to build on Microsoft Excel skills. This course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing.Getting Excel to make decisions using the ‘If’ function and conditional formatting, You’ll learn how to create templates for commonly used worksheets. This course will also enable you to create, build and customise graphs.

In this workshop you will also explore with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Course Objectives

Excel Basics

Moving About the Workbook
Simple Data Entry and Selecting Ranges
Saving Workbook Formats
Copying & Filling
Using Fill for Quick Copying and Copying Cell(s) to One/Many Cells & Worksheets
Editing Data

Overwriting and Editing Cell Contents, Editing Formulae or Functions or Using Undo/Redo/Search & Replace

Adjusting a Worksheet
Basics like Inserting/Deleting Cells/Inserting/Deleting/Resizing Rows/Columns
Copying/Moving/Renaming Worksheet(s)
Inserting/Deleting/Grouping Worksheets
Hiding & Unhiding Worksheets

Formulae & Working with Functions

Formulae that Add/Subtract/Multiply/Divide
BODMAS/Formula Error Checking
The Sum Function
Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions
Paste Special to Copy Formulae/Formats/Validations • Paste Special to Add/Multiple & Transpose

Formatting in Excel

• Formatting Numbers/Dates/Currency
• Formatting for Effect Bolding/ Italics/ Underling
• Cell/Background Colours
• Cell Alignment

Working and Viewing Worksheets

Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
Define Names & Lables
Creating/Deleting Labels/ Names • Creating/Using Names in Formulas/ Across Workbooks

Working with advance Functions

Writing conditional expressions (using IF)
Using nested IFs
Using logical functions (AND, OR & NOT)
Using lookup and reference functions (VLOOKUP & HLOOKUP)
Limitation of Vlookup and how to avoid it by using INDEX &INDEX

Data Validation

Creating Input Messages and Error Alerts
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Creating list based on other sheet data(new features of Excel 2007/2010)
Specifying custom validations based on formula for a cell
Conditional Formating

Sorting and Filtering Data

Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
Using advanced filter options
Extracting/removing duplicate record from database

Working with professional Reports

Creating subtotals
Multiple-level subtotals
Creating Pivot tables
Using Slicer in Pivot table(new features)
Using advance options in Pivot table(with new features of Excel 2007/2010)
Formatting and customizing Pivot tables
Using advanced options of Pivot tables
Pivot charts
Consolidating data from multiple sheets and files using Pivot tables
Using external data sources

Working with PowerPivot(new features in Excel 2007/2010)

Introducing PowerPivot feature in Excel
Importing backend data
Using validation while importing data
Importing Excel data
Working with 64bit OS
Working with huge no of Rows

More Functions

Date and time functions(TODAY, NOW, YEAR, MONTH, DAY & DATEDIF)
Text functions(TEXT, LEFT, RIGHT, MID & CONCATENATE etc)
Statistical function(COUNT, COUNTA, COUNTBLANK & COUNTIF)

Working with Styles & Formatting

Cell Styles
Creating lists using Table
Formatting the structure of a list
Conditional Formatting
Using formula/function in Conditional Formatting
Using large no of icons and bars in Conditional Formatting(new features in Excel 2007/2010)

What-If Analysis using Financial Function (PMT,PPMT & IPMT)

Using goal seek
Using data tables
Creating and editing scenarios

Working with Charts and Templates

Inserting Chart
Playing with different options and different type of chart
Using Sparklines, i.e. inserting chart in single cell(new features of Excel 2010)
Creating Templates in Excel

Who should attend

This Microsoft Excel training course has been developed for executives /Managers working in organisations wanting to use more complex functions within MS Excel.

Timing of the Course

On Day 1 registration is between 9.15-9.25 am and the training begins at 9.30 am finishing at 5.30 pm.

Meet The Faculty

Ms Madhu Bahl

Some people are borne to teach as it’s their DNA – a desire to teach what they know with a larger audience and Madhu Bahl exemplifies the same. She has a tenacious commitment and passion to train/teach.Madhu is an accomplished and seasoned professional who after completing her Engineering degree in Electronics and Telecommunications has been in the Teaching profession as a Corporate Trainer as well as Visiting faculty to students in various MBA institutes. Successfully developed skills in understanding, designing, implementing and training on various systems with good understanding of the customer needs.

She brings 22 years of progressive teaching experience and has expertise in the IT and related subjects.

She has taught and trained in IT related courses to a wide range of corporate audience. As a Corporate trainer she has trained at NTPC, SAIL, Aricent, Vanderlande Ayurvet Shoppers Stop to name a few.

As a Trainer and Training Consultant she has been associated with Corporates and Training Companies like NIIT ,Strategic Hr and Training and Various Polytechnics.

She is a visiting faculty at management campuses like IIPM, ICFP, NBA, WLC, IWSB, ASKIME, MAII.

She was adjudged Best lecturer by Multiple Reputed Management institutes on for the year 2009/10.

Registration Fees

One participant Rs.6,000/- Plus Service Tax. which includes lunch, tea, course material etc for One Day.

For Three or more participant from the same organization Rs. 5,500 + Service Tax.

(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Workshop Date/Venue

15th May 2015 At India Habitat Centre,Lodhi Road,New Delhi 110003.

(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Registration Procedure

1. Please send confirmation with your Full name ,mobile number,email-id through mail before 24th July 2015.

2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.

3. It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.

4. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Coordinator Ms Roquia Siddiqui

Seats are confirmed only after receipt of payment.

Please Send the Cheques to our office address D-321 Sector 10 Noida UP 201301
5. Early registration will be appreciated
(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Uncategorized

Advance MS Excel 24 April 2015

This program is designed for executives who want to build on Microsoft Excel skills. This course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing.Getting Excel to make decisions using the ‘If’ function and conditional formatting, You’ll learn how to create templates for commonly used worksheets. This course will also enable you to create, build and customise graphs.

Ms-B

24 April 2015India Habitat Center

Course Overview

This program is designed for executives who want to build on Microsoft Excel skills. This course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing.Getting Excel to make decisions using the ‘If’ function and conditional formatting, You’ll learn how to create templates for commonly used worksheets. This course will also enable you to create, build and customise graphs.

In this workshop you will also explore with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Course Objectives

Excel Basics

Moving About the Workbook
Simple Data Entry and Selecting Ranges
Saving Workbook Formats
Copying & Filling
Using Fill for Quick Copying and Copying Cell(s) to One/Many Cells & Worksheets
Editing Data

Overwriting and Editing Cell Contents, Editing Formulae or Functions or Using Undo/Redo/Search & Replace

Adjusting a Worksheet
Basics like Inserting/Deleting Cells/Inserting/Deleting/Resizing Rows/Columns
Copying/Moving/Renaming Worksheet(s)
Inserting/Deleting/Grouping Worksheets
Hiding & Unhiding Worksheets

Formulae & Working with Functions

Formulae that Add/Subtract/Multiply/Divide
BODMAS/Formula Error Checking
The Sum Function
Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions
Paste Special to Copy Formulae/Formats/Validations • Paste Special to Add/Multiple & Transpose

Formatting in Excel

• Formatting Numbers/Dates/Currency
• Formatting for Effect Bolding/ Italics/ Underling
• Cell/Background Colours
• Cell Alignment

Working and Viewing Worksheets

Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
Define Names & Lables
Creating/Deleting Labels/ Names • Creating/Using Names in Formulas/ Across Workbooks

Working with advance Functions

Writing conditional expressions (using IF)
Using nested IFs
Using logical functions (AND, OR & NOT)
Using lookup and reference functions (VLOOKUP & HLOOKUP)
Limitation of Vlookup and how to avoid it by using INDEX &INDEX

Data Validation

Creating Input Messages and Error Alerts
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Creating list based on other sheet data(new features of Excel 2007/2010)
Specifying custom validations based on formula for a cell
Conditional Formating

Sorting and Filtering Data

Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
Using advanced filter options
Extracting/removing duplicate record from database

Working with professional Reports

Creating subtotals
Multiple-level subtotals
Creating Pivot tables
Using Slicer in Pivot table(new features)
Using advance options in Pivot table(with new features of Excel 2007/2010)
Formatting and customizing Pivot tables
Using advanced options of Pivot tables
Pivot charts
Consolidating data from multiple sheets and files using Pivot tables
Using external data sources

Working with PowerPivot(new features in Excel 2007/2010)

Introducing PowerPivot feature in Excel
Importing backend data
Using validation while importing data
Importing Excel data
Working with 64bit OS
Working with huge no of Rows

More Functions

Date and time functions(TODAY, NOW, YEAR, MONTH, DAY & DATEDIF)
Text functions(TEXT, LEFT, RIGHT, MID & CONCATENATE etc)
Statistical function(COUNT, COUNTA, COUNTBLANK & COUNTIF)

Working with Styles & Formatting

Cell Styles
Creating lists using Table
Formatting the structure of a list
Conditional Formatting
Using formula/function in Conditional Formatting
Using large no of icons and bars in Conditional Formatting(new features in Excel 2007/2010)

What-If Analysis using Financial Function (PMT,PPMT & IPMT)

Using goal seek
Using data tables
Creating and editing scenarios

Working with Charts and Templates

Inserting Chart
Playing with different options and different type of chart
Using Sparklines, i.e. inserting chart in single cell(new features of Excel 2010)
Creating Templates in Excel

Who should attend

This Microsoft Excel training course has been developed for executives /Managers working in organisations wanting to use more complex functions within MS Excel.

Timing of the Course

On Day 1 registration is between 9.15-9.25 am and the training begins at 9.30 am finishing at 5.30 pm.

Meet The Faculty

Ms Madhu Bahl

Some people are borne to teach as it’s their DNA – a desire to teach what they know with a larger audience and Madhu Bahl exemplifies the same. She has a tenacious commitment and passion to train/teach.Madhu is an accomplished and seasoned professional who after completing her Engineering degree in Electronics and Telecommunications has been in the Teaching profession as a Corporate Trainer as well as Visiting faculty to students in various MBA institutes. Successfully developed skills in understanding, designing, implementing and training on various systems with good understanding of the customer needs.

She brings 22 years of progressive teaching experience and has expertise in the IT and related subjects.

She has taught and trained in IT related courses to a wide range of corporate audience. As a Corporate trainer she has trained at NTPC, SAIL, Aricent, Vanderlande Ayurvet Shoppers Stop to name a few.

As a Trainer and Training Consultant she has been associated with Corporates and Training Companies like NIIT ,Strategic Hr and Training and Various Polytechnics.

She is a visiting faculty at management campuses like IIPM, ICFP, NBA, WLC, IWSB, ASKIME, MAII.

She was adjudged Best lecturer by Multiple Reputed Management institutes on for the year 2009/10.

Registration Fees

One participant Rs.6,000/- Plus Service Tax. which includes lunch, tea, course material etc for One Day.

For Three or more participant from the same organization Rs. 5,500 + Service Tax.

(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Workshop Date/Venue

15th May 2015 At India Habitat Centre,Lodhi Road,New Delhi 110003.

(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Registration Procedure

1. Please send confirmation with your Full name ,mobile number,email-id through mail before 24th July 2015.

2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.

3. It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.

4. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Coordinator Ms Roquia Siddiqui

Seats are confirmed only after receipt of payment.

Please Send the Cheques to our office address D-321 Sector 10 Noida UP 201301
5. Early registration will be appreciated
(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Uncategorized

Hr functions for Excellence

The present day economy has been titled as “Knowledge economy”. In such an economy, it is people who make all the difference. In political economy capital or market was important. Talent occupies centre stage in the Indian workplace. In view of this, managing and retaining manpower is becoming crucial to an organization’s success.

18_W_2014

23rd & 24th July 2015 India Habitat CenterDetailsBrochure

Course Overview

The present day economy has been titled as “Knowledge economy”. In such an economy, it is people who make all the difference. In political economy capital or market was important. Talent occupies centre stage in the Indian workplace. In view of this, managing and retaining manpower is becoming crucial to an organization’s success.
To achieve this, companies across sectors are focusing on some of the more critical HR practices. While business demands, margin pressures, declining budgets, HR technology, social media, data and analytics are all reshaping the contours of HR, what is noteworthy is an increase in HR’s focus on these aspects. Traditional ways of doing things are being re-examined asHR leaders look at more effective ways of managing and aligning talent with the new business objectives.
Human resource is the most complex but also the most stretchable. Viewed as human capital, has the potential of transforming results and performance beyond imagination and benchmarked limits. This training is aimed to focus on the utilization of the human capital to maximize the return on its investment. We will try and find out and arrive at a common understanding of what actions are necessary to be undertaken to gain the maximum out of the HR, who is required to play what role and how we are to achieve our goals with the help of the Human Resource.
Understanding the nuances of managing, developing and transforming this human capital make it possible for human resources staff to perform their job effectively.

It would also enable managers to appreciate the philosophy behind the statutory requirements in the employer-employee relationship and also appreciate the psychology behind human aspirations and expectations.

Course Objectives

Enhance HR functional skills to be able to conduct HR audits maintain and keep employment records, be well versed in employment laws, write job descriptions, conduct job analysis, handle negotiations, interview applicants, write policies, and be well experienced in handling strategic restructuring, project management and managing computer data related to Human Resource Information Systems (HRIS).

The learning objectives would include recruitment procedures and selection tools and techniques, assessing training needs and identifying specific training modules, workplace safety and risk management, administration of compensation and benefits, and managing employee relations. Each HR discipline has a strategic component and a functional component. The functional component is equivalent to tactical expertise, job skills and proficiency. Knowledge alone cannot make one effective in managing and developing human resources.

Course includes

1. Provide a conceptual framework in the understanding of human behavior and work psychology.
2. Integrating the concepts to experiences at the work place and appreciating the causes for differences in performance behaviour
3. Basis on which Manpower budgets need to be prepared.
4. Competency framework in the recruitment and selection process- Psychometric testing (personality, values, attitudes, perception that effect performance behavior)
5. Employee Counseling- developing an understanding of Motivation Theories and its practical use at the work place to influence high performance of employee
6. Leadership & Communication Styles that generate high value performance.
7. Discipline & Learning Reinforcement Techniques to ensure appropriate performance behavior and adherence to code of conduct.
8. Techniques used in building employer-employee relationship & increase employee engagement (coaching&mentoring).

TAKE AWAY’s

Workshop will ensure the enhancement in the following areas for the participants :
• Developing Manpower Plans and budgets.
• Create competency based HRP for talent Acquisition
• Writing role based Job descriptions and developing KRA’a
• Structure recruitment procedures and standardize selection tools and techniques based on Role based Job Descriptions.
• Developing appraisal forms and performance metrics for Performance Management
• Clarity in payroll management and statutory requirements.
• Doing both TNA and TNI using the Performance Management System
• Creating Learning & Development platforms
• Programs for improved employer-employee relationship

Who should attend

This Programme is a must and is specifically designed for every Human Resource Professional; Managers, Team Leaders and others who are responsible for planning, managing and developing employees – be it in private/public sector, organisations, multinational companies or government organisations.

Methodology

This Course will be highly participative with the participants doing exercises under the guidance of the course leader. With Techniques such as Self discovery, Role plays, participatory exercises, case studies, practice negotiations, discussions and group interactions form the methodology for learning in the 2 days.

Timing of the Course

On Day 1 registration is between 9.00-9.30 am and the training begins at 9.30 am finishing at 5.30 pm.

On the second day training begins at 9.30 am finishing at 5.30 pm.


1. Please send confirmation with your Full name ,mobile number,email-id through mail before 23 & 24 july 2015
2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.
3. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Cordinator Ms Mohini Tyagi Seats are confirmed only after receipt of payment.
Please Send the Cheques to our office address D-321 Sector 10 Noida UP 201301
4. Early registration will be appreciated
Contact Persons : Ms. Mohini Tyagi
phone Ph: 0120 4221708, 0120 4221702

Registration Fees

One participant Rs.12,000/- Plus Service Tax. which includes lunch, tea, course material etc.
For three or more participant from the same organization Rs.11,500/- Plus Service Tax per participant.

Uncategorized

MS Excel

This program is designed for executives who want to build on Microsoft Excel skills. This course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing.Getting Excel to make decisions using the ‘If’ function and conditional formatting, You’ll learn how to create templates for commonly used worksheets. This course will also enable you to create, build and customise graphs.

Ms-B

29th July 2015 India Habitat CenterDetailsBrochure

Course Overview

This program is designed for executives who want to build on Microsoft Excel skills. This course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing.Getting Excel to make decisions using the ‘If’ function and conditional formatting, You’ll learn how to create templates for commonly used worksheets. This course will also enable you to create, build and customise graphs.

In this workshop you will also explore with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Course Objectives

Excel Basics

Moving About the Workbook
Simple Data Entry and Selecting Ranges
Saving Workbook Formats
Copying & Filling
Using Fill for Quick Copying and Copying Cell(s) to One/Many Cells & Worksheets
Editing Data

Overwriting and Editing Cell Contents, Editing Formulae or Functions or Using Undo/Redo/Search & Replace

Adjusting a Worksheet
Basics like Inserting/Deleting Cells/Inserting/Deleting/Resizing Rows/Columns
Copying/Moving/Renaming Worksheet(s)
Inserting/Deleting/Grouping Worksheets
Hiding & Unhiding Worksheets

Formulae & Working with Functions

Formulae that Add/Subtract/Multiply/Divide
BODMAS/Formula Error Checking
The Sum Function
Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions
Paste Special to Copy Formulae/Formats/Validations • Paste Special to Add/Multiple & Transpose

Formatting in Excel

• Formatting Numbers/Dates/Currency
• Formatting for Effect Bolding/ Italics/ Underling
• Cell/Background Colours
• Cell Alignment

Working and Viewing Worksheets

Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
Define Names & Lables
Creating/Deleting Labels/ Names • Creating/Using Names in Formulas/ Across Workbooks

Working with advance Functions

Writing conditional expressions (using IF)
Using nested IFs
Using logical functions (AND, OR & NOT)
Using lookup and reference functions (VLOOKUP & HLOOKUP)
Limitation of Vlookup and how to avoid it by using INDEX &INDEX

Data Validation

Creating Input Messages and Error Alerts
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Creating list based on other sheet data(new features of Excel 2007/2010)
Specifying custom validations based on formula for a cell
Conditional Formating

Sorting and Filtering Data

Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
Using advanced filter options
Extracting/removing duplicate record from database

Working with professional Reports

Creating subtotals
Multiple-level subtotals
Creating Pivot tables
Using Slicer in Pivot table(new features)
Using advance options in Pivot table(with new features of Excel 2007/2010)
Formatting and customizing Pivot tables
Using advanced options of Pivot tables
Pivot charts
Consolidating data from multiple sheets and files using Pivot tables
Using external data sources

Working with PowerPivot(new features in Excel 2007/2010)

Introducing PowerPivot feature in Excel
Importing backend data
Using validation while importing data
Importing Excel data
Working with 64bit OS
Working with huge no of Rows

More Functions

Date and time functions(TODAY, NOW, YEAR, MONTH, DAY & DATEDIF)
Text functions(TEXT, LEFT, RIGHT, MID & CONCATENATE etc)
Statistical function(COUNT, COUNTA, COUNTBLANK & COUNTIF)

Working with Styles & Formatting

Cell Styles
Creating lists using Table
Formatting the structure of a list
Conditional Formatting
Using formula/function in Conditional Formatting
Using large no of icons and bars in Conditional Formatting(new features in Excel 2007/2010)

What-If Analysis using Financial Function (PMT,PPMT & IPMT)

Using goal seek
Using data tables
Creating and editing scenarios

Working with Charts and Templates

Inserting Chart
Playing with different options and different type of chart
Using Sparklines, i.e. inserting chart in single cell(new features of Excel 2010)
Creating Templates in Excel

Who should attend

This Microsoft Excel training course has been developed for executives /Managers working in organisations wanting to use more complex functions within MS Excel.

Timing of the Course

On Day 1 registration is between 9.15-9.25 am and the training begins at 9.30 am finishing at 5.30 pm.


Meet The Faculity

Shiffolika Kapila

Shiffolika Kapila has 15 years of work experience specializes in designing and facilitating
soft skill programs. She is a communication and an expert in spoken English.
She works with her clients all the way from needs assessment through design/delivery and evaluation.

 

Delivered training programs for distinguished list of clients in industries such as Government, Automobile, IT, ITES, Banks, Hospitals, Media & Airlines.

 

Conducts training Programs on Voice and Accent, Culture, Communication Skills, Telephone etiquette, Customer Service, Business Communication and Etiquette, Presentation skills, Business English, Personality Development, Interview skills and Train the Trainers.

 

Has been a part of teams, conducting Adventure and Experiential based learning programmes.

 

Developed new business as well as managed key and large accounts for NIS Sparta’s ITES vertical.

 

Worked on a project for the Govt. of Andhra Pradesh in collaboration with Mc Kinsey, and assessed 450 people, through the use of a standardized assessment tool called the rubric.
The focus was on language skills-written and spoken. In conjunction with this – prepared a
comparative report after an in depth analysis of the language skills and ability levels.

 

Have received focused language training and methodology from Dr. Diane Sol – a language specialist from the University of California, Davis. Her experience in the ITES and the IT industry enables her to integrate practical knowledge, the technicality of the language and the soft skills required on the shop floor, with her training style and creativity. Also a certified Trainer by Arjun Raina. Has undergone a comprehensive Train the Trainer Module.

 

Currently working with Max Healthcare in the area of talent development . The role is to conduct workshops on Spoken English, Business Communication, Corporate Etiquette, and Excellence in customer relationship, Business English, Grooming and Personality Development, Presentation skills and Interview Skills, Pan-Max. Execute projects that include setting up of Standard Operating Procedures, quality processes, hiring new staff, training, assessment and calibration.

Registration Fees

One participant Rs.6,000/- Plus Service Tax. which includes lunch, tea, course material etc for One Day.

For Three or more participant from the same organization Rs. 5,500 + Service Tax.

(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Workshop Date/Venue

15th May 2015 At India Habitat Centre,Lodhi Road,New Delhi 110003.

(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Registration Procedure

1. Please send confirmation with your Full name ,mobile number,email-id through mail before 24th July 2015.

2. The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.

3. It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.

4. Payment by cheque/DD in advance in favour of “Strategic HR and Training”. Cheque/Online Transaction details to be sent through email to our Program Coordinator Ms Roquia Siddiqui

Seats are confirmed only after receipt of payment.

Please Send the Cheques to our office address D-321 Sector 10 Noida UP 201301
5. Early registration will be appreciated
(It is Mandatory for every participant to bring Laptop with MS Excel Version 2007/2010 in their laptop for Training workshop.)

Uncategorized

Business Communication

“What to say ,How to say it & When to Say”
The ability to communicate effectively is a skill vital in all workplaces.
In this enjoyable hands-on workshop, develop the skills necessary to communicate clearly in face to face situations and produce effective written documents including; letters, reports and e-mail.

7-may-2014

3rd July 2015 India Habitat Center

Course Overview

The ability to communicate effectively is a skill vital in all workplaces.

In this enjoyable hands-on workshop, develop the skills necessary to communicate clearly in face to face situations and produce effective written documents including; letters, reports and e-mail.
Through discussion, exercises and constructive feedback gain the skills to express yourself confidently in all business situations.

Learn how to use these elements as an intentional and conscious tool in order to achieve a positive first impression in every social and business situation.

Course Objectives

Types of Communication

Non-Verbal Communication

Identify other people’s body language and know what they really mean: whatever they may be saying.

Use body language to make you appear more confident, powerful, trusting, etc depending on what the situation may require from you.
Communication under Time Pressure

How to avoid conflict in the workplace

WorkShop Agenda

Session 1

Introduction
To create a positive learning environment through: Explaining the background, objectives and design of the program.
• Beginning the process of breaking down communication barriers and the building of interpersonal rapport

• Initiating the process of interaction and experience sharing.

Session 2

Communicating in Work Teams
•  Recognize their role in the process of communicating within and outside the organization.

•  Develop the skills of overcoming communication barriers.

•  Understand the need for assertive communication

Session 3

Active Listening
• Know Effective & ineffective listening habits
• Develop sound listening skills

Session 4

Effective Written Communication
• Draft communication keeping the audience in view
• Write effective letters, memos, and reports
• Write persuasively

Session 5

Effective Use of Phones and E-mail
• Use telephone effectively and courteously
• Use e-mail effectively and efficiently

Session 6

Non-verbal Communication
• Understand the need for non-verbal communication
• Know the different functions of non-verbal communication

Workshop Date/Venue

3rd July 2015 At India Habitat Centre, Lodhi Road, New Delhi 110003

Who should attend

This Course is ideal for individuals and managers who must continue to perfect their business communication skills for a professional and a business environment.

No formal prior management training is necessary.

Methodology

This Course will be highly participative with the participants doing exercises under the guidance of the course leader. The training method follows this general pattern:
•  Trainer presentation

•  Demonstration of the principles through specific examples

•  Training exercises

•  Syndicate work

•  Skill practice/Role play

•  Group discussion

•  Supported with full written notes to take away

Action planning by participants to implement back at their workplace


Meet The Faculty

Ms Madhu Bahl

Some people are borne to teach as it’s their DNA – a desire to teach what they know with a larger audience and Madhu Bahl exemplifies the same. She has a tenacious commitment and passion to train/teach.Madhu is an accomplished and seasoned professional who after completing her Engineering degree in Electronics and Telecommunications has been in the Teaching profession as a Corporate Trainer as well as Visiting faculty to students in various MBA institutes. Successfully developed skills in understanding, designing, implementing and training on various systems with good understanding of the customer needs.

She brings 22 years of progressive teaching experience and has expertise in the IT and related subjects.

She has taught and trained in IT related courses to a wide range of corporate audience. As a Corporate trainer she has trained at NTPC, SAIL, Aricent, Vanderlande Ayurvet Shoppers Stop to name a few.

As a Trainer and Training Consultant she has been associated with Corporates and Training Companies like NIIT ,Strategic Hr and Training and Various Polytechnics.

She is a visiting faculty at management campuses like IIPM, ICFP, NBA, WLC, IWSB, ASKIME, MAII.

She was adjudged Best lecturer by Multiple Reputed Management institutes on for the year 2009/10.

Timing of the Course

On Day 1 registration is between 9.00-9.30 am and the training begins at 9.30 am finishing at 5.30 pm.

Registration Fees

One participant Rs.6,000/-(Plus 14% Service Tax) . which includes lunch, tea, course material etc for One Days.

For Three or more participant from the same organization Rs.5,500/- (Plus 14% Service Tax)per participant.

Registration Procedure

1.  Please send confirmation with your Full name ,mobile number, email-id through mail before 1 July 2015.

2.  The seats will be reserved after receiving your mail and due mail confirmation will be sent to your mail ID.

3.  Payment by cheque/DD in advance in favour of “Strategic HR and Training”.
Cheque/Online Transaction details to be sent through email to our Program Coordinator Ms Mohini Tyagi
Email : mohini@strategichrandtraining.com / strategichrandtraining@gmail.com
Seats are confirmed only after receipt of payment.
Please Send the Cheques to our office address D-321 Sector 10 Noida UP 201301
4.  Early registration will be appreciated

Think of Trainings Think of Us

Loading...