- From www.coursera.org
Introduction to Spreadsheets and Models
Course
en
English
Subtitles available
4 h
This content is rated 0 out of 5
- Self-paced
- Free Access
- Fee-based Certificate
- 4 Sequences
- Introductive Level
- Subtitles in Portuguese
Course details
Syllabus
- Week 1 - Spreadsheets: A Tool for Thinking with Numbers
This module was designed to introduce you to the history of spreadsheets, their basic capabilities, and how they can be used to create models. You'll learn the different types of data used in spreadsheets, spreadsheet notations for mathematical operations, com... - Week 2 - From Spreadsheet to Model
In this module, you'll move from spreadsheet to model, so you can begin to create your own models that reflect real-world events. You'll learn how to organize and lay out model elements, as well as the types of objective functions and their use. You'll also le... - Week 3 - Addressing Uncertainty and Probability in Models
This module was designed to introduce you to how you can use spreadsheets to address uncertainty and probability. You'll learn about random variables, probability distributions, power, exponential, and log functions in model formulas, models for calculating pr... - Week 4 - Simulation and Optimization
In this module, you'll learn to use spreadsheets to implement Monte Carlo simulations as well as linear programs for optimization. You'll examine the purpose of Monte Carlo simulations, how to implement Monte Carlo simulations in spreadsheets, the types of pro...
Prerequisite
None.
Instructors
Don Huesman
Managing Director, Wharton Online
Innovation Group- Wharton School
Editor
The University of Pennsylvania (commonly known as Penn), founded in 1740, is a private university located in Philadelphia, Pennsylvania, USA. A member of the Ivy League, Penn is the fourth oldest institution of higher learning in the United States and considers itself the first university in the United States to offer both undergraduate and graduate degrees.
Platform
Coursera is a digital company offering massive open online course founded by computer teachers Andrew Ng and Daphne Koller Stanford University, located in Mountain View, California.
Coursera works with top universities and organizations to make some of their courses available online, and offers courses in many subjects, including: physics, engineering, humanities, medicine, biology, social sciences, mathematics, business, computer science, digital marketing, data science, and other subjects.
This content is rated 4.5 out of 5
(no review)This content is rated 4.5 out of 5
(no review)Complete this resource to write a review