The Complete Operations Management Course – In Excel

The Complete Operations Management Course – In Excel, available at $54.99, has an average rating of 4.9, with 37 lectures, based on 42 reviews, and has 358 subscribers.

You will learn about Learn key terms and concepts in the field of Quality and Operations Management Build Capacity models for factories and production facilities Optimize operations through linear optimization procedures Use statistics to understand and visualize business operations Conduct Hypothesis testing including ANOVA and Regression Analysis Create Monte Carlo simulations to forecast and understand complex processes Develop robust quality control methods such as capability analysis and control charting This course is ideal for individuals who are Operations Managers or Engineers or Industrial Engineers or MBAs or Quality Managers or Data Analysts or Data Scientists or Business Analysts It is particularly useful for Operations Managers or Engineers or Industrial Engineers or MBAs or Quality Managers or Data Analysts or Data Scientists or Business Analysts.

Enroll now: The Complete Operations Management Course – In Excel

Summary

Title: The Complete Operations Management Course – In Excel

Price: $54.99

Average Rating: 4.9

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Learn key terms and concepts in the field of Quality and Operations Management
Build Capacity models for factories and production facilities
Optimize operations through linear optimization procedures
Use statistics to understand and visualize business operations
Conduct Hypothesis testing including ANOVA and Regression Analysis
Create Monte Carlo simulations to forecast and understand complex processes
Develop robust quality control methods such as capability analysis and control charting

Who Should Attend

Operations Managers
Engineers
Industrial Engineers
MBAs
Quality Managers
Data Analysts
Data Scientists
Business Analysts

Target Audiences

Operations Managers
Engineers
Industrial Engineers
MBAs
Quality Managers
Data Analysts
Data Scientists
Business Analysts

Do you think you need to learn a new software program to model your business operations through data analysis, optimization, simulations and statistics? You Don’t! Everything you need to get started in the world of Operations Modelling is already on your computer in the wonderful application called Excel.

This Course is designed to take students through the fundamentals of operations modelling and management. Starting with foundational topics and vocabulary, we build a robust understanding of what operations are and why they matter to businesses. Then, we focus deeply on several quantitative tools and techniques to help us better understand, manage, forecast and predict how our operations will perform and can be improved.

This course is taught entirely in MS Excel which makes it widely accessible to a number of interested participants without the need to purchase, download, or learn a new program or programming language. In addition to learning key concepts in the world of operations management, quality management, data analysis and operations modelling, you will also increase your proficiency in one of the world’s most popular and essential programs in business.

Techniques and tools covered:

Capacity Modelling

Descriptive Statistics

Inferential Statistics

Data Distributions

Regression Analysis

ANOVA

Monte Carlo Simulations

Process Capability

Control Charting

Linear Programming and Optimization

And MUCH MORE!

Please message me if you have any questions!

Course Curriculum

Chapter 1: Introduction to Operations Modelling

Lecture 1: Introduction

Lecture 2: Basic Production

Lecture 3: Time

Lecture 4: Cost, Manpower, Productivity

Lecture 5: Averages & Standard Deviations

Lecture 6: Appendix #1.1: Enabling the Data Analysis Tool Pak Add-in

Chapter 2: Capacity Modelling

Lecture 1: Simple Capacity

Lecture 2: Normal Capacity

Lecture 3: Textile Capacity

Lecture 4: Ramp Up Capacity

Chapter 3: Linear Optimization

Lecture 1: The Case for Optimization

Lecture 2: Shipping/Route Optimization

Lecture 3: The Backpack Problem

Lecture 4: The Mixing Problem

Lecture 5: Sensitivity & Shadow Prices

Lecture 6: APPENDIX #3.1: Adding the Solver Add-in to Excel

Chapter 4: Statistics, Probability and Data Distributions

Lecture 1: Change from Deterministic to Stochastic Models

Lecture 2: Statistics & Probability

Lecture 3: The Normal Distribution

Lecture 4: Other Distributions

Lecture 5: APPENDIX #4.1: The Statistics Reference Card Resource

Chapter 5: Statistics: Hypothesis Testing

Lecture 1: Identifying Issues with Statistics

Lecture 2: Hypothesis Testing

Lecture 3: The ANOVA Test

Lecture 4: The Simple Regression Test & Analysis

Chapter 6: Quality Management

Lecture 1: Process Variation

Lecture 2: Process Capability

Lecture 3: Performing a Capability Analysis

Lecture 4: Process Control Charts

Lecture 5: Process Control Charting with Time

Lecture 6: Process Control Charting with Quality

Lecture 7: Process Control Charts without Charts

Chapter 7: Simulation

Lecture 1: Simulation Fundamentals

Lecture 2: Setting up a Monte Carlo Simulation in Excel

Lecture 3: Case #7.1: Movie Theater Concessions Simulation

Lecture 4: Case #7.2: Call Center Operations Simulation

Lecture 5: APPENDIX #7.1: Simulation using Historic Data

Instructors

Michael Parent
Principal – Michael Parent Consulting

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 5 votes
4 stars: 12 votes
5 stars: 24 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu