Tabellab

Tax calculation courses: income tax, VAT, payslips and small business tax

Tax rules differ by country, but the calculations follow patterns: brackets, allowances, credits, expenses and timing differences.

Tax Calculations in Excel courses (11)

$9.90Advanced

Deferred Tax Accounting: Temporary Differences, DTA & DTL

Accounting vs taxable profit, carrying amount vs tax base, a 5-year depreciation schedule, DTA recognition for losses, rate changes, tax expense and journal, the effective tax rate reconciliation and presentation, then scheduled reversal rates, leases, tax in OCI, share options, capped and expiring losses, recoverability scenarios, uncertain tax positions, undistributed profits, return-to-provision, interim tax, foreign translation and a group tax dashboard: 20 labs on one manufacturing group, every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

Organize Your Personal Taxes in Excel: Income, Deductions, Receipts & Year-End Summary

20 hands-on labs that turn a year of paperwork into one tidy tax organizer: income by source, a deductible-expense log, a receipts checklist, mileage and donations logs, medical costs against a threshold, side-income profit, a quarterly set-aside, a document checklist, a year-over-year check and a year-end summary, then payslip tie-outs, foreign-currency income, childcare costs with a cap, a receipt file index, data health checks, a tax calendar, retention dates, month-by-month totals and an adviser-pack dashboard. Record keeping only, not tax advice.

20 lessons · 20 labs

$9.90Intermediate

Tax-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, dividends vs buybacks, holding periods, cost basis, fund payouts and turnover, foreign withholding, carry-forwards, brackets, gain harvesting, conversions and tax-aware rebalancing: 20 hands-on labs with illustrative, country-neutral rates, every cell checked instantly. Educational only, not tax or investment advice.

20 lessons · 20 labs

$9.90Beginner

How Income Tax Is Computed: Brackets, Allowances, Credits & Effective Rates

Build a tax calculator from scratch with a transparent fictional tax code in 20 hands-on labs: bracket slices and the rate-step shortcut, marginal vs average vs effective rates, deductions with floors and caps, an allowance taper, filing-status tables and credits, then base-plus-excess tax tables, back-solving income from a tax bill or a target net, inflation indexing and bracket creep, a one-fifth rule for one-off pay, stacked savings income, credit cliffs, capped pension scenarios, a minimum tax, a year-on-year waterfall bridge, a return review with flags and a season dashboard, with every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Reading Your Payslip: Gross-to-Net, Withholding & Year-End Refunds

Rebuild a payslip line by line in 20 hands-on labs with a transparent fictional tax code: gross pay with overtime, pre-tax vs after-tax deductions, capped social contributions, annualised and bonus withholding, year-to-date tracking, the year-end true-up and a mid-year correction, then payslip audits, starters and leavers, sick pay, benefits in kind, pension matching, two jobs, gross-ups, net-pay bridges and a full payslip year, with every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Property, Wealth & Inheritance Taxes: Assessed Values, Mill Rates & Estate Shares

Calculate taxes on what people own and pass on under a fictional tax code – property tax with mill rates, capped reassessments, levies and the revenue-neutral rate, instalments and late charges, sales-ratio appeals and income-based relief; net wealth brackets, asset valuation and an income ceiling; imputed rental value; gift exclusions and gift planning; estate shares with and without a will, inheritance tax per heir with two-way rate tables, estate liquidity, property gains tax and giving now vs inheriting later – 20 hands-on labs, every cell checked instantly. Educational only, not tax advice.

20 lessons · 20 labs

$9.90Advanced

Build a Personal Tax Return Workbook: From Source Documents to Refund or Balance Due

Assemble a complete household return in one linked workbook – document register, income by person, capital-gains netting with carryforwards, capped adjustments, joint vs separate filing, credits with phase-outs, refund or balance due and an audit panel, then itemised deductions, cash-basis cut-off, a repurchase-loss rule, foreign tax credit limits, a dependant support test, credit ordering, underpayment interest, a contribution what-if, a multi-year carryforward schedule, document mapping, an amended return and a final dashboard – 20 hands-on labs for one fictional household, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Side Income & Self-Employment Tax: Expenses, Home Office, Mileage & Quarterly Payments

Turn a year of side-business records into taxable profit under a fictional tax code – ledger totals, mixed-use costs, home office and vehicle methods, equipment depreciation, self-employment contributions, safe-harbour estimates and underpayment interest – then go further with quarterly profit, receipt and duplicate checks, client meals and gifts, platform payouts, year-end timing, a hobby-or-business test, equipment sales, vehicle break-even, pension deduction limits, the combined marginal rate, annualised instalments and a final dashboard: 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Profit Tax for a Small Company: From Accounting Profit to Taxable Profit, Add-Backs, Capital Allowances, Loss Carry-Forwards & Instalments

Work through a company's profit tax step by step under a fictional, simplified tax code in 20 hands-on labs. You adjust accounting profit for non-deductible items, map a trial balance, replace depreciation with capital allowances, an instant allowance and balancing adjustments, use losses under a cap, by vintage or by carry-back, apply a tiered rate with shared thresholds, plan instalments, reconcile the tax rate and review the computation before filing, with every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

VAT & Sales Tax Fundamentals

Learn how VAT and US-style sales tax really work: net and gross, multi-rate invoices, the VAT return, journal entries, partial exemption and reverse charge, then go further with rounding per line or per total, credit notes and bad-debt relief, control checks and ledger reconciliation, cash accounting, the rolling registration threshold, a flat-rate scheme, destination-based sales tax filings, a rate change and an annual VAT dashboard, and finish with gift sets at two rates, mixed-use and blocked input VAT, import duty and import VAT, and a complete return from the raw ledger: 20 hands-on labs in a live spreadsheet, every cell checked instantly.

20 lessons · 20 labs

Tax rules differ by country, but the calculations follow patterns: brackets, allowances, credits, expenses and timing differences. These courses teach those patterns with worked spreadsheets, from reading your payslip and organising a personal return to taxing side income, rental income and a small company, plus VAT and deferred tax for accountants. They are educational and use illustrative rates, not tax advice for your jurisdiction.

This topic hub gathers 11 Tax Calculations in Excel courses from Tax, Accounting, Investing: 4 beginner, 5 intermediate, 2 advanced. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: income tax calculation excel; personal tax return workbook; vat calculation excel; self employment tax calculator.

Frequently asked questions

Which Tax Calculations in Excel course should I start with?

Start with “How Income Tax Is Computed”. It is a beginner-level course, so no prior knowledge is assumed. Then move on to the more specialised courses in the list above.

How much do the Tax Calculations in Excel courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the Tax Calculations in Excel courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses