Careers360 Logo
Browse by Stream
Search Colleges, Exams, Schools & more
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 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

Similar Courses

Analyzing Data with Excel

IBM via  Edx

Months 5Free

MS Excel Training Course Online

Upskillist 

Years 2349

Excel for Beginners

Great Learning 

Months 2Free
View All Courses

More Courses by The Wharton School, Philadelphia

More Introduction to Financial Accounting

The Wharton School, Philadelphia via  Coursera

Months 66.60 K

Artificial Intelligence for Decision Making Business Strategies and Applications

The Wharton School, Philadelphia via  Simplilearn

Months 31.22 L

Entrepreneurship Acceleration Program Scaling Your Business

The Wharton School, Philadelphia via  Emeritus

Months 32.05 K
View All Courses

Explore on Careers360

Download Careers360 App's

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

  • student
    300M+

    Students

  • colleges
    36,000+

    Colleges

  • exams
    550+

    Exams

  • ebook
    1500+

    E-Books

  • certification
    16000+

    Certifications

student
Mobile Screen

We Appeared in

Back to top