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.
Online course developer, freelance writer, and speaker. MBA.Curt Frye is the president of Technology and Society, Incorporated.He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning. As a speaker, he has presented talks on topics including "Rhetorical Mathematics" for CLE credit at the Law and Magic conference, "Business Storytelling Using Microsoft Excel" at the ATD-Cascadia annual conference, and his Improspectives® approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences. Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.
Skills covered in this course
- [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 files
Download 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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Watch this course anytime, anywhere. Get started with a free trial today.