Description
Excel is a programming language in and of itself. In this power-packed course, you’ll use Excel and Visual Basic for Apps (VBA) for some serious financial number-crunching. You’ll cover risk modeling, factor analysis, numerical optimization, and linear and logistic regression in your quest to become a competent financial modeler.
- Access 50 lectures & 12 hours of content 24/7
- Model risk using covariance matrices & historical returns
- Understand principal components, Eigen values & Eigen vectors
- Apply PCA to explain the returns of a technology stock like Apple
- Study various extensions to the Simplex method, including K-of-N constraints & quadratic objective functions
- Interpret regression results & avoid common pitfalls
Reviews for Advanced Excel and VBA for Financial Modeling
Click Here to Read Reviews for Advanced Excel and VBA for Financial Modeling >> Click Here to Submit Reviews for Advanced Excel and VBA for Financial Modeling >>