Advanced levelFinance and accounting
Financial modelling in Excel
A linked three-statement model, cash flow, NPV and IRR, scenarios and sensitivity tables; you finish with a model of your own project.
- Hours
- 40
- Length
- 8–10 weeks
- Group
- up to 14 people
- Format
- In class
- Taught in
- AZ, RU
Next groups
A group is certain to run once six people enrol. Enrolment closes at 18:00 the day before the first lesson.
| Dates | Days and time | Language | Format | Seats | Enrol in this group |
|---|---|---|---|---|---|
| Mon 2 Nov – Mon 28 Dec16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | SeatsFullGroup confirmed | Full |
| Sat 5 Dec – Sat 13 Feb10 lessons | Days and timeSaturday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats13 seats left | Enrol in this group |
| Mon 28 Dec – Wed 17 Feb16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats5 seats leftGroup confirmed | Enrol in this group |
| Sat 30 Jan – Sat 10 Apr10 lessons | Days and timeSaturday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats2 seats leftGroup confirmed | Enrol in this group |
| Mon 22 Feb – Mon 26 Apr16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats6 seats leftGroup confirmed | Enrol in this group |
| Sat 27 Mar – Sat 29 May10 lessons | Days and timeSaturday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats11 seats left | Enrol in this group |
Programme
- Model structure: inputs, workings, outputs, checks4 h
- The linked three-statement model10 h
- Cash flow, NPV, IRR and payback8 h
- Scenarios, sensitivity tables and Data Table8 h
- Loans, leasing and an investment project6 h
- Presenting to management and reviewing a model4 h
- Total40 h
After the course you will be able to
- Build a linked five-year model of a project or a company
- Keep a model tidy enough for someone else to check
- Compare scenarios and give a number for the decision
What you need first
Confident Excel (VLOOKUP, IF, pivots) and reading financial statements.
Tools
- Microsoft Excel
Final project and certificate
A model of your own or a given investment project: three scenarios, sensitivity and five slides for management.
The certificate goes to those who attend 80% of the lessons and score above 60 on the final project. It is the academy’s own certificate, not a state document; its number can be checked on this site.
Check a certificateCertificate
Awarded to
Name Surname
«Financial modelling in Excel» for completing the course
Length: 40 hours · Final project: 91/100
No. PS-2026-···· · verify at pilleakademiya.az/certificates
Instructors
Tural Ismayilov
Financial modelling in Excel
Investment analyst at a holding company, 11 years in the trade
Profile and a free consultation
Before and after this course
All courses in the field: Finance and accountingQuestions
Which version of Excel do I need?
Microsoft 365 or Excel 2021. The lab has it; if you bring your own laptop, reception checks the version.
Can I get my money back if I change my mind?
Until the first lesson you get back everything you paid. After the start, the lessons not yet held are refunded, to the card within 10 working days. Cancel on the “Your enrolment” page with the number and your phone.
Can I move to another group?
Yes, once and free, until 3 days before the start: choose another group of the same course on the “Your enrolment” page.
This course for your team
We can run the course at your office or online for your staff only, with examples from your company’s own data.