Excel Tagged Improvement Insights

Improvement Insights Blog

Posts tagged "Excel"

Data is Like a Salmon

To make your Excel data usable, it can’t be chopped up like sushi. Here’s why:



“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].

“I look at a lot of Excel data that people send me, and unfortunately most of them have been trying to make their spreadsheet pretty so that humans can read it. No, that’s dumb, all right?

“Very often they chop it up into little bits and they either spread it out all over the spreadsheet or they spread it out in separate worksheets because this is May, June, July… and so there’s no way to take that data and turn it into a performance chart: a Control Chart, a Pareto Chart.

Posted by Jay Arthur in Excel, Improvement Insights.

8/9/22 QI Macros webinar

Over 50 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by 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 Improvement Project Wizard or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version. Send an email to support@qimacros.com and we can help, for instance in generating a quote to upgrade all the users at your organization or just guiding you through the purchasing process.

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

7/12/22 QI Macros webinar

Over 60 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by 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 Improvement Project Wizard or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version. Send an email to support@qimacros.com and we can help, for instance in generating a quote to upgrade all the users at your organization or just guiding you through the purchasing process.

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

6/7/22 QI Macros webinar

Over 35 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by 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 Improvement Project Wizard or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version. Send an email to support@qimacros.com and we can help, for instance in generating a quote to upgrade all the users at your organization or just guiding you through the purchasing process.

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

5/10/22 QI Macros webinar

Over 65 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by 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 Improvement Project Wizard or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version. Send an email to support@qimacros.com and we can help, for instance in generating a quote to upgrade all the users at your organization or just guiding you through the purchasing process.

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

4/12/22 QI Macros webinar

Over 75 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by 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 Improvement Project Wizard or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version. Send an email to support@qimacros.com and we can help, for instance in generating a quote to upgrade all the users at your organization or just guiding you through the purchasing process.

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

3/8/22 QI Macros webinar

Over 50 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by attendees.

Unfortunately, we had some technical difficulties that resulted in this particular webinar not being properly recorded.

Since we aren’t able to post the recording of March’s webinar, we instead offer a webinar below that was recorded in February:



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 Improvement Project 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 Data Mining, Excel, QI Macros, Webinar.

Line Charts with Trend Lines are often Fake News

Ever seen a line chart with a trend line that implies there was great improvement? Probably not. Here’s why:



“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].

“If you’re listening to anything in the news, they always talk about “fake news,” right? Fake news: somebody made stuff up. But in my experience, when I’m wandering around [seeing] all of these presentations and poster presentations at trade shows and stuff, I keep seeing all these line charts with trend lines in them. “Oh look! We have a trend line! It’s reducing whatever it is,” right?

Posted by Jay Arthur in Data Mining, Improvement Insights, Six Sigma.

2/8/22 QI Macros Webinar

Over 70 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by attendees.

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 Improvement Project 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 Data Mining, Excel, QI Macros, Webinar.

1/11/22 QI Macros Webinar

Over 70 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by attendees. 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 Improvement Project 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 Data Mining, Excel, QI Macros, Webinar.