Introduction to Spreadsheets and Models
Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure
Compare Quick Facts
Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
---|
English | Self Study | Video and Text Based |
Courses and Certificate Fees
Certificate Availability | Certificate Providing Authority |
---|
yes | Coursera |
The Syllabus
Videos
- Objectives and a Little Spreadsheet History
- Navigating a spreadsheet and crafting formulas
- Using function
- Using conditional expressions in formulas
- Common errors in spreadsheets
- Differences between Sheets and Excel
Readings
- PDF of Module 1 Lecture Slides
- Module 1 examples
Practice Exercise
- Module 1 Quiz: History, Formulas, Functions and Errors
Videos
- Module Introduction
- Using assumptions and decision variables in spreadsheet models
- Structuring a spreadsheet to model variables, objectives, and objective functions
- Constructing simple cashflow model
- What-if analysis and sensitivity analysis
- Limits to simple, deterministic models
Readings
- PDF of Module 2 Lecture Slides
- Module 2 examples
Practice Exercise
- Module 2 Quiz: Classic Models
Videos
- Introduction
- Random variables and probability distributions
- Changes in discrete and continuous time
- Power, exponential, and log functions
- Probability trees and decision trees
- Correlation and Regression
Readings
- PDF of Module 3 Lecture Slides
- Module 3 examples
- Additional reading on exponential and other functions
Practice Exercise
- Module 3 Quiz: Probability, Correlation, and Regression
Videos
- Introduction
- Monte Carlo Simulations
- Linear Programming
- Next Steps, and Differences between Excel and Sheets
Readings
- PDF of Module 4 Lecture Slides
- Module 4 examples
- Links and other resources for further study
Practice Exercise
- Module 4 Quiz: Simulations, Scenarios, and Optimization