Financial and Business Simulation with Microsoft Excel
3.8 (5 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.
44 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial and Business Simulation with Microsoft Excel to your Wishlist.

Add to Wishlist

Financial and Business Simulation with Microsoft Excel

How to better predict the future, make more profits and advance your career by using uncertainties to your advantage
3.8 (5 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.
44 students enrolled
Created by Justin Ren
Last updated 3/2015
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
21 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 31 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Simulate random events in business such as demand flutuations or stock price movements
  • Incorporate simulation in making strategic decision under uncertain environment, and therefore make better decisions (and money too!)
  • Intelligently predict the future with a statistical distribution (instead of a point forecast)
View Curriculum
Requirements
  • You need to have some understanding about random events such as coin tosses, throwing a dice, stock price changes etc..
Description

"What will be the stock price tomorrow?"

"How many customer orders will we receive?"

"What is the chance our project will finish on time?"

To answer those questions, you need a tool to model and then predict the future.

In this course, we show you how to better predict the future, make more profits and advance your career by using Microsoft Excel!

The course will teach you:

  • How to model a coin-toss type of events: Will Red Sox win the next game? Will Apple Stock go up or down?
  • How to model a random quantity: project completion time, stock portfolio value etc..
  • Some most useful statistical distributions in business, such as the normal distribution
  • How to use uncertainties to your advantage and make optimal business decisions

You will discover the huge untapped potential by learning to simulate uncertain quantities (demand, stock prices, time...) and use them to make better business decisions - and more money - today!

Who is the target audience?
  • Professionals and managers that deal with uncertain environments such as the stock market
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 8 Lectures Collapse All 8 Lectures 30:40
+
Start Here
1 Lecture 03:41

Download Excel File: goo.gl/iNpyUF

Preview 03:41
+
Simulate Discrete Outcomes
1 Lecture 04:41
+
Simulate Continuous Outcome Such as Sales from Best-case-worst-case Distribution
2 Lectures 09:36

Simulate a Stock Portfolio Return with a Triangular Distribution
03:45
+
The Bell Curve (i.e. the Normal Distribution)
2 Lectures 04:10
Simulate A Normal Random Variable
02:04

Simulate a Stock Portfolio Return with a Normal Distribution
02:06
+
Make Better Decisions with Simulation
1 Lecture 03:52
How Much to Order when Demand is Unknown
03:52
+
Stock Market Simulations
1 Lecture 04:40
Model Stock Price Movement: Google
04:40
About the Instructor
Justin Ren
3.3 Average rating
145 Reviews
2,163 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.