Sumários

Project 3: Capital Budgeting

2 Abril 2025, 16:00 • Luís Laureano

Construct a financial model for capital budgeting analysis 

Apply excel functions, formulas, formatting, names and data validation

Project 2: loan modeling

27 Março 2025, 16:00 • Luís Laureano

Construct financial models for loans with constant installments 

Apply excel functions, namely conditional and financial functions 
Apply excel array formulas, names, data validation and conditional formatting

Project 1: loan modeling V_2

26 Março 2025, 16:00 • Luís Laureano

Construct a financial model for a loan with constant capital reimbursement.


Apply excel functions, names and data validation.

Project 1: loan modeling. Individual Evaluation

20 Março 2025, 16:00 • Luís Laureano

Construct a financial model for a loan with constant capital reimbursement.


Apply excel functions, names and data validation.

Individual Evaluation 02.

Reporting your data

19 Março 2025, 16:00 • Luís Laureano

Learn how to use visualization tools 

Learn how to use sparklines 
Learn about charting in Excel