Modeling for Business
Build Your First Model
If you need help in building a financial model for your department, then Excel’s financial modelling features can streamline that task for you. In this course, you’ll learn how to build a pricing model from scratch, so that your key stakeholders can make decisions based on the insights your model delivers.
Intermediate    18 Lessons    150 Minutes    CPD Credits
About This Course
Your data can tell you a lot about the future, as well as the present. This course will teach you to use Excel’s financial models to analyze potential risks or benefits of a potential business decision.
Across the 18 lessons, you’ll learn how to frame the problem, analyze risks, complete sensitivity checks, and deliver recommendations.
By the end of the course, you’ll feel confident in running a financial model, knowing that your data is clean and your insights are impactful.
Learning Outcomes
-
Outline the stages involved in modeling a business problem
-
Develop an influence diagram for a business problem
-
Model a business problem in Excel
-
Conduct a sensitivity analysis using a data table
-
Calculate the values in a model
-
Solve modeling problems using Goalseek and Solver
-
Model different scenarios using Pivot Tables
-
Deliver the conclusions of an Excel model
-
Outline the limitations of an Excel model
Lessons
1. Introduction to Modeling
2. Framing the Problem
4. Diagram the Problem - Part 2
5. Lay Out Model in Excel
6. Build Simplified Model
Read More
7. Sensitivity Analysis
8. Prepare Your Dataset for Modeling
9. Estimating Market Demand
10. Complex Model formulas
11. Perform Checks on Model
12. Calculate Model Outputs
13. Analyze Risks in Our Model
14. Goalseek and Solver
15. Run Scenarios Using Pivot Tables
16. Charts for Sensitivity Tables
17. Recommendations to the Client
18. Limitations of the Model
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
