The Complete Operations Modeling Course - In Excel

Focused View

Michael Parent

8:07:44

193 View

1. Introduction to Operations Modelling

1.1 M1.L1.xlsx

1. Introduction.mp4

15:39

2.1 M1.L2.xlsx

2. Basic Production.mp4

14:58

3.1 M1.L3.xlsx

3. Time.mp4

14:26

4.1 M1.L4.xlsx

4. Cost, Manpower, Productivity.mp4

15:02

5.1 M1.L5.xlsx

5. Averages & Standard Deviations.mp4

13:22

6. Appendix #1.1 Enabling the Data Analysis Tool Pak Add-in.mp4

02:14

2. Capacity Modelling

1.1 Capacity Model - Empty.xlsx

1.2 Capacity Model.xlsx

1.3 simple_capacity (720p).mp4

11:32

1. Simple Capacity.mp4

11:32

2. Normal Capacity.mp4

18:45

3. Textile Capacity.mp4

11:12

4. Ramp Up Capacity.mp4

06:31

3. Linear Optimization

1.1 M3.L1.xlsx

1. The Case for Optimization.mp4

15:33

2.1 M3.L2.xlsx

2. ShippingRoute Optimization.mp4

13:48

3.1 M3.L3.xlsx

3. The Backpack Problem.mp4

12:31

4.1 M3.L4.xlsx

4. The Mixing Problem.mp4

11:10

5.1 M3.L5.xlsx

5. Sensitivity & Shadow Prices.mp4

08:58

6. APPENDIX #3.1 Adding the Solver Add-in to Excel.mp4

01:39

4. Statistics, Probability and Data Distributions

1.1 M4.L1.xlsx

1. Change from Deterministic to Stochastic Models.mp4

08:01

2.1 M4.L2.xlsx

2. Statistics & Probability.mp4

16:13

3.1 M4.L3.xlsx

3. The Normal Distribution.mp4

14:03

4.1 M4.L4.xlsx

4. Other Distributions.mp4

11:47

5.1 M4.A1 - Statistics Reference Card.xlsx

5. APPENDIX #4.1 The Statistics Reference Card Resource.mp4

03:01

5. Statistics Hypothesis Testing

1.1 M5.L1.xlsx

1. Identifying Issues with Statistics.mp4

11:05

2.1 M5.L2.xlsx

2. Hypothesis Testing.mp4

10:54

3.1 M5.L3.xlsx

3. The ANOVA Test.mp4

15:07

4.1 M5.L4.xlsx

4. The Simple Regression Test & Analysis.mp4

14:08

6. Quality Management

1.1 M6.L1.xlsx

1. Process Variation.mp4

12:42

2.1 M6.L2.xlsx

2. Process Capability.mp4

15:08

3.1 M6.L3-1.xlsx

3. Performing a Capability Analysis.mp4

13:07

4.1 M6.L4.xlsx

4. Process Control Charts.mp4

13:39

5.1 M6.L5.xlsx

5. Process Control Charting with Time.mp4

14:28

6.1 M6.L6.xlsx

6. Process Control Charting with Quality.mp4

12:49

7.1 M6.L7.xlsx

7. Process Control Charts without Charts.mp4

08:56

7. Simulation

1.1 M7.L1.xlsx

1. Simulation Fundamentals.mp4

14:59

2.1 M7.L2.xlsx

2. Setting up a Monte Carlo Simulation in Excel.mp4

15:17

3.1 M7.L3.xlsx

3. Case #7.1 Movie Theater Concessions Simulation.mp4

16:49

4.1 m7.l4 (1080p).mp4

19:56

4.2 M7.L4.xlsx

4. Case #7.2 Call Center Operations Simulation.mp4

19:56

5.1 M7.Appendix1.xlsx

5. APPENDIX #7.1 Simulation using Historic Data.mp4

06:47

Description

Fundamental and Intermediate Concepts in Operations Management and Engineering

What You'll 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 is this for?

Operations Managers

Engineers

Industrial Engineers

MBAs

Quality Managers

Data Analysts

Data Scientists

Business Analysts

What You Need to Know?

Basic Math

More details

Description
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!
Who this course is for:
Operations Managers
Engineers
Industrial Engineers
MBAs
Quality Managers
Data Analysts
Data Scientists
Business Analysts

User Reviews

Rating

average 0

Total votes0

Focused display

Michael Parent is a Lean Six Sigma Black belt and Principal at Michael Parent Consulting Company, a Management Consulting Firm. He has consulted in many functions and industries including manufacturing, HR, insurance, sales, and logistics/supply chain. Additionally, Michael is the author of the forthcoming book “The Lean Innovation Cycle” to be published by Taylor & Francis.Michael holds a degree in Industrial & Operations Engineering from the University of Michigan, Ann Arbor, an MBA from William & Mary in Williamsburg Virginia, and is received his Lean Six Sigma Master Black Belt from Lawrence Tech University in Southfield, MI.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.