Leverage the Power of Excel to Report Cost of Quality Data
Build Effective Quality Reports with Excel

E-mail this product to a friend E-mail this product to a friend


Previous  Up  Next" 

Build Effective Quality Reports with Excel
 
DATE & TIME
August 24, at 1:00 p.m. EDT | 10:00 a.m. PDT
Please check your time zone for the correct local time.
 
 
LENGTH
Three Hours
 
 
PRICE
$299
 
 
SUMMARY
A major task in making quality costs work is how to turn data from many sources into a coherent report. Few cost systems, even if they are highly integrated, can flex to create a comprehensive quality cost report. Flexibility is often paramount in starting up a quality cost program, so spreadsheets become the tools of choice.

How do you handle the many challenges of taking multiple data sources and make them combine in a flexible yet controlled manner? How do you keep a summary report for the executives in sync with a detail report for the shop floor? What methods can be used to scan for awkward changes from one month to the next in an efficient manner? There are many details in running this obstacle course. Let someone who has been there help you though the maze and enhance your chances of success in leveraging the power of Excel to report cost of quality data!

Demonstrations in the use of Excel to leverage data reporting will dominate the content of this class. Participants will receive a handout for note-taking prior to the class and will also receive an Excel template at the end of the class.


 
KEY COURSE OBJECTIVES
  1. Preparation to implement
  2. Different sources /Data timing/ The use of indices
  3. Drop and massage
  4. Tools to move to a common structure
  5. Report date control
  6. Levels of reporting
  7. Report summarization/ Graphic presentation
  8. Dynamic comparisons

KEY TOPICS
  • Spreadsheet tricks and tips
  • Drop data from many formats
  • Link data to a common reporting frame
  • Multi-level reporting- multiple plants or sites and distribution
  • Detail and summary reporting with history charts
  • Approach to manage the process of collecting data
  • Providing for adjustable time reporting (able to roll back to prior dates)
  • Demonstrate major categories: denominators for volume adjustments, departmental cost transfers, manual fixes for systematic errors

BONUS!
Get your specific questions answered in a live Q&A session during the webinar.
 
 
PRESENTER

 
Douglas C. Wood is the principal in DC Wood Consulting, LLC. The firm focuses on quality control consulting, business information planning, data analysis and related areas. He has more 30 years' experience in industrial engineering and quality. He has saved millions of dollars at client firms and employers through his practical approach to measurement implementation.

He is the author of 
The Executive Guide to Understanding and Implementing Quality Cost Programs, published by ASQ Quality Press.

Wood is active in ASQ, serving in the past as Kansas City section chair, education chair, site committee chair for the 2003 Annual Quality Congress, and Quality Management Division (QMD) Cost of Quality technical committee chair. A senior member of ASQ, he holds two ASQ Certifications: CQE and Certified Manager of Quality/Organizational Excellence.

He has been an examiner with the Kansas state quality award and the Missouri state quality award, and a lead examiner with the Kansas award in 2002. He is currently serving on an interdisciplinary task force providing strategic direction on a new multiyear research initiative exploring the economics of a wasteful society.
 
 
HOW DOES THIS ALL WORK?
After you register for the Webinar, you will receive a confirmation e-mail. It will contain a Web link to access the visual portion of the event through your Web browser. It will also contain an a phone number and access code that you will use to hear the audio portion of the event. 
 
 
PRICING
We are so confident that you will find this webinar valuable that we offer a 100% money back guarantee, making this a risk-free investment. If you are dissatisfied with the webinar, just let us know by phone or e-mail within 24 hours of the conclusion of the webinar, and we will issue you a full refund.


PLEASE NOTE: Participation in this webinar is just $299 per site and allows access to one Internet connection and one phone line.



Price: $299.00 


Quantity:  

Enter number of participants above and the name and e-mail of each PAID participant below:

 

Problem Solving in Plain English
Problem Solving in Plain English
Calibration: What Auditors Look for in a Controlled Process
Calibration: What Auditors Look for in a Controlled Process
The Top 10 Quality Audit Questions
The Top 10 Quality Audit Questions
Internal Quality Auditing, Second Edition
Internal Quality Auditing, Second Edition