QI Macros Trial #6 - Dashboards and Scorecards | |||||||||||||||||||
We help people think! |
How to Create Dashboards and Scorecards With The QI MacrosDashboardsMany people wonder how they can create dashboards and scorecards in Excel using the QI Macros. They want to input data into an Excel spreadsheet that looks like this:
And create a dashboard of charts that looks like this:
Creating dashboard is easy using the QI Macros fill-in-the-blank-templates. Watch Video. ScorecardsUsing Excel's Conditional formatting feature you can also turn your input sheet into a color coded scorecard. Watch Video.
QI Macros HelpNear the bottom of the QI Macros pulldown menu you'll find the help file. In it you'll find further descriptions of each of the tools and templates. Watch Video. In the following lessons, we'll take a more detailed look at each of the main features of the QI Macros. After you've tested the QI Macros enough to satisfy your curiosity about how well the software can meet your needs, you can purchase online at https://www.qimacros.com/order230.html 24 hours a day. If you have questions, email them plus your sample data to: lifestar@rmi.net In Lesson #7 we will cover Real Time SPC using the QI Macros. Thank you again for your interest in the QI Macros. View Next Lesson
© 2007 KnowWare International Inc. (888) 468-1537 |
It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.
|
|||||||||||||||||
