Tabellab

Build Your Own Portfolio Tracker in Excel: Holdings, Returns, Dividends & Rebalancing

20 hands-on labs that build a personal portfolio tracker step by step: holdings and weights, cost basis and gains, a transaction log with SUMIFS, average cost, dividend income, total return, CAGR, a monthly savings plan with FV, asset allocation, rebalancing trades, fee drag and a dashboard with charts – then price updates with XLOOKUP, realised gains, a dividend calendar, rebalancing with new money, time-weighted and money-weighted returns, an all-in cost tracker and an annual review with a waterfall chart.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This beginner course builds a personal portfolio tracker in Excel, one lab at a time. In 20 hands-on labs you calculate holding values and weights, cost basis and unrealised gains, positions from a transaction log with SUMIFS, the weighted average cost, dividend income and yield on cost, price and total return, CAGR with RRI, a savings plan with FV, the asset allocation against a target, rebalancing trades and fee drag, and a first dashboard. The second part updates prices from a list with XLOOKUP and flags stale prices, calculates realised gains on sales, builds a dividend calendar with SUMIFS and EOMONTH, splits new money across underweight classes, chains monthly returns into a time-weighted return, measures your own return with XIRR, tracks all-in costs and closes the year with a waterfall chart.

Lessons

  1. Holdings Table: Shares × Price, Total Value and WeightsLabFree
  2. Cost Basis and Unrealised Gain or LossLab Locked
  3. Transaction Log: From Buys and Sells to PositionsLab Locked
  4. Average Cost per Share from Several PurchasesLab Locked
  5. Dividend Income, Current Yield and Yield on CostLab Locked
  6. Total Return vs Price ReturnLab Locked
  7. Annualised Return (CAGR) with RRILab Locked
  8. Monthly Contributions and Future Value with FVLab Locked
  9. Asset Allocation by Class vs TargetLab Locked
  10. Rebalancing: Trades Back to Target WeightsLab Locked
  11. Fee Drag: What 1% a Year Costs over 20 YearsLab Locked
  12. Mid-course Project: Portfolio Dashboard – Allocation Pie and Drift AlertsLab Locked
  13. Updating Prices with XLOOKUP: A Price List, Missing Tickers & Stale PricesLab Locked
  14. Realised Gains: Net Proceeds, Average Cost of Shares Sold & the Year’s TotalLab Locked
  15. Dividend Calendar: Income per Month with SUMIFS, the Year’s Total & Reinvested SharesLab Locked
  16. Rebalancing with New Money: Shortfalls, Splitting a Deposit & Weights Without SellingLab Locked
  17. Monthly Returns Without the Deposits: Chained Time-Weighted Return vs Simple GrowthLab Locked
  18. Your Own Return per Year with XIRR: Dated Deposits, a Withdrawal & Today’s ValueLab Locked
  19. All-in Costs: Fund Costs per Holding, Trading Fees with SUMIF & Costs as a Share of the PortfolioLab Locked
  20. Final Project: The Annual Portfolio Review – a Waterfall from 1 January to 31 DecemberLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy