Postgraduate Certificate in Excel Financial Tools for Portfolio Management
-- viendo ahoraThe Postgraduate Certificate in Excel Financial Tools for Portfolio Management is a career-advancing course designed for finance professionals. This certificate focuses on enhancing the learner's ability to utilize advanced Excel functions for financial modeling, portfolio management, and data analysis.
4.395+
Students enrolled
GBP £ 140
GBP £ 202
Save 44% with our special offer
Acerca de este curso
HundredPercentOnline
LearnFromAnywhere
ShareableCertificate
AddToLinkedIn
TwoMonthsToComplete
AtTwoThreeHoursAWeek
StartAnytime
Sin perรญodo de espera
Detalles del Curso
โข Advanced Excel Functions for Finance:
This unit will cover advanced Excel functions such as XNPV, XIRR, and GOAL Seek, which are commonly used in financial analysis and modeling.
โข Time Series Analysis in Excel:
This unit will focus on how to use Excel to analyze time series data, including the use of charting tools and regression analysis.
โข Data Modeling and Pivot Tables for Portfolio Management:
In this unit, students will learn how to create and use data models and pivot tables to manage and analyze financial portfolios.
โข Building Financial Models in Excel:
This unit will cover best practices for building financial models in Excel, including the use of scenario analysis and sensitivity analysis.
โข Excel Tools for Risk Management:
This unit will explore the use of Excel tools such as Monte Carlo simulation and @RISK for managing financial risk.
โข Portfolio Optimization in Excel:
In this unit, students will learn how to use Excel to optimize financial portfolios, including the use of linear programming and the Solver add-in.
โข Advanced Data Visualization in Excel:
This unit will focus on advanced techniques for data visualization in Excel, including the use of 3D charts and dashboards.
โข Automating Financial Analysis with Excel:
In this unit, students will learn how to automate financial analysis tasks in Excel using macros and VBA programming.
โข Excel Tools for Financial Statement Analysis:
This unit will explore the use of Excel tools for analyzing financial statements, including the use of ratios and common size analysis.
Trayectoria Profesional
Requisitos de Entrada
- Comprensiรณn bรกsica de la materia
- Competencia en idioma inglรฉs
- Acceso a computadora e internet
- Habilidades bรกsicas de computadora
- Dedicaciรณn para completar el curso
No se requieren calificaciones formales previas. El curso estรก diseรฑado para la accesibilidad.
Estado del Curso
Este curso proporciona conocimientos y habilidades prรกcticas para el desarrollo profesional. Es:
- No acreditado por un organismo reconocido
- No regulado por una instituciรณn autorizada
- Complementario a las calificaciones formales
Recibirรกs un certificado de finalizaciรณn al completar exitosamente el curso.
Por quรฉ la gente nos elige para su carrera
Cargando reseรฑas...
Preguntas Frecuentes
Tarifa del curso
- 3-4 horas por semana
- Entrega temprana del certificado
- Inscripciรณn abierta - comienza cuando quieras
- 2-3 horas por semana
- Entrega regular del certificado
- Inscripciรณn abierta - comienza cuando quieras
- Acceso completo al curso
- Certificado digital
- Materiales del curso
Obtener informaciรณn del curso
Obtener un certificado de carrera