Excel for Financial Modeling - Functions & Formulas Practice Workbook
Originally published: 29/06/2026 08:07
Publication number: ELQ-68740-1
View all versions & Certificate
certified

Excel for Financial Modeling - Functions & Formulas Practice Workbook

The Excel functions every financial modeler needs, in one interactive workbook.

Description
If you're interested in project finance modeling but feel your Excel skills need strengthening first, this workbook is the ideal starting point. 


It contains practical, hands-on exercises covering the Excel functions and techniques used in professional financial models, including:
Referencing, 
named ranges, 
dates, 
logical functions, 
XLOOKUP, 
SUMIFS, 
SUMPRODUCT, 
NPV/XNPV, 
IRR/XIRR, 
PMT functions, 
data validation, 
conditional formatting, 
goal seek, 
data tables, 
circularity, 
corkscrew schedules, 
LAMBDA functions,
 and introductory VBA user-defined functions. 

Each exercise is designed to help you build speed, accuracy, and confidence while working with formulas commonly found in project finance models. 

Rather than learning Excel in isolation, you'll develop the skills that matter in real-world financial modeling. 
Whether you're preparing for a project finance course, an interview, or your first modeling assignment, this workbook provides a structured way to bridge the gap between basic Excel knowledge and professional financial modeling. 

Download it, work through the exercises at your own pace, and build a solid Excel foundation before tackling complete project finance models.

This Best Practice includes
1 Excel File

FinExMod offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


0.0 / 5 (0 votes)

please wait...