Careers360 Logo
Browse by Stream
Search Colleges, Exams, Schools & more
Scan and Download the App!
Search Faster,
Smarter, Better
Rated 4.2
by 1M+ students
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

Similar Courses

Everyday Excel Part 2

University of Colorado, Boulder via  Coursera

Months 53.37 K

Excel VBA for Creative Problem Solving Part 1

University of Colorado, Boulder via  Coursera

Months 63.37 K

Everyday Excel Part 1

University of Colorado, Boulder via  Coursera

Months 53.37 K
View All Courses

More Courses by The Wharton School, Philadelphia

Executive Presence and Influence Persuasive Leadership Development

The Wharton School, Philadelphia via  Emeritus

Months 62.73 K

Future of Work Leading Modern Workplaces

The Wharton School, Philadelphia via  Emeritus

Months 62.60 K

Chief Human Resources Officer Program

The Wharton School, Philadelphia via  Emeritus

Years 122.00 K
View All Courses

Explore on Careers360

Student Community: Where Questions Find Answers

Ask and get expert answers on exams, counselling, admissions, careers, and study options.
Download Careers360 App
All this at the convenience of your phone

  • Regular Exam Updates

  • Best College Recommendations

  • College & Rank predictors

  • Detailed Books and Sample Papers

  • Question and Answers

400M+

Students

36K+

Colleges

500+

Exams

3K+

eBooks

16K+

Certifications

Scan and download the app

OR