http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
Breakthrough improvement with QI macros and excel
1 online resource (xvi, 190 pages) : illustrations.
Annotation Maximize speed, quality, productivity, and profits with QI Macros for ExcelBreakthrough 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-- 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 improvementUse Excel formulas to prepare data for charting or analysisReduce data to a manageable size using Excel's built-in functionsMaster the Magnificent Seven Tools of Breakthrough Improvement--value-stream maps and spaghetti diagrams, PivotTables, control charts, Pareto charts, histograms, fishbone diagrams, and matrix diagramsFollow the money to identify and plug leaks in your cash flowIdentify and eliminate defects, mistakes, and errors in your processesTransform your data into visually stunning shortcuts to decisions, actions, productivity, and profitsConsolidate data into well-designed Excel charts to quickly communicate performance trendsMaximize QI Macros for Excel power tools to analyze and graph dataFind invisible low-hanging fruit using PivotTablesSustain breakthrough improvement with control charts, histograms, and dashboardsUse 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- to rely on expensive training in a new methodology.".
A. About the author -- B. Finding the invisible low-hanging fruit -- Every picture tells a story -- The goal -- Problems you can solve with qi macros and excel -- Good data, bad decisions -- 1. Spreadsheet design for breakthrough improvement -- Horizontal or vertical? -- Defect tracking with microsoft excel -- Warning: mistake-proof data collection -- Data for service companies: defects and turnaround times -- Time data -- Summary -- 2. Excel formulas for breakthrough improvement -- Calculate ratios -- Excel will guide you -- Text formulas -- Time and date formulas -- Logic -- Here's my point -- 3. Filtering data for breakthrough improvement -- Create subsets of your data using "autofilter" -- Custom filters -- Sort the data -- Even huge spreadsheets can be manageable -- 4. The magnificent seven tools for breakthrough improvement -- The magnificent seven tools -- 5. Follow the money for breakthrough improvement -- The lesson is simple: follow the money! -- Health care case study -- Don't wait for storm season -- Conclusion -- 6. Where's the pain? -- Where's the pain? -- The dirty-30 process for breakthrough improvement -- Common problems -- Conclusion -- 7. A picture is worth a thousand words -- Say it with charts -- Chart junk -- Qi macros chart wizard -- Here's my point -- 8. Excel power tools for breakthrough improvement -- Setting up your data in excel -- Data collection and measurement -- The qi macros for excel -- The qi macros are easy to use -- Qi macros introduction -- Power tools for breakthrough improvement -- Troubleshooting problems -- Technical support -- 9. Breakthrough improvement using microsoft excel -- Data mining with excel -- Qi macros pivottable wizard: the shortcut to breakthrough improvement -- Breakthrough improvement projects -- Small data analytics for breakthrough improvement -- Lost time analysis -- Get the idea? -- 10. Sustaining breakthrough improvement -- Quality and process indicators -- Common and special causes -- Choosing the right control chart for sustaining improvement -- Stability analysis -- Analyzing capability -- Control plan -- Qi macros for monitoring stability and capability -- Summary -- 11. Excel drawing tools for breakthrough improvement -- Visual thinking for breakthrough improvement -- Problem solving is a story told with pictures -- Breakthrough improvements in speed -- Breakthrough improvement exercises -- 12. Hypothesis testing for breakthrough improvement -- Hypothesis testing -- Statistics with qi macros and excel -- Chi-square tests in excel -- Regression analysis -- Conclusion -- Exercises -- A. Bibliography -- B. Learning resources.
Electronic reproduction. New York, N.Y. : McGraw Hill, 2014. Mode of access: World Wide Web. System requirements: Web browser. Access may be restricted to users at subscribing institutions.
Mode of access: Internet via World Wide Web.
Includes bibliographical references and index.
Breakthrough improvement with QI macros and excel : finding the invisible low-hanging fruit
New York, N.Y. : McGraw-Hill Education, 2014