Sumários

Project 3: Capital Budgeting

2 Abril 2025, 16:00 • Luís Miguel da Silva 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 Miguel da Silva 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 Miguel da Silva 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 Miguel da Silva 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 Miguel da Silva Laureano

Learn how to use visualization tools 

Learn how to use sparklines 
Learn about charting in Excel