Sumários

Mock Exam

10 Abril 2025, 16:00 Luís Laureano


Solving last year's test.

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