Sumários

Project 2: loan modeling

10 Abril 2024, 16:00 Luís Laureano


  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

Project 1: loan modeling. Individual assignment 02.

21 Março 2024, 16:00 Luís Laureano


Construct a financial model for a loan with constant capital reimbursement

Apply excel functions, names and data validation

Individual assignment 02

Project 1: loan modeling

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


Construct a financial model for a loan with constant capital reimbursement


Apply excel functions, names and data validation

Reporting your data

14 Março 2024, 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 2024, 16:00 Luís Laureano


Getting to know your Data

• Learn how to extract information from your data using Pivot Tables
• Learn how to do summary reports
• Learn about Slicers and Timelines