Latest Excel Posts for Improvement Insights

Improvement Insights Blog

Latest "Excel" Posts

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.

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.

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.

12/7/21 QI Macros Webinar

Over 100 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.

Harness the Power of Excel Formulas

Few spreadsheets use the power of Excel formulas, which is like using a Ferrari as a push cart. Excel formulas are power tools for improvement. Here’s how to access them in QI Macros.



“A few years back, I went to an Excelapalooza conference (yes there is such a thing), and the keynote speaker was kind of the head developer for Excel, and she was talking about how Microsoft keeps track of what people do. I was stunned to recognize that only 5% (that’s five out of a hundred) Excel spreadsheets have any sort of formula in them, even division or multiplication or something simple like that.

Posted by Jay Arthur in Excel, Improvement Insights, QI Macros.