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 fees for course Introduction to Spreadsheets and Models is -
Certification | Fee Amount in INR |
Introduction to Spreadsheets and Models (Audit) | Free |
Introduction to Spreadsheets and Models - 1 month | Rs. 6,638 /- per month |
Introduction to Spreadsheets and Models - 3 months | Rs. 4,425 /- per month |
Introduction to Spreadsheets and Models- 6 months | Rs. 3,319 /- per month |
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
Assignment
- 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
Assignment
- 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
Assignment
- 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
Assignment
- Module 4 Quiz: Simulations, Scenarios, and Optimization