Optimize! Make Best Decisions with Microsoft Excel
3.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
24 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Optimize! Make Best Decisions with Microsoft Excel to your Wishlist.

Add to Wishlist

Optimize! Make Best Decisions with Microsoft Excel

Make better decisions, advance your career and make more money by building power models and optimize with Excel Solver.
3.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
24 students enrolled
Created by Justin Ren
Last updated 4/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Crystalize a business decision problem by modeling it in Excel
Build sophisticated Excel models that tackle a real business problem
Make better decisions by using Excel Solver on the models that you build
Recognize the existence of a best solution with the help of Excel
Understand the complexity of some business situations (for example, the non-linear nature in stock portfolio optimization)
View Curriculum
Requirements
  • You will need Microsoft Excel on your computer
  • Some knowledge of optimization is desired, but not required
Description

Have you ever wondered whether, for those business and financial decisions that you have made, you could have done better?

Questions such as:

- Is this the right stock portfolio that would maximize my return?

- Did I order the right amount from my supplier that maximizes my profit?

- Is this the right staffing schedule that minimizes my cost?

If you have wondered about if and how you can make better business decisions, this course is for you.

In this course, I teach you to:

- Formulate a business problem properly in Microsoft Excel with a clear objective, and then seek the best solution;

- Learn to solve a range of managerial problems, such as

a) stock portfolio optimization,

b) cash allocation,

c) workforce scheduling,

d) location planning,

e) supply management

...

- Master advanced skills such as non-linear optimization and making best decisions when things are uncertain.

The valuable skills you learn from this course will help you make better decisions, advance your career, and make more money.

With 30-day money-back guarantee, you have nothing to lose but lots of gain.

Sign up NOW!

Who is the target audience?
  • You should be comfortable with using Excel when taking this course. If not, you may start with my other "Business with Excel" course
  • If you are interested in building sophisticated decision models in Excel, this course if for you!
  • If you are interested in making better decisions or save/make more money with the help of Excel, this course is for you!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 14 Lectures Collapse All 14 Lectures 01:07:38
+
Introduction
5 Lectures 21:54
+
Optimize (I): Common Business Problems
3 Lectures 12:14
Optimize spending on advertising campaigns
03:29

Optimize human resources: worker scheduling
03:31

Decide on order quantities
05:14
+
Optimize (II): YES/NO type of decisions
2 Lectures 10:49
Assign teams to projects
04:48

Locate warehouses
06:01
+
Optimize (III): More complex problems
2 Lectures 05:08
Maximize stock portfolio returns
05:08

Step by step instructions on stock portfolio return optimization
4 pages
+
Make good decisions when things are uncertainty
2 Lectures 06:33
How much to contribute to Flexible Spending Account (I): Use Data Table
4 pages

How much to contribute to Flexible Spending Account (I): Solver vs. DataTable
06:33
About the Instructor
Justin Ren
3.7 Average rating
136 Reviews
2,059 Students
6 Courses
Professor

Dr. Justin Ren is an Associate Professor of Business Administration in the Operations and Technology Management Department, Dean's Research Fellow, and Senior Fellow of Health Policy Institute at Boston University School of Management. He was also a Visiting Scholar and Research Affiliate at Massachusetts Institute of Technology (MIT) Sloan School of Management from 2009-2013.

For almost ten years, Professor Ren has been teaching analytics courses which focuses on tools and frameworks that help managers gain market intelligence and make strategic decisions. He also teaches in executive education in financial risk management. He is a certified teacher by the Harvard Business School Case Method Discussion Leadership Program.

Professor Ren has consulted for Fortune 500 companies as well as start-ups. His work has been mentioned in Sloan Management Review, China Daily, and the World Financial Review. He has been invited to give lectures and presentations around the world at institutions such as Harvard University, MIT, Duke, Dartmouth, Georgetown, Emory, INSEAD (France), Hong Kong University of Science and Technology, Peking University (China), and Tsinghua University (China).

Professor Ren received his M.S. in Operations Research and Ph.D. in Operations and Information Management from The Wharton School at the University of Pennsylvania.