Data Mining and Improvement Project Tools for Excel

Turn Raw Data into Improvement Projects with these QI Macros Tools

Customers tell us that half the battle is figuring out what to do with their data.

  • Do you struggle with Excel's Pivot Table function?
  • Is your data buried in flat transaction files or text files like the ones below?
  • Do you struggle to turn this kind of data into actionable improvement stories?

Data Exported from Tracking Systems

excel data files exported from other system

Notes Exported from Tracking Systems

count words in Excel

QI Macros add-in for Excel installs a new tab on Excel's menu:

Excel 2013-2021, Office 365:


You'll Find These Easy to Use Data Mining Tools in QI Macros

Improvement Project Wizard (formerly Data Mining Wizard)

Analyzes an entire table of defect data using PivotTables to create control charts, Pareto charts and Fishbones.

Creates all of the charts necessary to develop a rock-solid, bullet-proof business case for change.

PivotTable Wizard

Excel Pivot tables can be hard to learn but they are a snap with QI Macros. Just select up to four columns of data and then click on QI Macros PivotTable Wizard to create a PivotTable in seconds.

There are million dollar improvement projects lurking in your data. Don't miss out on these huge opportunities.

Word/Number Count Wizard

Counts the number of times a word or two-word phrase or number appears in text/number data. Use it to analyze employee feedback, call center notes, customer reviews and more. Easily create Pareto charts, too!

Want to know what customers are peeved about? Use Word Count to find out!

Unstack, Stack and Restack

Changes how your data is organized.

For example take a 6 x 6 matrix of data points and stack or restack it into as many columns and rows as you want (e.g. 4 x 9, 3 x 12; 18 x 2, etc.)

Stack and Unstack by labels or subgroups as well.

Paste Link/Transpose

Excel allows you to Paste Links to data or Transpose your data, but not both.. Use QI Macros to do both at the same time. QI Macros is also smart enough to prevent putting zeros instead of blanks in linked cells.

Use Paste Link / Transpose to link existing data to QI Macros Lean Six Sigma chart templates to simplify reporting.

Case Studies...

View Data Mining Tools Tutorial - 14 minutes

Other Reasons to Choose QI Macros



  • Only $329 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free