Recorded macros

22 Abril 2026, 17:30 • Luís Miguel da Silva Laureano

---

1. Learn how to use the macro Recorder to record a macro
2. Learn how to run and assign a macro
3. 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

---

1. Analyse the risk of the project
2. Apply excel functions, formulas, formatting, names and data validation
3. 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

Reporting your data

15 Abril 2026, 16:00 • Luís Miguel da Silva Laureano

---

1)	Learn how to use visualization tools
2)	Learn how to use sparklines
3)	Learn about charting in Excel

Getting to know your Data

25 Março 2026, 17:30 • Luís Miguel da Silva Laureano

---

Learn how to extract information from your data using PivotBy() (continued)