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