Sumários

Financial Models - Loan Model - Project 1 (continued) Project 2

30 Março 2022, 16:00 Rita Sousa


Project 1

1) Construct financial models for a loan with constant capital reimbursement
2) Apply excel functions, names and data validation

Project 2

1) Construct financial models for loans with constant installments
2) Apply excel functions, namely conditional and financial functions
3) Apply excel array formulas, names, data validation and conditional formatting

.

24 Março 2022, 16:00 Rita Sousa


1) Construct financial models for a loan with constant capital reimbursement

2) Apply excel functions, names and data validation

.

23 Março 2022, 16:00 Rita Sousa


Continued..

1) Learn how to use visualization tools

2) Learn how to use sparklines

3) Learn about charting in Excel

Individual Assignment

.

17 Março 2022, 16:00 Rita Sousa


1) Learn how to use visualization tools

2) Learn how to use sparklines

3) Learn about charting in Excel

.

16 Março 2022, 16:00 Rita Sousa


1) Learn how to extract information from your data using Pivot Tables

2) Learn how to do summary reports

3) Learn about Slicers and Timelines