Sumários
Recorded macros
9 Abril 2025, 16:00 • Luís 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
3 Abril 2025, 16:00 • Luís 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)
Project 3: Capital Budgeting
2 Abril 2025, 16:00 • Luís Laureano
Construct a financial model for capital budgeting analysis
Apply excel functions, formulas, formatting, names and data validation
Project 2: loan modeling
27 Março 2025, 16:00 • Luís Laureano
Construct financial models for loans with constant installments
Apply excel functions, namely conditional and financial functions
Apply excel array formulas, names, data validation and conditional formatting