Improvement Project Reporting Tips | Improvement Project Reporting Using Excel

Improvement Project Reporting
home · products · services · search · view cart · contact

NAVIGATION

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

I just had breakfast with a Six Sigma Champion from a large pharmaceutical company. Want to know what his pet peeve was?

PowerPoint!

He felt that belts spend far too much time getting data from here, graphing it there, putting the results into PowerPoint presentations, transferring the results into some project data warehouse. Taking a chart from Excel and pasting it into PowerPoint doesn't really add value. He said: "It's NVA" (non-value added work). He said he'd like to see belts spend one-tenth the time preparing presentations and use the other nine-tenths solving more problems and adding more value.

When teams present, all he wanted to know was:

What tools did you use in each phase?
What did the tools tell you? How did they guide your analysis and solution?

Seems pretty simple doesn't it?

Using Excel and the QI Macros for Project Reporting
Rather than create your charts and diagrams in Excel and copy them into PowerPoint, why not tell your story directly from Excel?

Any Excel workbook can hold up to 255 charts that refer to a worksheet. Workbooks can hold as many worksheets as memory will allow.

To create your project report in Excel, simply:

Move/Copy all of the charts, diagrams and analysis into one workbook.
Rearrange the order of the sheets to be in DMAIC order so that they tell a comprehensive story of how you solved your problem.
The QI Macros create interim data sheets for most charts. To hide them, click on Format-Sheet-Hide or just move them to the back of the workbook. If anyone asks you where the data came from, you can unhide them to reveal the detail.

Now you have the improvement project documented in one workbook. This workbook serves as the data repository of the entire project. It can be stored as a resource for future projects.

To present your project, just click from sheet to sheet as you tell the story of the improvement project.

Pretty simple, huh?

Here's My Point
Don't get caught up in trying to make your project pretty. Results speak for themselves. Use the QI Macros to analyze your data. Use Excel as your data repository and reporting tool. Solve more problems. Create more value. When you've got a good story to tell, no one will miss PowerPoint.

To purchase the QI Macros

If you already own the QI Macros, you can purchase an upgrade. You must purchase one upgrade for each license you own.

If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.

Dashboards and Scorecards

Try QI Macros
FREE
For 30-Days