What you will learn in Introduction to Spreadsheets and Models Course
-
Spreadsheet Fundamentals: Understand the history and basic capabilities of spreadsheets, and how they can be used to create models.
-
Data Types and Functions: Learn about different types of data used in spreadsheets, spreadsheet notations for mathematical operations, common built-in formulas and functions, conditional expressions, relative and absolute references, and how to identify and correct circular references.
-
Modeling Techniques: Discover how to structure a spreadsheet to model variables, objectives, and objective functions.
-
Sensitivity Analysis: Learn about what-if analysis and sensitivity analysis to evaluate how changes in assumptions affect outcomes.
-
Optimization: Understand the basics of linear programming and how to use Excel’s Solver to optimize resources to reach a desired outcome.
Program Overview
Spreadsheets: A Tool for Thinking with Numbers
⏳ 1 hour
-
Introduction to the history and basic capabilities of spreadsheets.
-
Understanding different types of data and spreadsheet notations.
-
Learning common built-in formulas and functions.
-
Using conditional expressions and understanding relative and absolute references.
-
Identifying and correcting common errors in spreadsheets.
From Spreadsheet to Model
⏳ 1 hour
-
Structuring a spreadsheet to model variables, objectives, and objective functions.
-
Constructing simple cashflow models.
-
Conducting what-if analysis and sensitivity analysis.
-
Understanding the limitations of simple, deterministic models.
Addressing Uncertainty and Probability in Models
⏳ 1 hour
-
Understanding random variables and probability distributions.
-
Applying power, exponential, and logarithmic functions in model formulas.
-
Creating probability trees and decision trees.
-
Using regression tools to make predictions.
Simulation and Optimization
⏳ 1 hour
-
Implementing Monte Carlo simulations in spreadsheets.
-
Using linear programming for optimization.
-
Utilizing Excel’s Solver to optimize resources.
-
Identifying the similarities and differences between Excel and Sheets
Get certificate
Job Outlook
-
Proficiency in spreadsheet modeling is valuable for roles such as Financial Analyst, Business Analyst, Operations Manager, and Data Analyst.
-
Skills acquired in this course are applicable across various industries, including finance, consulting, marketing, and operations.
-
Completing this course can enhance your qualifications for positions that require analytical thinking and data-driven decision-making.
