What do you think?
Rate this book
Breakthrough Improvement with QI Macros and Excel: Finding the Invisible Low-Hanging Fruit
Maximize speed, quality, productivity, and profits with QI Macros for Excel
Design well-organized spreadsheets for breakthrough improvement
Use Excel formulas to prepare data for charting or analysis
Reduce data to a manageable size using Excel's built-in functions
Master the Magnificent Seven Tools of Breakthrough Improvement--value-stream maps and spaghetti diagrams, PivotTables, control charts, Pareto charts, histograms,
fishbone diagrams, and matrix diagrams
Follow the money to identify and plug leaks in your cash flow
Identify and eliminate defects, mistakes, and errors in your processes
Transform your data into visually stunning shortcuts to decisions, actions, productivity, and profits
Consolidate data into well-designed Excel charts to quickly communicate performance trends
Maximize QI Macros for Excel power tools to analyze and graph data
Find invisible low-hanging fruit using PivotTables
Sustain breakthrough improvement with control charts, histograms, and dashboards
Use statistical tools, including hypothesis testing, analysis of variance, and regression analysis
Breakthrough Improvement with QI Macros and Excel: Finding the Invisible Low-Hanging Fruit reveals proven techniques for identifying and analyzing data that will lead to immediate results. This practical guide focuses on using Excel, one of the most widely used software packages, to drive improvement--no need to rely on expensive training in a new methodology.
Free video training and a 90-day trial version of QI Macros for Excel can be found at www.qimacros.com/breakthrough. Links to YouTube videos for each chapter of the book can be found at www.breakthrough-improvement-excel.com The combination of the book, software, and video training will provide you with the tools you need to eliminate the three silent killers of productivity: delay, defects, and deviation. You'll make and sustain breakthrough improvements that will catapult your business ahead of the competition.
LEARN HOW TO:
Design well-organized spreadsheets for breakthrough improvement
Use Excel formulas to prepare data for charting or analysis
Reduce data to a manageable size using Excel's built-in functions
Master the Magnificent Seven Tools of Breakthrough Improvement--value-stream maps and spaghetti diagrams, PivotTables, control charts, Pareto charts, histograms,
fishbone diagrams, and matrix diagrams
Follow the money to identify and plug leaks in your cash flow
Identify and eliminate defects, mistakes, and errors in your processes
Transform your data into visually stunning shortcuts to decisions, actions, productivity, and profits
Consolidate data into well-designed Excel charts to quickly communicate performance trends
Maximize QI Macros for Excel power tools to analyze and graph data
Find invisible low-hanging fruit using PivotTables
Sustain breakthrough improvement with control charts, histograms, and dashboards
Use statistical tools, including hypothesis testing, analysis of variance, and regression analysis
210 pages, Kindle Edition
First published March 14, 2014
6 people are currently reading
14 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
January 23, 2014
This book is especially good for Small Business, students, healthcare professionals and research experts, manufacturing, government industry--any industry or people wanting to find out how to improve the bottom line in their company, impress (or at least demonstrate) what they are doing, minimizing errors.
Six Sigma is complex and daunting, and this book and QI Macros makes the process easier to understand and to learn. It works "bottom up" by drawing your chart first, then analyzing it. You don't have to understand every little things about your data.
No-nonsense approach.
Six Sigma is complex and daunting, and this book and QI Macros makes the process easier to understand and to learn. It works "bottom up" by drawing your chart first, then analyzing it. You don't have to understand every little things about your data.
No-nonsense approach.
Displaying 1 of 1 review