[Lynda] Excel 2016: Business Process Analysis

[esi post-views cache="public" ttl="0"]


Tags: , , , ,

image of author Curt Frye

Curt Frye



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



Show More Show Less
Size: 162.90M



Hacking Tutorials, Guides, Articles & Community Forum.OneHack.Us | Tutorials For Free, Guides, Articles & Community Forum.

Download Paid Apps Free.

Related Courses

4 thoughts on “[Lynda] Excel 2016: Business Process Analysis”

  1. There are no course exercise files in the link. What use is the course without exercise files? Please provide the course exercise files too. Thanks.


Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.