Root Cause Failure Analysis (RCFA) Week 2 Training

Description:

In the competitive landscape of manufacturing, customers are currently challenging suppliers to improve their standards. Managers are often juggling multiple challenges and struggle to keep up with the day to day requirements of the business. How do companies find the time to manage daily requirements and simultaneously improve? The answer is to “Create Scientists!” One of the goals of the TGG Root Cause Failure Analysis course is to create problem solvers at each level of the organization – small teams of scientists in every department. This course will introduce the learner to a mix of concepts and tools that can be used to effectively diagnose and eliminate anomalies in operations.

Excel is a spreadsheet developed by MicroSoft capable of doing powerful data manipulation and analysis. It contains a daunting number of features including: calculations, pivot tables, charts/graphs, and even a macro programming language! Due to its broad capabilities, its main limitation is the lack of user knowledge of these resources. It is believed that the average person uses no more than 20% of Excel’s potential. This class introduces the students to methods which will facilitate their data analysis.

This hands-on training provides exposure to useful short-cuts, functions, and data manipulation techniques. The class includes exercises where the class is provided the opportunity to apply the new tools and shortcuts. They are encouraged to bring their own real data.

At the end of the session, participants will be able to:

  • How to properly develop and scope a problem
  • How to write a project charter
  • Project prioritization
  • Proper Data Collection Methods
  • How to display data
  • Data Evaluation
  • Brainstorming techniques
  • Mapping
  • Implementation Plans
  • Work Breakdown structure
  • Communication and Training Plans
  • Standardize the solution
  • Reaction Plan
  • Replication & Standardization
  • Use most helpful short-cuts.
  • Apply built-in functions.
  • Create and modify pivot tables.
  • Insert slicers and filters.

Excel is a spreadsheet developed by Microsoft capable of doing powerful data manipulation and analysis. It contains a daunting number of features including:  calculations, pivot tables, charts/graphs, and even a macro programming language! Due to its broad capabilities, its main limitation is the lack of user knowledge of these resources. It is believed that the average person uses no more than 20% of Excel’s potential. This class introduces the students to methods which will facilitate their data analysis.

This hands-on training provides exposure to useful short-cuts, functions, and data manipulation techniques.  The class includes exercises where the class is provided the opportunity to apply the new tools and shortcuts.  They are encouraged to bring their own real data. 

At the end of this one day session, participants will be able to:

  1. Use several short-cuts
  2. Apply built-in functions
  3. Create and modify pivot tables
  4. Insert slicers and filters

Duration:

4 days + 1 day (Advanced Excel)

Related tgg Training:

Related tgg Services:

We cannot display this gallery

Define your Problem Statement.

The first step towards breaking your organizational log jams is identifying and verbalizing the challenge you're facing. What are you trying to solve? This simple Problem Statement exercise can have profound implications for your team. It helps you define the issue and gives TGG some sense of where the soft spots could be in your Order to Cash process. We invite you to take a few moments to fill out this form. A TGG consultant will contact you shortly to discuss your Problem Statement and provide some insight on how we may be able to help.

Back to top