Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Excel: Value Stream Mapping

via LinkedIn Learning

Overview

Find out how to build value stream maps in Excel and PowerPoint to analyze and visualize business processes.

Value stream mapping is a method for documenting business processes, allowing project managers and analysts to analyze the different states and identify areas of improvement. This course shows how to create value stream maps using Excel and PowerPoint. Learn how to document two real-world processes—a manufacturing process and a service process—by calculating measures for various subprocesses, such as process time, cycle time, process utilization, and information flow time, and visualize the results in PowerPoint or other tools. By the end of the course, you will have a basic understanding of value stream maps and be able to create them using these popular Office apps.

Syllabus

Introduction
  • Capture and present information with value stream mapping
  • What you should know
1. Introducing Value Stream Maps
  • Describe the philosophy and goals of value stream maps
  • Introduce the course scenarios
  • Identify the components of a value stream map
  • Read a value stream map
2. Create a Manufacturing Value Stream Map
  • Calculate takt time for the process
  • Determine process time and cycle time
  • Calculate process utilization
  • Determine inventory waiting time
  • Include information flow times
  • Calculate total lead time and total processing time
3. Create a Service Value Stream Map
  • Calculate takt time for the process
  • Determine process time and cycle time
  • Calculate process utilization
  • Determine inventory waiting time
  • Include information flow times
  • Calculate total lead time and total processing time
Conclusion
  • More resources

Taught by

Curt Frye

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Excel: Value Stream Mapping

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free