[Lynda] Excel 2016: Business Process Analysis

Author

image of author Curt Frye Curt Frye

Released

7/31/2017

Operate with increased efficiency. Learn how to evaluate business processes using Excel worksheet formulas. These formulas let business analysts determine the theoretical throughput of processes, assess the impact of changeover time, identify bottlenecks, and weigh setup costs versus product costs when placing an order. Curt Frye shows how to apply them to calculate capacity, identify what resources are idle and underutilized, determine optimum batch size, and calculate the right number of products to manufacture and the correct quantity to order to maximize cost savings. These are the kinds of business decisions that business analysis tools like Excel were built for! Learn how to use it to help your organization run at an entirely new level of productivity.

Topics include:

  • Drawing process flow diagrams
  • Calculating process capacity
  • Identifying bottlenecks
  • Determining cycle time and idle time
  • Calculating labor
  • Calculating utilization
  • Analyzing batch processes
  • Calculating optimal order quantities
Skill Level Intermediate

1h 25m

Duration

33,335

Views
Show More Show Less
Size: 162.90M

 

https://www.lynda.com/Excel-tutorials/Excel-2016-Business-Process-Analysis/590822-2.html.


FRIENDLY WEBSITES

 

Tutorials For Free, Guides, Articles & Community Forum.OneHack.Us | Tutorials For Free, Guides, Articles & Community Forum. A place where everyone can share knowledge with each other



 

RELATED POSTS


4 Comments

  1. djallel May 4, 2019 Reply
  2. Raymond December 31, 2017 Reply
  3. freecoursesonline December 30, 2017 Reply
  4. Drovosek December 27, 2017 Reply

Add a Comment

Your email address will not be published. Required fields are marked *