Excel for Operations Management Course

Transform Your Operational Challenges into Excel Solutions

Streamline business operations with advanced Excel techniques. It's 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:

	Breakeven Point - Use Goal Seek, Data Tables, Sensitivity Analysis and Charting Breakeven point
	Introduction to using the Solver – use the Solver to find the optimal solution
	Assignment Problem – Find the right person for the job to minimize the cost or time of completing several jobs by a number of people.
	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.
	Capital Investment – Allocate limited funds to maximise NPV/Profit within resource constraints.
	Creating Gantt Charts in Excel – ideal for those who don’t have access to Microsoft Project.
	Staff Scheduling Optimization – Find the right mix of staff numbers to meet demands on various dates and within other constraints.
	Each topic comes with an Excel workbook containing a practice exercise, so you can solidify your understanding before moving on to the next one.
	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 was a clinical professor at the Fox Business School of Temple University and has over 15 years of industrial experience. He was awarded a Microsoft Excel Most valuable Professional (MVP) for 2014 - 2016. Dr. Gottlieb has taught Excel 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.

Course Prerequisites

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

Choose Your Membership Level

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.