Excel — Finance · Course on Udemy

Build financial models in Excel, from a blank file to a DCF valuation

Plan, build and test models the way finance teams use them: a three-statement model, project costing, DCF and a 13-week cash flow forecast.

★ 4.6 from 1,442 ratings on Udemy · 150 lessons · 15.5 hours

Enroll on Udemy →Watch a free lesson first

30-day refund through Udemy · Lifetime access · Certificate of completion

Watch the course trailer (4:48)

Is this course for you?

A good model answers “what if?” in seconds instead of days.

You will get the most from it if you…

work in finance, accounting or a business role that runs on numbers
build budgets and forecasts in Excel today
want to see how a DCF or three-statement model is put together
need models other people can read, check and trust

By the end you will be able to…

plan a model around the question it has to answer
build a linked P&L, cash flow statement and balance sheet
value a project or business with discounted cash flow
test scenarios with what-if analysis and Goal Seek
present results with charts and a financial KPI dashboard

Want the dashboard side in depth? See the Excel Dashboard Masterclass.

The models you will build

Each one built step by step, with scenarios you can change.

01Three-statement modelP&L, cash flow and balance sheet

02Project costing modelOperations, financing and cash flow

03DCF valuationIncluding perpetual growth

04Activity-based costingLabour, activities and output

0513-week cash flow forecastThe milestone project

What is inside

Four parts, from planning a model to five complete builds.

1. Planning and tools

What financial modelling is and why it matters, planning and documenting a model, cell referencing, named and dynamic ranges, data validation, and scenarios with what-if analysis.

2. Functions for finance

Essential, financial and advanced functions, financial analysis with functions, and shortcuts for speed and accuracy.

3. Charts and Excel for accountants

Charts that present model output, then formulas for accounting, cash flow budgeting, a P&L, record-keeping and pivot tables for accountants.

4. The models

A three-statement model, project costing, DCF, activity-based costing, the 13-week cash flow forecast and a financial KPI dashboard. Bonus lessons cover fan charts and Marimekko charts.

What students say

Reviews from students of this course on Udemy.

“The course provides not only basic financial modelling skills but also applies it in an accounting context, which is important for CA's to understand.”Tass D.

“This course is high quality and I recommend it to anyone who wants to develop skills in financial modeling. That being said, the course is challenging and at times involves long and complex formulas.”Aleksandar N.

“Started off a bit basic to get everyone to the same level. But super happy I continued to the end as I learned a lot. Great course.”Paul M.

What is included

150 video lessons, 15.5 hours
Course files to follow along
Lifetime access on any device, including the Udemy app for offline viewing
Certificate of completion
A Q&A section on every lesson
30-day refund through Udemy

Your instructor

Andreas Exadaktylos, MSc in Computer Science, has taught Excel for over 25 years and runs Mellon Training.

More than 80,000 students have taken his courses on Udemy. He also publishes free Excel tutorials on YouTube and on this site.

Questions before you start

Anything else? Write to info@mellontraining.com.

Do I need a finance background?

No finance degree is needed, but you should be comfortable with everyday Excel. Each statement and model is built step by step.

Which version of Excel do I need?

A recent version of Excel. A few lessons use dynamic array functions such as UNIQUE, which need Microsoft 365 or Excel 2021.

Where is the course hosted?

On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.

What if it is not right for me?

Udemy offers a refund within 30 days of purchase, under its refund policy.

Can I see a lesson before I buy?

Yes. Watch the free fan chart lesson on this site, or the preview lessons on the Udemy course page.

Ready to build your first model?

150 lessons, five complete models, and a financial KPI dashboard.

Enroll on Udemy →