- Duration: 1h 25m 8s
- Skill Level: Intermediate
- Released: July 31, 2017
- Viewers: 52,599
Learn the most in-demand business, tech and creative skills from industry experts.
Course detailsOperate 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.
- [Curt] Hi, I'm Curt Frye. Welcome to the course. In this course, I'll demonstrate effective ways to analyze business processes in Microsoft Excel. I'll start by introducing process flow diagrams, show you how to calculate process capacity and identify bottlenecks, and determine how many times a year you turn over your inventory. Next, I'll describe how to calculate cycle time and idle time, calculate resource utilization based on actual usage, and calculate implied utilization based on projected demand levels. Finally, I'll show you how to analyze batch sizes for efficient production, calculate the order quantity that minimizes your total costs, and identify the right number of units to manufacture when you own the means of production. In short, you'll find that the course provides a strong background in assessing and evaluating your business processes. Dive right in.
Practice while you learn with exercise filesDownload the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.Download the exercise files for this course. Get started with a free trial today.
Watch this course anytime, anywhere. Get started with a free trial today.