Advanced Excel and VBA for Financial Modeling (49% discount)

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

via Ashraf