Skill path · IntermediateLive
Excel for Financial Modeling
Named ranges, scenarios, sensitivity, NPV, IRR, XIRR and dynamic ranges.
14 exercises · 2 h · 35 checked cells
No lesson of this path is free: every exercise needs full access.
The route
- 1Named RangesModel Mechanics3 exercises · 24 minFull access
- 2Scenario SwitchingModel Mechanics3 exercises · 24 minFull access
- 3Sensitivity Without Data TablesModel Mechanics2 exercises · 15 minFull access
- 4Financial Functions (NPV, IRR)Financial Functions4 exercises · 30 minFull access
- 5Dynamic Ranges & Array FormulasFinancial Functions2 exercises · 30 minFull access
What it ends in
A FinX certificate of completion, which anyone can verify by link.
Questions
- How long does Excel for Financial Modeling take?
- About 2 h: 14 exercises in 5 lessons, with 35 checked cells between them. Times are estimates from writing the lessons.
- What can I do for free?
- None of this path's lessons is free: every exercise needs full access, and See the first lesson opens its first one with the full access offer. To see how checking works before you pay, Excel Formulas and Functions has free lessons in the same course.
- Do I need Excel installed?
- No. Every exercise runs in a spreadsheet in your browser, and each answer is checked cell by cell, so you see exactly which cell is wrong.
- What do I get at the end?
- A FinX certificate of completion, which anyone can verify by link.
- Which career paths include it?
- Financial Analyst, Investment Banking Analyst, Private Equity Associate, Business and Operations Analyst, FP&A Analyst, Real Estate Analyst and Project Finance Analyst. A career path strings skill paths together in the order a job uses them.