Careers360 Logo
Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure
Compare

Quick Facts

Medium Of InstructionsMode Of LearningMode Of Delivery
EnglishSelf StudyVideo and Text Based

Courses and Certificate Fees

Certificate AvailabilityCertificate Providing Authority
yesCoursera
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
Back to top