Sumários
.
27 Abril 2022, 16:00 • Rita Sousa
| 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 | ||
| 4) | Learn how to create a User Defined Functions | ||
| 5) | Learn how to use a UDF | ||
| 6) | Learn how to create and use an Addin | ||
.
7 Abril 2022, 16:00 • Rita Sousa
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)
.
6 Abril 2022, 16:00 • Rita Sousa
1) Construct a financial model for capital budgeting analysis
2) Apply excel functions, formulas, formatting, names and data validation
Financial Models - Loan Modeling - Project 2 (continued)
31 Março 2022, 16:00 • Rita Sousa
Project 2 (continued)
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