Advanced Excel and VBA for Financial Modeling

Advanced Excel and VBA for Financial Modeling

12 Hours
$10.00$19.99
You save 49%
Advanced Excel and VBA for Financial Modeling

50 Lessons (12h)

  • You, This Course and Us
  • Introducing Risk management
  • Outlining an Approach to Risk Management
  • RIsk Modeling in Excel/VBA
  • Factor Analysis and PCA
  • Basic Statistics Required for PCA
  • Diving into Principal Components Analysis
  • PCA in Excel
  • Introducing Numerical Optimisation
  • Linear Programming and the Simplex Method
  • Implementing Linear Programming in Excel
  • Understanding Integer Programming
  • Implementing Integer Programming in Excel
  • Connect the Dots with Linear Regression
  • Basic Statistics Used for Regression
  • Simple Regression
  • Applying Simple Regression
  • Multiple Regression
  • Applying Multiple Regression using Excel
  • Logistic Regression for Categorical Dependent Variables
  • Solving Logistic Regression
  • Applying Logistic Regression
DescriptionInstructorImportant DetailsRelated Products

Perform Risk Modeling, Optimization, Factor Analysis & Regression with Excel

L
LoonycornLoonycorn is comprised of two individuals—Janani Ravi and Vitthal Srinivasan—who have honed their respective tech expertise at Google and Flipkart. The duo graduated from Stanford University and believes it has distilled the instruction of complicated tech concepts into funny, practical, engaging courses, and is excited to be sharing its content with eager students.

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

Specs

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...