Skip to main content
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
Start Today

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.

Start Today

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


1. Introduction to Modeling
2. Framing the Problem
3. Diagram 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.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world