About this Course
The easy spreadsheet is likely one of the strongest information evaluation instruments that exists, and it’s obtainable to nearly anybody. Main companies and small companies alike use spreadsheet fashions to find out the place key measures of their success are actually, and the place they’re more likely to be sooner or later. However with a view to get probably the most out of a spreadsheet, you’ve got the know-how to make use of it. This course is designed to offer you an introduction to primary spreadsheet instruments and formulation so that you could start harness the ability of spreadsheets to map the information you’ve got now and to foretell the information you’ll have sooner or later. By means of brief, easy-to-follow demonstrations, you’ll discover ways to use Excel or Sheets so that you could start to construct fashions and resolution timber in future programs on this Specialization.
This course is a part of a number of applications
This course may be utilized to a number of Specializations or Skilled Certificates applications. Finishing this course will depend in the direction of your studying in any of the next applications:
- Finance & Quantitative Modeling for Analysts Specialization
- Enterprise and Monetary Modeling Specialization
SKILLS YOU WILL GAIN
- Monte Carlo Methodology
- Microsoft Excel
- Linear Programming (LP)
- Solver
Syllabus – What you’ll study from this course
WEEK
1
2 hours to finish
Spreadsheets: A Software for Pondering with Numbers
This module was designed to introduce you to the historical past of spreadsheets, their primary capabilities, and the way they can be utilized to create fashions. You’ll study the several types of information utilized in spreadsheets, spreadsheet notations for mathematical operations, widespread built-in formulation and features, conditional expressions, relative and absolute references, and how you can determine and proper round references. By the top of this module, you’ll perceive the context of spreadsheets, have the ability to navigate a spreadsheet, use built-in formulation and features in spreadsheets, create your individual easy formulation, and determine and proper widespread errors so you possibly can put spreadsheets to give you the results you want.
WEEK
2
1 hour to finish
From Spreadsheet to Mannequin
On this module, you’ll transfer from spreadsheet to mannequin, so you possibly can start to create your individual fashions that mirror real-world occasions. You’ll discover ways to manage and lay out mannequin components, in addition to the kinds of goal features and their use. You’ll additionally study what-if evaluation and situations, sensitivity evaluation, and different basic fashions. By the top of this module, you’ll have the ability to design a spreadsheet reflecting assumptions, resolution variables, and outcomes, create a primary cashflow mannequin, consider a small enterprise alternative, conduct what-if evaluation, determine key variables utilizing sensitivity evaluation, and linear programming fashions and deterministic fashions.
WEEK
3
2 hours to finish
Addressing Uncertainty and Likelihood in Fashions
This module was designed to introduce you to how you should use spreadsheets to handle uncertainty and chance. You’ll find out about random variables, chance distributions, energy, exponential, and log features in mannequin formulation, fashions for calculating chance timber and resolution timber, how you can use regression instruments to make predictions, in addition to a number of regression. By the top of this module, you’ll have the ability to measure correlations between variables utilizing spreadsheet statistical features, perceive the outcomes of features that calculate correlations, use regression instruments to make predictions, and enhance forecasts with a number of regression.
WEEK
4
2 hours to finish
Simulation and Optimization
On this module, you’ll study to make use of spreadsheets to implement Monte Carlo simulations in addition to linear applications for optimization. You’ll study the aim of Monte Carlo simulations, how you can implement Monte Carlo simulations in spreadsheets, the kinds of issues you possibly can deal with with linear applications and how you can implement these linear applications in spreadsheets. By the top of this module, you’ll have the ability to mannequin uncertainty and threat in spreadsheets, and use Excel’s solver to optimize assets to achieve a desired consequence. You’ll additionally have the ability to determine the similarities and variations between Excel and Sheets, and be ready for the following course within the Enterprise and Monetary Modeling Specialization.
