Objectives
The main objective of this seminar is to help participants use the Excel spreadsheet for a large number of applications in finances.

The functionality of Excel will be described for financial mathematical operations such as discount, valuation, loans and credits and other financial utilities. In addition, an introduction will be given into its use in statistical applications of probabilities, time series, correlations, etc., of great use in market forecast and financial instruments

Both the standard uses of Excel will be used and the development with advanced tools and macros.

Participants
All financial professionals and final-year university students who wish to improve their abilities to use Excel for their work or projects.

Programme
1. The Excel work environment

2. Quantitative methods for finances through Excel

2.1.  Basic statistics
2.2.  Probability models applied to finances. Uncertainty
2.3.  Analysis of time series
2.4.  Correlation and causal models. Valuation models
2.5.  Applications with Microsoft®Excel: MacroFunctions
2.6.  Applications with the macro: Analysis tools
2.7.  Advanced tools

- Solver Macro: optimisation models
- Search for objects
- Generation of scenarios
- Dynamic tables
- Macros@Risk/: Montecarlo simulation tools 
- Matrix calculation. Estimation of VaR  

3. Financial mathematics for finances through Excel

3.1.  Use of Excel financial functions
3.2.  Functions of interest
3.3.  Discount functions
3.4.  Valuation of assets
3.5.  Loans and credits
3.6.  Other financial applications
3.7.  Applications with Microsoft®Excel: MacroFunctions  

4. Development of solutions in Visual Basic Applications (VBA)

4.1. Construction of macros
4.2. MonteCarlo Simulation in VBA 

The course will be held in the data-processing classroom

Dates:  July

Hours:  From 18:00 to 21:00 h

Duration:  27 hours

Place:  IEF Classrooms, Gran Vía, 670, 2n, - 08010 Barcelona