Excel
Blog

Posts tagged "Excel"

*Latest webinar: 11/6/19 QI Macros Webinar

More than 40 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the new features introduced in recent releases of the software.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar attendees.)

 



If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the Templates Wizard or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Excel, QI Macros, Webinar.

1/8/19 Webinar

Almost 50 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the new features introduced in recent versions of the software.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar attendees.)

If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the “Find Tool” search feature or the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in QI Macros, Webinar.

QI Macros Upgrade 2017 V3

It took me 25 years to figure out how to make the QI Macros software do all this automatically, and now you can:
…analyze your data with the QI Macros Data Mining Wizard,
…have the QI Macros Chart Wizard choose which chart your need,
…allow the QI Macros Statistics Wizard analyze your data…

…ALL “AUTOMAGICALLY”! Upgrade your software to the latest version by 12/31/17, and take advantage of the $150 savings!

Posted by Jay Arthur in QI Macros.

Excel Column Charts Hide The Signal in Noise

The July/August 2017 HealthLeaders magazine had a series of charts about the impact of Adverse Events. In general, the magazine used column charts:

But wouldn’t a Pareto chart illuminate the important adverse events more clearly? The first three accounted for over 57% of 2013 deaths.

Posted by Jay Arthur in Excel, QI Macros, Six Sigma.

Nobody Wants to Read Your Spreadsheet!

Nobody wants to read your spreadsheet! No matter how hard you try to make it pretty, create great labels or whatever, the only person who can read your spreadsheet is a CFO or Excel spreadsheet geek. And the Excel geek is going to tell you 10 ways to make it prettier.

The purpose of data is to provide insights for action, not just report past performance.

How Do I Know That Most Excel Users Try to Make Their Spreadsheets Readable By People?
According to Renu Davi, Sr. Program Manager for Excel, Microsoft tracks how people use Excel. The vast majority of the 650 million users use it for lists and reports.

Posted by Jay Arthur in Data Mining, QI Macros, Six Sigma.

Data Visualization and Exploration In Excel

You can use Excel’s data formatting, commenting and filtering tools to help visualize and clarify your data.

Highlighting: Select cells and click on Home-Fill Color to highlight cells:

highlighted cells

Commenting: To add comments to any cell, click on Data-Insert Comment:

insert comment

Subset: To select a subset of your data, click on Data-Filter and select the desired content:

data subset

Excel will simplify and streamline your data for ease of analysis:

select subset

Excel has many powerful data exploration and visualization tools. Play with them!

 

Posted by Jay Arthur in Excel, Six Sigma.

The Correct Way To Draw A Pareto Chart

I first learned how to draw Pareto charts by hand using engineering paper if you can believe it. Our trainers were very specific about how they were to be drawn. One of the earliest references I can find is Kaoru Ishikawa’s Guide to Quality Control. Here’s the correct way to draw a Pareto chart using data from Ishikawa’s book:

Pareto Chart of Defect Data from Ishikawa's Guide to Quality Control
The bars should be touching and the cumulative percentage line should go from corner to corner of the first bar.

Unfortunately, most Pareto charts drawn by computer look like the following one, bars not touching and cumulative line running out of the center of the top of the first bar.

Posted by Jay Arthur in QI Macros, Six Sigma.

Are You a Programmer or a Lean Six Sigma Belt?

I’ve noticed that a lot of Six Sigma Belts try to build their own control charts in Excel. I don’t know if this is because their company didn’t buy them any software to do their job or they don’t know that there’s already Excel-based software that can do everything for them.

Most people spend many hours creating a primitive control chart worksheet and, more often than not, they have incorrect formulas; so their chart is not valid. If you spend five hours creating a spreadsheet or two, you’ve already spent more than the cost of the QI Macros.

Are you wasting your time programming?

Posted by Jay Arthur in QI Macros, Six Sigma.

Excel App for the iPad and QI Macros

Downloaded and installed Excel for the iPad. It’s provides basic Excel functionality. As expected, it will handle QI Macros charting templates, but won’t run macros. https://www.qimacros.com/store/?cat=14

To get the full functionality of the QI Macros or to run any Visual Basic addins, you’ll need a Windows 8 tablet running Excel 2010 or Excel 2013.

I tried several Win 8 tablets.
The Surface Pro is fast, but heavy and runs warm because of the I5 processor. I didn’t love the keyboard.

I tried the Samsung, but it had an idiot light that blinked when closed that ate 5% of the battery every day.

Posted by Jay Arthur in QI Macros.

Minitab and Excel: Which Should I Use and When?

In a recent blog post, Minitab asked: “Have you ever found yourself switching back and forth between a Microsoft Excel file and Minitab Statistical Software just to complete a single analysis?”

Comparing Minitab to Excel (without the QI Macros) is a bit like comparing a calculator to an abacus.

If you have the QI Macros addin for Excel, you don’t have to switch.
You can do everything in Excel.

Creating Graphs with Raw Data Easily

The blogger says: “Just try creating a Pareto Chart in Excel…I dare you!”

I’ll take that dare. If you have a column of defects (below), just click on the title for the column and choose the QI Macros Pareto Chart.

Posted by Jay Arthur in QI Macros.