Excel for Operations Management

Calculating breakeven, optimizing shipping, allocating funds to maximize NPV/profit, or managing staff scheduling, this course will teach you how to do these things and more.Includes an introduction to Excel Solver and how to create Gantt Charts.
MOT ·August 31, 2020


Course Details

Course Overview 

This course is ideal for those involved in managing the daily operations of a business. For example:

  • System Engineers
  • Clinical Safety
  • Management Engineering
  • Information Systems
  • Quality Management/Control
  • Facilities Management
  • Process Improvement
  • Distribution Management
  • Performance Improvement
  • And more….

Course Syllabus

The course contains the seven lessons, each with an explanation, demonstration and then a practice question, including:

Excel for operations course breakevenBreakeven Point – Use Goal Seek, Data Tables, Sensitivity Analysis and Charting Breakeven point
Excel for operations course solver
Introduction to using the Solver – use the Solver to find the optimal solution
Excel for operations course assignment
Assignment Problem – Find the right person for the job to minimize the cost or time of completing several jobs by a number of people.
Excel for operations course shipping
Optimize Shipping Decisions – Minimize the cost of distributing a product from a number of sources or origins to a number of destinations. Examples of external and internal shipping scenarios.
Excel for operations course capital Capital Investment – Allocate limited funds to maximise NPV/Profit within resource constraints.
Excel for operations course gantt charts Creating Gantt Charts in Excel – ideal for those who don’t have access to Microsoft Project.
Excel for operations course staff scheduling Staff Scheduling Optimization – Find the right mix of staff numbers to meet demands on various dates and within other constraints.
Excel for operations course practice Each topic comes with an Excel workbook containing a practice exercise, so you can solidify your understanding before moving on to the next one.
Excel for operations course certificate And when you’re finished we’ll send you a Certificate of Completion to add to your résumé

Who Is Teaching The Course

Dr. Isaac Gottlieb earned his PhD in Management Engineering from Columbia University. He is a clinical professor at the Fox Business School of Temple University and has over 15 years of industrial experience. He also teaches an Excel for Business Application class at Temple University which had over 2000 students in 2015.

He was awarded a Microsoft Excel Most valuable Professional (MVP) for 2014 – 2016.

Dr. Gottlieb has taught Excel over the last 15 years to over 30,000 MBA, executive MBA, MS, PhD and undergraduate students at Columbia, NYU, Temple, and other universities. He has conducted numerous corporate seminars in the United States and abroad.

He is also the author of Next Generation Excel: Modeling in Excel for Analysts and MBA’s.

Prerequisite

  • The course is intended for all levels and does not require any specific knowledge other than basic Excel skills.
  • Requires Excel 2007 or later.

10% off

Be The First

to Know

For Your next purchase when sign up.

Great News ?

  • This Discount Offer is exclusively available only to clients coming from Pro-education Academy website.

100 % Guarantee

Notes

  1. Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  2. Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  3. Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  4. You can request a refund provided that no more than 30% of the course videos have been watched.

Choose Your Membership Level

 
 

Currency

Excel for Operations Management OnlineExcel for Operations Management Download
30 Day Guarantee
Note: prices are +GST for Australian customers.

$19.00

12 Months Online

$39.00

12 Months Online + Download

Course Videos
1hr 31mins
white tickwhite tick
One Payment for 12 Months Online Accesswhite tickwhite tick
Download Videos * See Notes white tick
Unlimited 24/7 accesswhite tickwhite tick
Pause, rewind, replaywhite tickwhite tick
Download Workbooks
and Practice Data
white tickwhite tick
30 Day Money Back Guaranteewhite tickwhite tick

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

Our Business Excel Course Collection

                Why Not Discover, More Courses Below! 

Excel 
Charts
Formulas
PivotTables 
Online Training
Dashboard
 Shortcuts 
 VBA
01 / 05

PROFESSIONAL TRAINING

Course Delivery – Live online sessions
Course Duration – 8 Weeks (Three hours every weekend)
Why Learn with Us?
Interactive Learning: You’ll learn with a team of ambitious professionals.
Lifetime Access: It will allow you to revisit the course every time you need it.
Certification: Completion Certificate provided to back your learnings.
IIBA Certified Trainer: You’ll learn from certified industry experts.

So whatever job you are in, let us hold your hand and show you our innovative approach to success using one of our courses. You won’t find a more committed team.
Studying a Business Analyst Course, you can rely on our skillful team of Consultants to build your Business Analyst career even with no experience. Taking this course you’ll find only the most cutting-edge classes designed by Industry Experts. The instructors you’ll meet know SDLC, AGILE and HYBRID project methodologies inside out. Setting you for the highest level of success as a Business Analyst.
These courses are aligned to IIBA and designed to provide you with the core and job ready Business Analysis experience and certification so that you are set on the right growth track in Australia and globe.

02 / 05
Lara Madrigal
DESIGNER

Lara has over 10 years’ experience in the design industry. During this time, she has developed skills across many areas including branding, illustration, UI design, print and web design. She loves to be challenged and to enhance her skillset.

“Being a member of such a talented team is constantly inspiring. We each bring our passion to the studio to make our company a very special creative hive.”
03 / 05
Deborah Barbosa
BRAND STRATEGIST

Deborah describes brand strategy as her perfect blend of critical thinking and collaborative research, one that encourages her natural love of questions and genuine interest in people.

“We are fortunate enough to get to work with many internationally recognised brands, on interesting projects, which makes working at our company an exciting place to be.”
04 / 05
Martijn Dragonjer
PARTNER

Martijn joined the team in early 2015, after ten years working in the film industry. With a strong background for sales and marketing, Will was excited to bring a new perspective to the team.

“There is a constant buzz here, everyone is driven and focused on producing the best work possible for clients. It is a very rewarding place to work with fantastic clients .”
05 / 05
Dominik Doudny
DEVELOPER

Dominik has a passion for developing sites with clean, beautiful code. Dominik’s love for full-stack web development makes him a great asset that can take on back-end code and front-end UI needs if necessary.

“What makes a good company enjoyable? Working with enthusiastic members of well-structured teams of engaging characters.”
previous arrownext arrow
Slider

Still Not too Sure ?

No problem at all, you can book an appointment to speak to one of our subject experts, please, click in Get Support button below.

About Instructor

MOT

1 Course

+162 enrolled
Open Registration
Skip to content