Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Investing & Personal Finance Intermediate

Options & Derivatives Basics in Excel

Price forwards, chart option payoffs and strategies, test put-call parity, build binomial trees, run Black-Scholes, the Greeks and implied volatility in a live spreadsheet, every cell checked. Educational only, not trading advice.

8 lessons 8 labs 1.9 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Calculate the fair futures price of a stock index, spot a mispriced quote and decide the arbitrage trade, then price a copper forward with storage costs.
  • Build a profit table for long and short calls and puts over a range of expiry prices with MAX.
  • Combine stock and option legs into four classic strategies and read their profit profile from a price grid.
  • Test whether market call and put prices satisfy put-call parity, measure the gap and find which option is overpriced.
  • Price a European call with a one-step and a two-step binomial tree using the risk-neutral probability.
  • Calculate d1 and d2, look up N(d) with NORM.S.DIST and price a European call and put with Black-Scholes.
  • Calculate call and put delta and gamma from Black-Scholes and work out how many shares a dealer must buy to hedge the calls it sold.
  • Compare Black-Scholes prices across a grid of volatilities with the market price and pick the implied volatility with INDEX and MATCH.

About this course

Options are easier to understand once you have priced a few yourself. This course moves from payoffs to full valuation models in eight labs. You price forwards and futures with the cost of carry, then chart option payoffs and profit at expiry. Strategy labs combine positions into covered calls, protective puts, spreads and straddles. You check put-call parity and identify the direction of any arbitrage, price options with one- and two-step binomial trees and calculate call and put values with Black-Scholes. The Greeks lab measures delta and gamma and sets up a simple delta hedge, and the final lab backs out implied volatility from a market price. For finance students and analysts; educational, not trading advice.

Curriculum

Course content

8 lessons · 8 labs · 1.9 h · final exam

  1. Forward & Futures Pricing: Cost of CarryLab13 min4 checked tasks
    Unlocked when you buy the course
  2. Option Payoffs & Profit at ExpiryLab14 min5 checked tasks
    Unlocked when you buy the course
  3. Strategy Payoffs: Covered Call, Protective Put, Spread & StraddleLab16 min4 checked tasks
    Unlocked when you buy the course
  4. Put-Call Parity: Check & Arbitrage DirectionLab13 min4 checked tasks
    Unlocked when you buy the course
  5. Binomial Trees: One-Step & Two-Step PricingLab16 min4 checked tasks
    Unlocked when you buy the course
  6. Black-Scholes: Pricing a Call & a PutLab15 min4 checked tasks
    Unlocked when you buy the course
  7. The Greeks: Delta, Gamma & a Simple Delta HedgeLab14 min4 checked tasks
    Unlocked when you buy the course
  8. Implied Volatility: Backing Out σ from a Market PriceLab14 min5 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Investing & Personal Finance courses →
$9.99one-time payment
Buy course