Financial and Business Simulation with Microsoft Excel
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.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
"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:
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Start Here|
Download Excel File: goo.gl/iNpyUF
|Section 2: Simulate Discrete Outcomes|
Simulate discrete outcomes such as throwing a dicePreview
|Section 3: Simulate Continuous Outcome Such as Sales from Best-case-worst-case Distribution|
Best-Case-Worst-Case distribution, also called the Triangular DistributionPreview
Simulate a Stock Portfolio Return with a Triangular Distribution
|Section 4: The Bell Curve (i.e. the Normal Distribution)|
Simulate A Normal Random Variable
Simulate a Stock Portfolio Return with a Normal Distribution
|Section 5: Make Better Decisions with Simulation|
How Much to Order when Demand is Unknown
|Section 6: Stock Market Simulations|
Model Stock Price Movement: Google
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.