rdf-syntax-grammar
mods:
  schema location: http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
  title info:
    title: Breakthrough improvement with QI macros and excel
    sub title: finding the invisible low-hanging fruit
  name:
    name part: Arthur, Jay
    name part: 1951-
    role:
      role term: creator
    role:
      role term: author.
  name:
    name part: McGraw-Hill Companies
  type of resource: text
  genre: Electronic books.
  origin info:
    place:
      place term: nyu
    date issued: 2014
    edition: First edition.
    issuance: monographic
  language:
    language term: eng
  physical description:
    form: remote
    extent: 1 online resource (xvi, 190 pages) : illustrations.
  abstract: 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 Improve…
  table of contents: 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 righ…
  note: Jay Arthur.
  note: Also available in print edition.
  note: 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.
  note: Mode of access: Internet via World Wide Web.
  note: Includes bibliographical references and index.
  note: In English.
  subject:
    title info:
      title: Microsoft Excel (Computer file)
  subject:
    topic: Electronic spreadsheets
    topic: Computer programs
  subject:
    topic: Quality control
    topic: Data processing
  subject:
    topic: Six sigma (Quality control standard)
    topic: Computer programs
  classification: HF5548.4.M523
  classification: 658.4013
  related item:
    title info:
      title: Breakthrough improvement with QI macros and excel : finding the invisible low-hanging fruit
    origin info:
      publisher: New York, N.Y. : McGraw-Hill Education, 2014
      edition: First edition.
    identifier: (OCoLC)871305318
  related item:
    title info:
      title: McGraw-Hill's AccessEngineering
  identifier: 9780071822831 (print-ISBN)
  identifier: 0071822836 (print-ISBN)
  identifier: 2014453056
  identifier: http://proxy.library.tamu.edu/login
  record info:
    record content source: IN-ChSCO
    record creation date: 210416
    record change date: 20241008175936.1
    record identifier: in00005504609
    language of cataloging:
      language term: eng