Sumários
User Defined Functions (UDFs)
29 Abril 2021, 16:00 • Rita Sousa
| 1) | Learn how to create a User Defined Functions | ||
| 2) | Learn how to use a UDF | ||
| 3) | Learn how to create and use an Addin | ||
.
28 Abril 2021, 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 | ||
Financial Modeling - Capital Budgeting - Risk Analysis - Project 4
22 Abril 2021, 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) | ||