Investing & Personal FinancePersonal Finance in Excel
Budget, track spending, pay off debt and plan savings, investing and retirement in a live spreadsheet that checks your work.
BeginnerCertificate$9.99
Investing & Personal Finance
Understand the maths behind your money decisions
Most money decisions come down to a handful of calculations: what something really costs over time, how risk and return trade off, and what fees and taxes take along the way. These courses let you run those calculations yourself in a spreadsheet, with every step checked, so you can judge offers and plans with your own numbers rather than someone else's brochure.
The 27 courses range from a household budget and emergency fund to retirement and early-independence planning, index funds and ETFs, dividend portfolios, bond ladders, rebalancing rules and the long-run cost of fees. More advanced tracks cover options, futures, factor investing, value at risk and performance attribution. The content is educational and illustrative; it is not personal investment advice.
Courses in Investing & Personal Finance
Investing & Personal Finance
Investing & Personal FinanceInvesting & Portfolio Analysis in Excel
Measure returns, risk, diversification, beta and value, with every formula checked on a live spreadsheet. Educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceOptions & 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.
IntermediateCertificate$9.99
Investing & Personal FinanceRetirement & Financial Independence Planning
Income need, inflation, years to FI, saving plans, employer match and fees, withdrawals, sequence risk and annuities: 8 labs with one plan. Educational, not financial advice.
IntermediateCertificate$9.99
Investing & Personal FinanceDividend & Income Investing in Excel
Measure yield, payout safety, dividend growth, DRIP compounding, portfolio income and total return, with every formula checked on a live spreadsheet. Educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceStock Market, ETF & Index Fund Investing
Understand share prices, P/E, total return, compounding, index funds vs active funds, diversification, dollar-cost averaging, rebalancing and trading costs, with every formula checked on a live spreadsheet. Educational only, not investment advice.
BeginnerCertificate$9.99
Investing & Personal FinanceValue Investing & Intrinsic Value
Measure owner earnings and quality, price stocks with P/E, P/B and EV/EBIT, apply Graham's tests, build a DCF and a reverse DCF, set a margin of safety and score a checklist, all on a live spreadsheet. Educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceTechnical Analysis Indicators in Excel
Build candles, moving averages, crossovers, RSI, MACD, Bollinger Bands and breakout levels from raw prices, then backtest a rule against buy-and-hold, every cell checked. Educational only, not trading advice.
IntermediateCertificate$9.99
Investing & Personal FinanceForex Trading Math & Risk Management
Read quotes and spreads, value pips across lot sizes, calculate P&L, margin and margin level, size positions from risk %, and measure R:R, cross rates, swap and expectancy, every cell checked. Educational only, not trading advice.
IntermediateCertificate$9.99
Investing & Personal FinanceCrypto & DeFi Math
Measure token volatility and drawdowns, compare DCA with a lump sum, rebalance with fees, turn APR into APY, find the break-even trade size, and price AMM swaps, impermanent loss and depeg risk, every cell checked. Invented tokens and prices. Educational only, not investment advice. Crypto is very high risk.
IntermediateCertificate$9.99
Investing & Personal FinanceFutures & Commodities Trading Math
Value contracts and ticks, calculate P&L, run margin calls through daily mark-to-market, size trades from risk, read basis, contango and roll yield, hedge a harvest and price calendar spreads, every cell checked. Educational only, not trading advice.
IntermediateCertificate$9.99
Investing & Personal FinanceETF & Index Fund Investing Math
Fee drag, tracking difference and error, index construction, total return, DCA vs lump sum, rebalancing, diversification and the true cost of a fund: 8 hands-on labs. Educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceFactor Investing: Value, Momentum, Quality & Smart Beta
Score a stock universe on value, momentum and quality, build z-score composites and quintile portfolios, measure long-short returns, run CAPM and Fama-French-style LINEST regressions, price turnover and summarise a backtest: 8 graded labs. Educational only, not investment advice.
AdvancedCertificate$9.99
Investing & Personal FinanceTrading Journal Statistics: Win Rate, Expectancy, R-Multiples & Drawdown
Analyse a synthetic 60-trade journal like a performance coach: equity curve, win rate, expectancy, R-multiples, profit factor, drawdown, position sizing and streaks, with every formula checked on a live spreadsheet. Educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceAngel Investing Math: SAFEs, Dilution & Power-Law Portfolios
The numbers behind early-stage deals: pre- and post-money, SAFEs and convertible notes with caps and discounts, dilution and the option pool shuffle, pro-rata follow-ons, preference waterfalls, power-law portfolio odds and XIRR, every cell checked as you go. Fictional start-ups, educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceTax-Efficient Investing Math: After-Tax Returns, Asset Location & Loss Harvesting
After-tax returns, tax drag, account types, asset location, loss harvesting, lot selection, withdrawal order and dividends vs buybacks: 8 hands-on labs with illustrative, country-neutral rates. Educational only, not tax or investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceP2P Lending & Crowdfunding Returns: Defaults, Diversification & Net Yield
Build a loan-grade rate card, model the cash flows of an amortising note with PMT, price expected loss by grade, get from gross interest to net yield, measure diversification with BINOM.DIST, compute a 50-loan IRR and XIRR, value recovery timing and chart an equity crowdfunding outcome distribution, every cell checked live. Fictional platform, educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinancePortfolio Performance Attribution: TWR, Benchmarks & Brinson Allocation/Selection
Measure a fund's return the way professionals do (time-weighted with sub-period linking, money-weighted with XIRR), compare it with its benchmark through active return, tracking error and information ratio, and explain the difference with Brinson-Fachler allocation, selection and interaction: 8 graded labs on one fictional equity fund. Educational only, not investment advice.
AdvancedCertificate$9.99
Investing & Personal FinanceBond Ladders for Income: Building Rungs, Reinvestment & Cash-Flow Matching
Design an equal-rung ladder, map coupons and maturities year by year, weight maturity and yield with SUMPRODUCT, roll the ladder at new rates with a chart, fund planned expenses by cash-flow matching, compare barbell, ladder and bullet, protect real income with inflation-linked bonds and compare a ladder with a bond fund, every cell checked live. Fictional bonds and CDs, educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceValue at Risk & Expected Shortfall: Historical, Parametric & Stress Tests
Measure market risk the way risk desks do, cell by cell: daily returns and volatility, historical VaR with PERCENTILE.INC at 95 % and 99 %, parametric VaR with NORM.S.INV, √t scaling to 10 days with limit checks and highlighted breaches, expected shortfall with AVERAGEIF, portfolio VaR from a covariance matrix with MMULT, backtesting with exception counts, traffic lights and Kupiec's test, and stress scenarios with a histogram of the P&L – 8 labs on one fictional fund with synthetic data, every cell checked instantly. Educational only, not investment advice.
AdvancedCertificate$9.99
Investing & Personal FinanceHouse Flipping Math: ARV, the 70% Rule, Rehab Budgets & Holding Costs
Run a fix-and-flip deal end to end in a live spreadsheet: ARV from comps, maximum offer, rehab budget, holding and hard-money costs, profit, annualised ROI and a stress test. Fictional property, illustrative costs. Educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinancePension Lump Sum vs Annuity: Present Value, Break-Even Age & Risk Trade-offs
Value a pension offer the way an analyst would: PV at different discount rates, the annuity's implied return with RATE, break-even ages, mortality-weighted expected value, COLA vs fixed payments in real dollars, a drawdown path, the probability of running out and joint-and-survivor options: 8 graded labs on one fictional retiree. Illustrative rates and life table, not financial advice.
IntermediateCertificate$9.99
Investing & Personal FinancePortfolio Rebalancing: Drift, Bands, Cash-Flow & Tax-Aware Rebalancing
Weights and drift, trades back to target, calendar vs never, 5/25 tolerance bands, rebalancing with new cash only, trading costs, FIFO vs HIFO lots and the rebalancing bonus: 8 hands-on labs with illustrative returns. Educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceCollege Savings Planning: Future Cost, Monthly Savings & Tax-Advantaged Accounts
Project the future cost of college with education inflation, turn it into a lump sum or monthly saving (PV, PMT, FV), build an age-based glide path, compare tax-free and taxable growth, plan for several children, add gifts and employer matches, run a simplified aid-style contribution and chart a four-year withdrawal plan. 8 hands-on labs, every cell checked. Illustrative, not financial or tax advice.
IntermediateCertificate$9.99
Investing & Personal FinanceGold & Precious Metals Investing: Premiums, Storage Costs, Ratios & Portfolio Role
Troy ounces and melt value, dealer premiums and spreads, vault vs ETF costs, the gold-to-silver ratio, real and currency returns, correlation, drawdowns and rebalancing: 8 hands-on labs with illustrative prices. No dealer or fund affiliation; educational only, not investment advice.
IntermediateCertificate$9.99
Investing & Personal FinanceInvestment Fees: Expense Ratios, Advisory Fees, Loads & Their Long-Run Cost
Fee drag on compounding, lifetime cost in dollars, index vs active expense ratios, advisory fees on top of fund fees, loads and share-class break-even, platform and trading costs, performance fees with high-water mark and hurdle, and a fee-adjusted dashboard: 8 illustrative labs.
BeginnerCertificate$9.99
Investing & Personal FinanceEmployee Equity: RSUs, Stock Options, Vesting, Dilution & Exit Scenarios
Understand your own equity like an analyst: vesting with a cliff, RSU value at grant vs vest, option intrinsic value and spread, the cash needed to exercise, dilution through funding rounds, exit payouts after preferences, two offers compared by expected value and the deadlines when you leave: 8 graded labs for a fictional employee.
IntermediateCertificate$9.99
Guides with worked examples
How to Calculate the Sharpe Ratio in Excel (Example)
Calculate the Sharpe ratio in Excel from monthly returns: AVERAGE, STDEV.S and SQRT(12) to annualise, a two-fund example and the common mistakes.
How to Calculate Pip Value: Formula, Lots and Examples
How to calculate pip value for any forex pair: units × pip size, then convert to USD. Yen pairs, USD/CHF, crosses and lot sizes in an Excel example.
RSI Formula in Excel: Wilder's RSI(14) Step by Step
The RSI formula in Excel: gains and losses, a simple first average, then Wilder's smoothing and RSI = 100 − 100/(1+RS). Worked example with 22 prices.
Graham Number Formula: Calculation, Example and Limits
The Graham number formula √(22.5 × EPS × BVPS) in Excel: where 22.5 comes from, three worked stock examples, the net-net (NCAV) test and margin of safety.
Impermanent Loss Formula: 2√r ÷ (1 + r) − 1, with Example
The impermanent loss formula for a 50/50 liquidity pool, a table of losses by price change and a $10,000 worked example in Excel, plus the fee break-even.
Trading Expectancy Formula, with an Excel Example
Expectancy = win rate × average win + loss rate × average loss. Excel example with 20 trades, expectancy in R, the break-even win rate and the edge.
Frequently asked questions
Will these courses tell me what to invest in?
No. They teach you how to calculate and compare, using fictional examples. Decisions about your own money should take your situation into account, ideally with a licensed adviser.
Is this suitable without a finance background?
Yes. Personal Finance in Excel and the investment fees course start from scratch. The options, factor and risk courses assume you are comfortable with the basics.
How much does a course cost?
Each course is a single purchase of $9.99. That covers every lesson and lab, the final exam and the certificate, with no subscription and nothing that renews.
More categories
Ready to learn by doing?
Start with the recommended course and build your first result in the lab today.