Excel Training for Quality Professionals

Shopping cart

0 Product(s) in cart

Total $0.00

» Checkout

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Does the problem feel like too much data instead of not enough?

Do you have lots of financial or error data, but don't know what to do with it? Do you have columns and rows of error codes or descriptions but don't know where to start? In this session you’ll learn to use Excel PivotTables and other tools to find the improvement project lurking in your data spreadsheets.

To find and create successful Six Sigma projects, you'll often have to do some data mining in your corporate systems and Excel spreadsheets. It doesn’t matter if you’re analyzing scrap in a metal shop or physician behavior in a maternity ward, the answers you seek lie in the scrap-by-scrap, birth-by-birth analysis.

There's a wealth of improvement project information hiding in the acronyms, text and raw numbers associated with each of these events. To find the hidden improvement projects in this kind of data, you’ll want to learn how to use Excel PivotTables to transform these data and text files into numbers you can analyze.

Then use pareto and control charts to graph the results. You'll find it easy to narrow your focus to the 4% of your business that causes over 50% of the waste and rework.

Learning Objectives:

• Use Excel PivotTables to perform data mining and analysis
• Use Excel Functions to separate and combine data from multiple sources
• Extract information from text fields
• Create an actionable improvement story to drive breakthrough improvements
  
  

Workshop Outline:

1. Learn to Analyze Data using PivotTables
2. Learn to Use Excel's Data Validation Options
3. Learn to Select Subsets of Your Data Using Excel's Autofilter Function
   
4. Learn to Merge Data from Various Sources Using Excel's VLookup and HLookup Functions and the Offset and Match Functions
5. Learn to Analyze Text Data Using Excel's Count IF function
   
6. Learn to Create Color Coded Scorecards Using Conditional Formatting
   
7. Learn to Draw Paretos, Control Charts, Histograms and More Using the QI Macros Software for Excel
   

Course Materials Provided to Each Participant:

• QI Macros Example Book
• SPC Simplified Workbook
  
• Lean, Six Sigma and SPC Quick Reference Cards

Additional: QI Macros SPC Software for Excel

Prework: To maximize learning, we use your data for examples. Excel files of delay, defects and variation must be available at least one week before class begins. We'd be happy to sign a nondisclosure statement.

Course Length: 8 hours

Participants: up to 25

Facilities: A computer lab or laptop computers with Microsoft Excel loaded are required for this workshop.

Investment Options: (includes all US travel and training materials)

1. $6,000 with 30-day evaluation version of the QI Macros SPC Software for Excel.
2. $8,500 includes QI Macros SPC Software for Excel licenses for all 25 participants.
3. $14,000 - Option 2 plus an additional day of individual and/or team coaching/ to analyze data or develop improvement projects. (Must be the day before or after the one day workshop.)

Call 888-468-1537 to Book Jay Now!

About the Company and Jay Arthur

KnowWare International Inc., dba Lifestar, is located in Denver, CO. It was founded in 1992 by Jay Arthur, The KnowWare® Man, the owner and president.

Jay works with companies that want to fire up their profits using the tools of Lean Six Sigma. He is the author of Lean Six Sigma Demystified, McGraw Hill, and the creator of the QI Macros SPC Software for Excel.