Sumários

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

Getting to know your Data

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

Learn how to extract information from your data using Pivot Tables

Learn how to do summary reports
Learn about Slicers and Timelines