What you will learn from this course
- Learn how spreadsheets can be used to create models
- Learn the different types of data used in spreadsheets
- Spreadsheet notations for mathematical operations
- Common built-in formulas and functions
- Conditional expressions, relative and absolute references
- How to use built-in formulas and functions in spreadsheets
- Create your own simple formulas
- How to organize and lay out model elements
- Types of objective functions and their use
- Learn what-if analysis and scenarios, sensitivity analysis, and other classic models
- Learn about random variables, probability distributions, power, exponential
- Log functions in model formulas
- How to use regression tools to make predictions
- How to use spreadsheets to implement Monte Carlo simulations
- How to implement Monte Carlo simulations in spreadsheets
- How to implement linear programs in spreadsheets
The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses in this Specialization.
How to Enroll Introduction to Spreadsheets and Models course?
How many members can access this course with a coupon?
Introduction to Spreadsheets and Models Course coupon is limited to the first 1,000 enrollments. Click 'Enroll Now' to secure your spot and dive into this course on Udemy before it reaches its enrollment limits!