ChartSmartXL Data Mining and Analysis Tools

Analyze Your Data Quickly and Easily with ChartSmartXL Tools That Make You Look Like an Expert

Many of our customers tell us that half the battle of meaningful data analysis and chart creation is to get their data in a usable format.

  • 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?
  • Do you struggle with Excel's Pivot Table function?

Raw data to analyze in Excel

run data analysis on text data in Excel

Struggle No More! ChartSmartXL contains the tools you need to conduct data analysis and mining in Excel.

Data Mining Wizard - Data Mining can seem difficult if not impossible, but not with ChartSmartXL. Just select two column headingsand then click on the ChartSmartXL Data Mining Wizard to create an entire data analysis in Excel.

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

There are million dollar improvement projects lurking in this kind of data. Are you missing out on huge opportunities?

Word Count Wizard - counts the number of times a word or two-word phrase appears in comment data collected by employees like call center reps. Use it to summarize raw text data and then create Pareto charts.

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

Stack and Restack - Changes how your data is organized. You can increase the number of columns (e.g. 1 to 2, 1 to 4, 3 to 5, etc.) or you can decrease the number of columns (e.g. 4 to 1, 4 to 2, 3 to 2, etc.)

Paste Link/Paste Link Transpose - Excel allows you to either Paste Links to data or Transpose your data, but not both at the same time. Use ChartSmartXL to do both. ChartSmartXL Paste Link and Paste Link Transpose also use formulas to prevent putting zeros instead of blanks in linked cells.

Use these features to create the links from existing data to the ChartSmartXL Lean Six Sigma chart templates to simplify reporting.

Statistical Tools for Hypothesis Testing - to simplify comparing means and variances, doing regression testing and other key data analysis tools and techniques.

ChartSmartXL Data Mining Tools Can Save You Time and Effort.

To access the ChartSmartXL data mining functions, find the Data Mining sub menu.

Excel 2007, 2010 and 2013:

data mining tools for Excel

Learn More...

Create charts and diagrams in just seconds using ChartSmartXL...

60 Day Money-Back Guarantee