Advanced Excel, FMEA, Inventory & Stores MGMT
Advanced Excel, FMEA, Inventory & Stores MGMT
Advanced Excel, FMEA, Inventory & Stores MGMT
Greetings!
Please find 3 appended brochures, requesting nominations:
December
Programme
2018
13 MS Advanced Excel
16 Failure Mode & Effects Analysis (FMEA)
18 Inventory & Stores Management
Prerequisites:
Participant should familiar with basic excel that contain few functions like sum,
max, min etc, formatting like borders, fonts, merge, etc, saving, printing
techniques.
Participants need to bring their own laptop with MS Office installed, for
better understanding and practical experience. The participants may also bring
with them live data pertaining to their organization, so that these can be studied
during the workshop, as to how it can be worked out with better solutions.
This program is for anyone who is already familiar with the basics of Microsoft
Excel, and who would like to work 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.
Contents:
Module 1: Working with Functions
1) Writing conditional expressions (using IF)
Using if with single condition
Using if with multiple conditions
5) Hiding formulas
Hiding Formulas
7) Tracking changes
How to activate track changes
How to track changes in the workbook
8) Merging workbooks
17) Consolidating data from multiple sheets and files using Pivot tables
Contents:
Definition/
History of FMEA
Origin of FMEA
Why to use FMEA?
Objectives of FMEA
Types of FMEAS
System/Design and Process FMEA
Differences between System, Design and Process FMEA
PFMEA- Benefits of PFMEA-
When to conduct PFMEA?
Standard Procedures
All Steps involved
Various Major Failure modes
Input and output of PFMEA
Rating scales of Severity/Detection /Occurrence
Risk Priority Number and its calculations
Process flow diagram-- Control Plan-- 8D Linkage
Case studies
Case studies continued
All Standard Formats
Q&A
Summary
Contents:
Definition & Organization of Stores
Definition of Inventory, Need of Inventory
Objectives & Functions of Stores
Layout – Definition, Objective, Types
Location system
Transactions of Stores & accounting
Material handling – Objective, Need
Preservation of material
Scrap & Waste management
Stock verification – objective, types & methods
Losses of Stores & its Prevention
Duties & Responsibility of Stores Manager
Performance of Stores
Fees include participation, course material (Hard copies), Breakfast, Lunch and tea /
coffee.
_____________________
IITD Expert Faculty: Highly experienced faculty from Indian Institute of Training &
Development will conduct this training. The training sessions will provide participants an
opportunity to discuss specific problems with the expert faculty.
Registration:
Certification:
Certificate of Participation would be provided to all the participants.
We have many more new, exciting & innovative programs to share with you.
We look forward to your active participation and nominations in large numbers.
With warm regards,
Rajiv Kolhe
Director
Indian Institute of Training & Development (IITD)
F # 4 & 5, Vishnu Prasad Apartments | 98/82, Right Bhusari Colony |
Paud Road | Pune - 411038 | Mob: 98220 89898, 8308459802 |
Tel 91 20 4120 3985 | E-mail: rajiv@iitdpune.com; iitdpune@gmail.com
Website - www.iitdpune.com
Training Calendar
Incentive per
Investment per person for a group
Date Programme
person* of three or more
members*
December 2018
9 APQP & PPAP Rs. 3,000/- Rs. 2,800/-
13 MS Advanced Excel Rs. 2,800/- Rs. 2,600/-
15 Lean Manufacturing Rs. 2,800/- Rs. 2,600/-
15 & 22 Dec
& Six Sigma Green Belt Rs. 14,000/- Rs. 13,000/-
5 & 12 Jan
16 Failure Mode & Effects Analysis Rs. 3,000/- Rs. 2,800/-
18 Inventory & Stores Management Rs. 3,400/- Rs. 3,200/-
Corporate Grooming, Personality
19 Rs. 2,600/- Rs. 2,400/-
Development & Etiquette
20 Total Productive Maintenance Rs. 2,600/- Rs. 2,400/-
Finance for Non Finance
20 Rs. 3,400/- Rs. 3,200/-
Executives
22 Labour Laws Rs. 3,400/- Rs. 3,200/-