QI Macros for Excel 2007 - Classic Excel Menu or Ribbon


© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

Excel 2007 offers different user interface from previous versions of Excel. To simplify your life, we offer both an Excel 2007 ribbon interface and the Classic Excel 2003 menu.

The QI Macros run the same way: just select your data using the mouse and click on the appropriate chart or tool.

The Classic Excel Menu

While the new ribbon interface may be easier for new users to learn, it can be challenging for those of us who have been using Excel for years. So, to simplify the transition, Jay created a "classic Excel 2003 menu" with all of the Excel tools and buttons, as well as the QI Macros Pull Down Menu.

You'll have a choice of installing the Classic Excel Menu or the QI Macros Ribbon. After you've installed you easily switch the menus. The Classic Menu looks like this:

The Classic Excel Menu includes:

  • Excel pull down menus
  • QI Macros pull down menu
  • Standard toolbar
  • Formatting toolbar
  • Drawing toolbar

The QI Macros Ribbon

The Excel 2007 QI Macro Ribbon loads to the right of the last "tab" when you start Excel. It's all one ribbon shown here in two parts for clarity:

There are six "groups" on the QI Macros Ribbon:

  1. Anova and Statistical Analysis Tools
  2. Fill-in-the-blanks templates for every aspect of TQM and Lean Six Sigma:
    • SPC Charts
    • Lean Tools
    • Planning Tools
    • Improvement Tools
    • Flow Charts and Fishbones
    • DFSS, MSA, AIAG
  3. Data Transformation Tools to restack, sample or link your data.
  4. Charts to show capability (histograms and Box & Whisker)
  5. QI Macros Control Chart Wizard and attribute and variable charts.
  6. Improvement Charts including pareto, scatter, multivari, line, bar, pie, etc.

Double Click the Play button (above) to watch the QI Macros 2007 in action.

The QI Macros Control Chart Ribbon

This ribbon loads in the Excel "Design" tab after you've drawn a control chart. It enables you to add data, delete points, show process changes and analyze stability on existing QI Macros control charts.

The QI Macros "Addins" Pull Down Menu

You can also run the QI Macros using the Excel 97-2003 style menu by clicking on Excel's "Addin" Tab:

After you run a chart, you will also find the Excel 97-2003 QI Macros Chart Menu on the addins toolbar:


© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map