Sumários
Group Assignment - Presentations. Individual Assignment 02
29 Abril 2026, 17:30 • Luís Miguel da Silva Laureano
Group Assignment - Presentations.
Individual Assignment 02.
Group Assignment - Presentations
29 Abril 2026, 16:00 • Luís Miguel da Silva Laureano
Group Assignment - Presentations
Recorded macros
22 Abril 2026, 17:30 • Luís Miguel da Silva Laureano
- Learn how to use the macro Recorder to record a macro
- Learn how to run and assign a macro
- Learn how to edit, copy and delete a macro
Project 4: Capital Budgeting - Risk Analysis
22 Abril 2026, 16:00 • Luís Miguel da Silva Laureano
- Analyse the risk of the project
- Apply excel functions, formulas, formatting, names and data validation
- Apply Excel commands of What if Analysis (Goal Seek, Data Tables and Scenario Manager)
Projects 1 and 2: loan modeling
15 Abril 2026, 17:30 • Luís Miguel da Silva Laureano
| 1) | Construct a financial model for a loan with constant capital reimbursement |
| 2) | Construct a financial model for a loan with constant installments |
| 3) | Apply excel functions, names and data validation |