Skip to content

Please log in or enroll below to view lessons in this course.

Free courseIntermediate

Portfolio Analytics & Risk Management

Master portfolio analytics, risk measurement, and portfolio optimization using Excel and Google Sheets.

  • 100lessons
  • 13modules
  • 54videos
  • 10calculators
  • 11quizzes

Freeself-paced · certificate included

A free account saves your progress and quiz scores.

What you'll learn

  • Calculate risk-adjusted returns using Sharpe, Treynor, and Jensen's Alpha
  • Build and optimize portfolios using Modern Portfolio Theory in Excel
  • Measure and manage Value at Risk using parametric, historical, and Monte Carlo methods
  • Create live portfolio dashboards in Excel and Google Sheets
  • Interpret return distributions and tail risk, and evaluate leverage, funding stress and portfolio decisions.

What's inside

  • 54 video lessons

    Short explainers and step-by-step builds you can pause and replay.

  • 10 calculators & web apps
  • 11 quizzes
  • 25 written guides
  • Tools you'll use
    • Excel
    • Google Sheets
  • Earn a certificate

    Finish every lesson to unlock a shareable certificate with its own verification link.

Curriculum

100 lessons · 13 modules · About 15 hours 15 minutes

Course map

  1. 01Risk & Return Fundamentals12 lessons · 1.4 h
  2. 02Modern Portfolio Theory10 lessons · 1.6 h
  3. 03Multi-Asset Portfolio Analysis7 lessons · 1 h
  4. 04Portfolio Performance Metrics18 lessons · 2.5 h
  5. 05Value at Risk — Theory7 lessons · 46 min
  6. 06Value at Risk — Excel3 lessons · 22 min
  7. 07Portfolio Construction & Leverage9 lessons · 1.5 h
  8. 08Portfolio Tracking & Dashboards5 lessons · 1.6 h
  9. 09Advanced Topics6 lessons · 58 min
  10. 10Trading Fundamentals5 lessons · 39 min
  11. 11Return Measurement and Portfolio Decisions8 lessons · 1.1 h
  12. 12Return Distributions and Tail Risk4 lessons · 37 min
  13. 13Leverage and Risk in Practice6 lessons · 1 h

  1. Module 1: Risk & Return Fundamentals

    12 lessons1.4 h
    1. Video: Stock Annual Return & Standard Deviation in Excel 5 min
    2. Article: Standard Deviation & Volatility: Complete Guide 10 min
    3. Video: Log Returns in Finance: Continuous Compounding and Euler’s Number Explained 14 min
    4. Video: Systematic Vs Unsystematic Risk Explained 5 min
    5. Article: Systematic vs Unsystematic Risk: Complete Guide 10 min
    6. Calculator: Diversification Ratio Calculator 5 min
    7. Video: Beta In Finance Explained 5 min
    8. Article: Beta in Finance: Complete Guide 8 min
    9. Video: How to Estimate the Beta of a Stock in Excel 3 min
    10. Calculator: Beta Calculator 5 min
    11. Calculator: Portfolio Beta Calculator 5 min
    12. Quiz: Module 1 Quiz: Risk & Return Fundamentals 10 min
  2. Module 2: Modern Portfolio Theory

    10 lessons1.6 h
    1. Video: Efficient Frontier and Portfolio Optimization Explained 13 min
    2. Calculator: Correlation Calculator 5 min
    3. Calculator: Covariance Calculator 5 min
    4. Article: Correlation & Covariance in Finance: Complete Guide 10 min
    5. Article: Portfolio Diversification: Complete Guide 10 min
    6. Video: Graph The Efficient Frontier And Capital Allocation Line In Excel 9 min
    7. Video: Calculating the Optimal Portfolio in Excel 9 min
    8. Article: Efficient Frontier & Portfolio Optimization: Complete Guide 12 min
    9. Video: Portfolio Optimization in Excel: Step by Step Tutorial 15 min
    10. Quiz: Module 2 Quiz: Modern Portfolio Theory 10 min
  3. Module 3: Multi-Asset Portfolio Analysis

    7 lessons1 h
    1. Video: Mastering Multi-Asset Portfolio Analysis in Excel 15 min
    2. Video: Portfolio Standard Deviation Calculation Explained in Excel 6 min
    3. Calculator: Portfolio Variance Calculator 5 min
    4. Video: CAPM & Security Market Line Explained 8 min
    5. Calculator: CAPM Calculator 5 min
    6. Article: CAPM (Capital Asset Pricing Model): Complete Guide 12 min
    7. Quiz: Module 3 Quiz: Multi-Asset Portfolio Analysis 10 min
  4. Module 4: Portfolio Performance Metrics

    18 lessons2.5 h
    1. Video: Sharpe Ratio Vs Treynor Ratio Explained 4 min
    2. Video: Calculate Sharpe Ratio In Excel 4 min
    3. Calculator: Sharpe Ratio Calculator 5 min
    4. Article: Sharpe Ratio: Complete Guide 12 min
    5. Video: Investment Performance Evaluation: Sharpe, Treynor & Jensen’s Alpha 9 min
    6. Calculator: Treynor Ratio Calculator 5 min
    7. Article: Treynor Ratio: Complete Guide 10 min
    8. Calculator: Jensen’s Alpha Calculator 5 min
    9. Article: Jensen’s Alpha: Complete Guide 10 min
    10. Video: Mastering the Information Ratio & Tracking Error in Excel 12 min
    11. Article: Information Ratio & Tracking Error: Complete Guide 10 min
    12. Video: Tracking Error Explained 5 min
    13. Video: Up Capture & Down Capture Ratios in Excel 10 min
    14. Article: Time-Weighted vs Money-Weighted Return: Complete Guide 10 min
    15. Article: Annualized Return (CAGR): Complete Guide 10 min
    16. Video: Maximum Drawdown Calculation Explained in Excel 5 min
    17. Article: Maximum Drawdown: Complete Guide 10 min
    18. Quiz: Module 4 Quiz: Portfolio Performance Metrics 15 min
  5. Module 5: Value at Risk — Theory

    7 lessons46 min
    1. Video: Value at Risk Explained 5 min
    2. Video: VaR: Parametric Method Explained 4 min
    3. Video: VaR: Historical Method Explained 2 min
    4. Video: VaR: Monte Carlo Method Explained 3 min
    5. Article: Value at Risk (VaR): Complete Guide 12 min
    6. Article: Expected Shortfall (CVaR): Complete Guide 10 min
    7. Quiz: Module 5 Quiz: Value at Risk Theory 10 min
  6. Module 6: Value at Risk — Excel

    3 lessons22 min
    1. Video: Parametric Method: Value at Risk (VaR) In Excel 7 min
    2. Video: Historical Method: Value at Risk (VaR) In Excel 5 min
    3. Video: Monte Carlo Method: Value at Risk (VaR) In Excel 10 min
  7. Module 7: Portfolio Construction & Leverage

    9 lessons1.5 h
    1. Video: Financial Leverage Explained 4 min
    2. Article: Financial Leverage in Investing: Complete Guide 10 min
    3. Video: Margin Trading & Leverage: Is It Worth the Risk? 17 min
    4. Article: Margin Trading: Complete Guide 10 min
    5. Video: Long/Short Portfolios Explained 9 min
    6. Video: Should You Buy Leveraged ETFs Long Term? 13 min
    7. Article: Leveraged ETFs — Long-Term Analysis: Complete Guide 10 min
    8. Video: Equity Futures: Risk Management & Portfolio Hedging 8 min
    9. Quiz: Module 7 Quiz: Portfolio Construction & Leverage 10 min
  8. Module 8: Portfolio Tracking & Dashboards

    5 lessons1.6 h
    1. Video: LIVE Stock Portfolio Dashboard in Excel 30 min
    2. Video: Create a Live Stock Portfolio Tracker in Excel (No Office 365) 21 min
    3. Video: Build a Stock Tracker in Google Sheets 20 min
    4. Video: Live Stock Portfolio Tracking: Different Exchanges & Currencies 7 min
    5. Video: LIVE Crypto Portfolio Tracker in Excel 15 min
  9. Module 9: Advanced Topics

    6 lessons58 min
    1. Video: Stock Portfolio Monte Carlo Simulation In Excel 8 min
    2. Article: Monte Carlo Simulation: Complete Guide 10 min
    3. Video: Portfolio Rebalancing Explained 6 min
    4. Article: Portfolio Rebalancing Strategies: Complete Guide 10 min
    5. Video: How Long Will Your Retirement Savings Last? 14 min
    6. Quiz: Module 9 Quiz: Advanced Topics 10 min
  10. Module 10: Trading Fundamentals

    5 lessons39 min
    1. Video: What Is the Bid-Ask Spread? 6 min
    2. Video: Order Types Explained: Market, Limit & Stop Orders 7 min
    3. Article: Trading Execution — Order Types, Spreads & Slippage: Complete Guide 10 min
    4. Video: Margin Trading Explained 6 min
    5. Quiz: Module 10 Quiz: Trading Fundamentals 10 min
  11. Module 11: Return Measurement and Portfolio Decisions

    8 lessons1.1 h
    1. Video: Standard Deviation in Finance: Volatility Explained 5 min
    2. Video: How to Annualize Monthly Returns in Excel (Simple vs Log + Standard Deviation) 6 min
    3. Video: Correlation Explained in 6 Minutes 6 min
    4. Video: Modern Portfolio Theory Explained: The Math Behind Diversification 5 min
    5. Video: What is the Sharpe Ratio? Risk-Adjusted Returns Explained 4 min
    6. Video: Dollar-Cost Averaging Explained | Better Than Timing the Market? 4 min
    7. Article: Practice: Measuring Returns and Comparing Portfolio Decisions 25 min
    8. Quiz: Module 11 Quiz: Return Measurement and Portfolio Decisions 10 min
  12. Module 12: Return Distributions and Tail Risk

    4 lessons37 min
    1. Video: Normal Distribution in Finance Explained 6 min
    2. Video: Skewness and Kurtosis Explained | Stock Market Example 6 min
    3. Article: Practice: Reading Portfolio Tails Beyond Average and Volatility 15 min
    4. Quiz: Module 12 Quiz: Return Distributions and Tail Risk 10 min
  13. Module 13: Leverage and Risk in Practice

    6 lessons1 h
    1. Video: Futures Contracts Explained: A Complete Beginner’s Guide 6 min
    2. Video: The Carry Trade Explained | How Traders Profit from Interest Rates 8 min
    3. Video: Is Buying a Home Actually Riskier Than Stocks? 8 min
    4. Video: The Hedge Fund That Nearly Froze the Financial System | LTCM 10 min
    5. Article: Practice: Exposure, Equity and Funding Under Stress 20 min
    6. Quiz: Module 13 Quiz: Leverage and Risk in Practice 10 min

Who this course is for

  • Investors who manage their own portfolio and want to measure it properly
  • Finance students working through CFA- or FRM-style portfolio and risk topics
  • Analysts who build portfolio reports in Excel or Google Sheets

Before you start

  • Comfort with basic Excel formulas and cell references
  • No portfolio theory needed: Module 1 starts with return and risk
Ryan O'Connell

Your instructor

Ryan O'Connell, CFA, FRM

I went from Fortune 500 quantitative risk analyst to teaching finance to hundreds of thousands of people on YouTube. These courses are the structured version of that teaching: the theory, the formulas, and the Excel and platform work that make them useful.

  • 81.4KYouTube subscribers
  • 6.8MYouTube views
  • 9+years in finance
  • CFA charterholder
  • FRM certified
  • MS Finance, Texas A&M
  • MCIT, University of Pennsylvania
  • CFA Institute
  • University of Pennsylvania
  • Texas A&M University
More about Ryan

Questions

Is this course really free?

Yes. Every lesson, calculator and quiz in this course is free.

Do I need an account?

You can browse the curriculum without one. A free account lets you take the lessons, save your progress and earn the certificate.

What software do I need?

Microsoft Excel (or a compatible spreadsheet) and Google Sheets, plus a web browser. The calculators run in your browser.

Do I get a certificate?

Yes. Finish every lesson to earn a certificate of completion with its own verification link.

Is this investment advice?

No. The course is educational. It is not a recommendation to buy or sell any security.

Next step

Where to go next

  • Free courseIntermediate

    Value at Risk (VaR)

    Measure portfolio risk with historical, parametric and Monte Carlo VaR in Excel and Python, then examine tail assumptions, backtesting and funding resilience.

    • 33 lessons
    • About 5 hours 45 minutes
    • 8 quizzes
    Free Start free course

See all courses

Start Portfolio Analytics & Risk Management today

100 lessons · free · certificate included

Freeself-paced · certificate included

FreeSelf-paced

Search
Contact Ryan

Get in touch

Contact Me

Have a question or want to work together? Fill out the form below and we'll get back to you as soon as possible.

Contact Form Demo

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Results appear as you type. Use the arrow keys to move through them.