About this Course

56,167 recent views

Learner Career Outcomes

31%

started a new career after completing these courses

30%

got a tangible career benefit from this course
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Approx. 6 hours to complete
English

Skills you will gain

Monte Carlo MethodMicrosoft ExcelLinear Programming (LP)Solver

Learner Career Outcomes

31%

started a new career after completing these courses

30%

got a tangible career benefit from this course
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Approx. 6 hours to complete
English

Offered by

Placeholder

University of Pennsylvania

Syllabus - What you will learn from this course

Content RatingThumbs Up81%(4,588 ratings)Info
Week
1

Week 1

2 hours to complete

Spreadsheets: A Tool for Thinking with Numbers

2 hours to complete
6 videos (Total 42 min), 2 readings, 1 quiz
6 videos
1.2 Navigating a spreadsheet and crafting formulas19m
1.3 Using functions4m
1.4 Using conditional expressions in formulas4m
1.5 Common errors in spreadsheets4m
1.6 Differences between Sheets and Excel4m
2 readings
PDF of Module 1 Lecture Slides10m
Module 1 examples10m
1 practice exercise
Module 1 Quiz: History, Formulas, Functions and Errors30m
Week
2

Week 2

1 hour to complete

From Spreadsheet to Model

1 hour to complete
6 videos (Total 23 min), 2 readings, 1 quiz
6 videos
2.1 Using assumptions and decision variables in spreadsheet models2m
2.2 Structuring a spreadsheet to model variables, objectives, and objective functions2m
2.3 Constructing simple cashflow model4m
2.4 What-if analysis and sensitivity analysis4m
2.5 Limits to simple, deterministic models5m
2 readings
PDF of Module 2 Lecture Slides10m
Module 2 examples10m
1 practice exercise
Module 2 Quiz: Classic Models30m
Week
3

Week 3

2 hours to complete

Addressing Uncertainty and Probability in Models

2 hours to complete
6 videos (Total 40 min), 3 readings, 1 quiz
6 videos
3.1 Random variables and probability distributions11m
3.2 Changes in discrete and continuous time5m
3.3 Power, exponential, and log functions8m
3.4 Probability trees and decision trees5m
3.5 Correlation and Regression7m
3 readings
PDF of Module 3 Lecture Slides10m
Module 3 examples10m
Additional reading on exponential and other functions10m
1 practice exercise
Module 3 Quiz: Probability, Correlation, and Regression30m
Week
4

Week 4

2 hours to complete

Simulation and Optimization

2 hours to complete
4 videos (Total 34 min), 3 readings, 1 quiz
4 videos
4.1 Monte Carlo Simulations13m
4.2 Linear Programming9m
4.3 Next Steps, and Differences between Excel and Sheets7m
3 readings
PDF of Module 4 Lecture Slides10m
Module 4 examples10m
Links and other resources for further study10m
1 practice exercise
Module 4 Quiz: Simulations, Scenarios, and Optimization30m

Reviews

TOP REVIEWS FROM INTRODUCTION TO SPREADSHEETS AND MODELS

View all reviews

Frequently Asked Questions

More questions? Visit the Learner Help Center.