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.
Specification: Introduction to Spreadsheets and Models
|
