Courses

Advanced Excel and VBA for Financial Modeling


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

Loonycorn 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.

All products featured here are selected by Gadgeteur team. If you buy something, Gadgeteur may earn an affiliate commission. Some offers are only valid for U.S.A. country. Some applications or software may be available internationally but in some cases are developed only in English Language and all the prices are shown in USD. Is responsibility of the buyer to assure the right price, taxes, shipping and language available.

Todos los productos presentados aquí son seleccionados por el equipo de Gadgeteur. Si compras algo, Gadgeteur puede ganar una comisión de afiliado. Algunas ofertas solo son válidas para el país de EE. UU. Algunas aplicaciones o software pueden estar disponibles internacionalmente, pero en algunos casos se desarrollan solo en inglés y todos los precios se muestran en USD. Es responsabilidad del comprador asegurar el precio correcto, los impuestos, el envío y el idioma disponible.

Etiquetas
Botón volver arriba

Usamos cookies para brindarle la mejor experiencia en línea. Al aceptar que acepta el uso de cookies de acuerdo con nuestra política de cookies.