Tabellab

Excel for your job: role-based Excel courses

General Excel tutorials rarely match what a specific job needs.

Excel for Your Job: Role-Based Courses courses (30)

$9.90Intermediate

Excel for Accountants: Reconciliations, Ledgers & Month-End

Build a trial balance from a GL export, map accounts to the statements, match a bank reconciliation, age receivables and set the allowance, run prepayment, accrual, GRNI, payroll and leave, deferred revenue and depreciation schedules, count inventory, test revenue cut-off, split a bank loan, revalue foreign-currency items, reconcile sales tax and every balance sheet account, flag variances, check intercompany balances and build the cash flow statement: 20 hands-on labs on one company's month-end.

20 lessons · 20 labs

$9.90Beginner

Excel for Accounts Payable & Receivable Clerks: Invoices, Aging & Payments

20 hands-on labs for AP and AR clerks: invoice register with due dates, aging buckets, weekly payment runs, early-payment discounts, duplicate checks, three-way match, customer statements, DSO and DPO, collection calls, vendor spend, cash receipts matching, an AP/AR dashboard, approval limits, invoice numbers from bank text, customer credit balances, recurring billing runs, AR roll-forwards, a four-week cash view, the AP inbox and a month-end pack.

20 lessons · 20 labs

$9.90Beginner

Excel for Bank Branch Staff: Loans, Deposits, Interest & Fees

20 hands-on labs at a fictional community bank branch: simple vs compound interest, APY with EFFECT, CD maturity values, loan payments and amortization, debt-to-income checks, overdraft fees, cash balancing, cross-sell counts, savings goals, currency exchange and a branch KPI dashboard – plus true loan rates with RATE, home-loan pre-checks with PV, teller staffing, ATM cash, fee waivers, deposit mix, delinquency buckets and a monthly scorecard.

20 lessons · 20 labs

$9.90Beginner

Excel for Beginners: Your First Real Spreadsheet

Build a small online shop's sales workbook from scratch – formulas, $ references, IF, SUMIF, XLOOKUP, charts and a mini dashboard – then percent change and running totals, SUMIFS, IF with AND and OR, dates, text formulas, .90 pricing, IFERROR and data validation, repeat customers, pie and stacked charts, top sellers, a 2027 plan and a half-year dashboard: 20 hands-on labs, every cell checked and a certificate at the end.

20 lessons · 20 labs

$9.90Beginner

Excel for Consultants & Freelance Advisors: Rates, Utilisation, Proposals & Billing

20 hands-on labs following one small advisory firm: day rate from target income, utilisation, engagement budgets, proposal pricing, timesheet to invoice, WIP and realisation, budget burn, expense re-billing, fixed fee vs T&M, client profitability, pipeline and a partner dashboard – then retainers and overage, subcontractor markup vs margin, estimate accuracy, next-quarter capacity, invoice ageing, euro invoices, a monthly cash flow and a year-end dashboard.

20 lessons · 20 labs

$9.90Beginner

Excel for Customer Success Managers: Health Scores, Renewals, Churn & NRR

20 hands-on labs for CSMs at a small B2B software company: account list and ARR, health scores and their trend, renewal calendar and price uplifts, seat true-ups, multi-year deals, logo and revenue churn, churn reasons, NRR, adoption and feature breadth, support tickets and SLA backlog, NPS, expansion pipeline, at-risk accounts, a QBR one-pager, a CS dashboard and a renewal readiness board.

20 lessons · 20 labs

$9.90Beginner

Excel for Data Entry & Records Clerks: Clean, Check and Match Data

20 hands-on labs for data entry clerks and records assistants: fixing case and spaces, splitting codes, joining fields, converting text numbers and dates, duplicates, required fields, validation rules, matching two lists, standard categories, completeness, a daily entry log, a data quality dashboard, phone numbers and account codes, double-keying checks, batch control totals, monthly summaries, retention dates, turnaround times, check digits and a monthly records report.

20 lessons · 20 labs

$9.90Beginner

Excel for Finance

The formulas every finance job uses, from percentages, references, lookups, rounding and dates to budget variances, exchange rates, running balances, receivables aging, weighted averages, break-even, built-in checks, price-volume-mix bridges, shared-cost allocation, profit sensitivity grids and a 13-week cash forecast, practised in 20 hands-on labs with every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

Excel for Financial Advisors: Client Reviews, Retirement Projections & Fees

20 hands-on labs for financial advisors and planning assistants, with one fictional client household and a small client book: net worth, cash flow, goal funding gaps and priorities, debt payoff, emergency funds, retirement projections and scenarios, withdrawal years with and without inflation, retiree cash planning, risk scores, allocation drift, fee tiers, fee impact, insurance needs, the client book, a review calendar, a review one-pager and an annual planning dashboard.

20 lessons · 20 labs

$9.90Beginner

Excel for Freelance Bookkeepers: Clients, Bank Feeds, Monthly P&L & Practice Profit

20 hands-on labs for self-employed bookkeepers: client fees, time tracking, bank feed rules, missing receipts, client P&L with SUMIFS, sales tax summary, month-end checklist, invoice batch, your own receivables, client profitability and a practice dashboard – then clean-up quotes, mileage and rebillable travel, duplicate bill checks, staff expense claims, prepayments and accruals, budget vs actual, an annual fee review, unbilled time and a full practice year review.

20 lessons · 20 labs

$9.90Beginner

Excel for HR Assistants: Headcount, Hiring, Leave & Payroll Prep

20 hands-on labs for HR assistants and coordinators at a 60-person company: employee list cleanup and XLOOKUP, headcount, tenure, birthdays and anniversaries, time-to-hire, cost per hire, leave balances, overtime for payroll, compa-ratio, turnover, training hours and an HR dashboard, then names and email addresses, dynamic lists, two-key pay scale lookups, probation and contract end dates, headcount on any date, salary changes with back pay, input rules and a monthly HR report.

20 lessons · 20 labs

$9.90Beginner

Excel for Insurance Agents & Brokers: Premiums, Commissions, Renewals & Book of Business

20 hands-on labs for agents, brokers and account managers of a small independent agency: policy register cleanup, premium by line, new vs renewal commission, renewal calendar, retention, quote-to-bind, average premium, cross-sell, producer splits, book growth, loss ratio, a book dashboard, renewal rate changes, quote comparison, payment plans, mid-term pro-rata changes, coverage reviews, claims follow-up, client touchpoints and a renewal-season dashboard.

20 lessons · 20 labs

$9.90Beginner

Excel for Junior Auditors: Sampling, Vouching, Analytics & Workpapers

20 hands-on labs from a first-year audit: trial balance tie-out, materiality, sample selection, vouching tracker, year-over-year analytics, duplicate payments, weekend and round-amount journal entries, cut-off, aged receivables, workpaper sign-off and the summary of misstatements, then the bank reconciliation and stale cheques, receivables confirmations, a payroll proof in total, fixed-asset additions, inventory at cost or NRV, lead schedules with audit adjustments, going-concern indicators and an audit completion dashboard.

20 lessons · 20 labs

$9.90Beginner

Excel for Logistics Coordinators: Shipments, Freight Costs & On-Time Delivery

20 hands-on labs for logistics and shipping coordinators: shipment log cleanup, freight cost per kg and pallet, carrier rate brackets, dimensional weight, on-time delivery, transit days, pallets and trailers, fuel surcharge, pick rates, stock balances, a carrier scorecard and a dashboard – plus dock appointments, freight invoice audits, open-shipment reports, claims, LTL vs full truckload, weekday staffing, customer lookups and a monthly lane report.

20 lessons · 20 labs

$9.90Beginner

Excel for Marketing Coordinators: Budgets, Campaign Metrics & Reports

20 hands-on labs for marketing coordinators and assistants: campaign budget tracking, ad metrics (CTR, CPC, CPM, CPA, ROAS), email stats, a social content calendar, funnels, A/B tests, lead list cleanup, UTM links, event ROI, a monthly report and a dashboard – plus summaries from raw exports with SUMIFS, mapping tables with XLOOKUP, campaign timelines, invoice matching, social post performance, email segments, event kit orders, feedback surveys with NPS and a quarterly marketing pack.

20 lessons · 20 labs

$9.90Beginner

Excel for New Financial Analysts: Your First 90 Days

20 hands-on labs for junior and new financial analysts: P&L variance commentary, forecast roll, revenue bridge, headcount costs, driver-based forecast, KPI pack, TTM, ratios, scenario switch, sensitivity table, reconciliation, management dashboard – plus trial-balance mapping, budget phasing, forecast accuracy, cost allocation, cash conversion, capex payback and NPV, FX translation and a month-end board pack.

20 lessons · 20 labs

$9.90Beginner

Excel for New Team Managers: Team Budget, Schedules, KPIs & Reviews

20 hands-on labs for first-time managers of a small team: team cost budget, budget vs actual, rota coverage, holiday overlaps, workload, KPI traffic lights, weighted reviews, 1:1 tracker, training budget, overtime, hiring cost and a monthly report – then staffing by hour, next year’s budget by month, meeting costs, team absence rates, complaint reasons, a backlog burn-down, a fair weekend rota and a quarterly team pack.

20 lessons · 20 labs

$9.90Beginner

Excel for Nonprofit Treasurers & Volunteers: Donations, Budgets & Reports

20 hands-on labs for volunteer treasurers of charities, clubs and associations: donation log, membership dues, budget vs actual and monthly phasing, restricted funds, grant spend-down, pledges and ageing, event results and break-even scenarios, petty cash, bank reconciliation, expense claims, cash flow, an equipment register, reserves policy, examiner checks, program ratio, volunteer hours and the year-end statement by fund.

20 lessons · 20 labs

$9.90Beginner

Excel for Online Sellers: Profit per Order, Fees, Ads & Stock

20 hands-on labs for small Shopify, Etsy and marketplace sellers: clean an order export, profit per order after fees and shipping, product margins, target-margin pricing, ROAS and break-even ROAS, discount codes, returns, days of stock and reorder points, bestsellers, sales by channel, repeat customers and a half-year dashboard, then decode SKU codes with text formulas, join exports with XLOOKUP, clean a customer list, build a scent × size heat map, band order values, analyse product reviews, separate season from growth and finish with a year-end seller report.

20 lessons · 20 labs

$9.90Beginner

Excel for Payroll Administrators: Hours, Gross-to-Net, Registers & Checks

20 hands-on labs for payroll administrators: timesheet hours, overtime and night premiums, salaried and hourly pay, pre-tax pension, rate-table withholding, gross-to-net, the payroll register, employer cost, year-to-date totals, starters and leavers, variance checks and a payroll dashboard, then holiday accrual and liability, unpaid leave and sick pay, contribution ceilings, back pay and pro-rata bonuses, a payroll calendar, timesheet exception checks, a bank file reconciliation and a year-end payroll dashboard.

20 lessons · 20 labs

$9.90Beginner

Excel for Project Coordinators: Task Lists, Timelines, Budgets & Status Reports

20 hands-on labs for project coordinators and PMO assistants on one office-move project: WORKDAY task lists, % complete and status flags, a formula Gantt chart, milestones, resource hours, budget vs actual, change requests, a RAID log, action items, earned value basics and a weekly status report – plus supplier quote scoring, PO and invoice matching, internal labour cost, a seat plan, crate and van planning, the move-weekend schedule, the snag list, a staff survey and a close-out dashboard.

20 lessons · 20 labs

$9.90Beginner

Excel for Purchasing Buyers: Quotes, Purchase Orders, Savings & Suppliers

20 hands-on labs for buyers and purchasing assistants: PO totals with freight and tax, RFQ comparison, total cost of ownership, price breaks, savings tracking, open PO follow-up, supplier scorecards, spend by category, EOQ, MOQ rounding, currency conversion, a buyer dashboard – then prices per base unit, freight allocation, last-price lookups, lead times, approval levels, blanket orders, a contract calendar and a quarterly supplier review.

20 lessons · 20 labs

$9.90Beginner

Excel for Real Estate Agents: Comps, Pricing, Buyer & Seller Math, Pipeline

20 hands-on labs for real estate agents: commission deal sheet, comps and price per sq ft, adjusted comps, pricing a listing, buyer affordability with PMT and DTI, seller net sheet, days on market, pipeline conversion, lead source ROI, marketing budget per listing, goal planning and a GCI dashboard, then time-adjusted and weighted comps, a neighborhood report, months of inventory by price band, multiple offers by expected net, escalation clauses and appraisal gaps, a seller credit as price cut or rate buydown, a contract-to-close timeline and a final listing presentation dashboard, every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

Excel for Recruiters: Candidate Pipeline, Time-to-Fill, Sources & Cost per Hire

20 hands-on labs for in-house recruiters and talent acquisition coordinators: pipeline counts by stage, conversion rates, time-to-fill and time-to-hire, source effectiveness, cost per hire, offer acceptance, interviewer load, agency fees, requisition aging, a weekly report and a mid-course dashboard, then candidate response times in working days, salary-range checks with XLOOKUP, hourly offers with night premiums, referral bonus payouts, job ad performance, monthly requisition flow, a budget forecast, a candidate experience survey and a quarterly scorecard – every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

Excel for Retail Store Managers: Daily Sales, Staffing, Stock & Shrink

20 hands-on labs for store managers and assistant managers of one gift and homeware store: sales vs last year, sales per labour hour, rota vs budget, conversion and basket, UPT, markdowns, stock counts and shrink, sell-through, weeks of cover, top sellers, cash-up and a weekly dashboard, then staffing by the hour, next week's forecast, returns, ordering in case packs, four-wall profit, tills at the peak, click & collect and a monthly store review.

20 lessons · 20 labs

$9.90Beginner

Excel for Sales Managers: Team Quota, Forecast Accuracy, Coaching & Commission Budget

20 hands-on labs for first-line sales managers leading a team of reps: quota allocation by territory potential, attainment, pipeline coverage, the weekly forecast call, forecast accuracy, activity targets, win rate and cycle, discount discipline, commission budget, ramp quotas, territory balance and a team dashboard, then capacity planning with ramp and attrition, prorated quotas by working days, pipeline generation by source, deal slippage, seasonal quota phasing, commission accruals and clawbacks, territory rebalancing and a next-year team plan.

20 lessons · 20 labs

$9.90Beginner

Excel for Sales Reps: Pipeline, Forecast, Quota & Commission

20 hands-on labs for B2B account executives: activity log, weighted pipeline forecast, win rate, sales cycle, quota attainment, tiered commission, discount impact, account ranking, a volume-discount quote, a monthly sales report and a sales dashboard, then pipeline hygiene, stage conversion from your own history, an activity plan worked back from the quota gap, forecast categories, territory whitespace, multi-year deals, a commission what-if, a volume and price bridge and your quarterly business review.

20 lessons · 20 labs

$9.90Beginner

Excel for Small Landlords: Rent Roll, Expenses, Cash Flow & Returns

20 hands-on labs for owners of a few rental units: rent roll with late flags, late fees, expense log, maintenance reserve, vacancy, mortgage split, cash flow per unit, cap rate, rent increases, deposits, year-end summary and a dashboard – plus a tenant ledger, a lease expiry calendar, a repair log, turnover costs, rent comparables, a renovation budget, next year's budget and an annual property review.

20 lessons · 20 labs

$9.90Beginner

Excel for Startup Founders: Runway, Unit Economics, Cap Table & Investor Updates

20 hands-on labs for first-time founders: runway and burn, a 12-month forecast, CAC, LTV and payback, pricing tiers, a hiring plan, a seed-round cap table, use of funds, MRR growth, cohort retention, budget vs actual, break-even and an investor update dashboard, then an MRR bridge with a waterfall chart, a bank ledger summarised with SUMIFS, annual prepaid plans and deferred revenue, a price increase test, burn multiple and magic number, a scenario switch for the cash plan, the Series A option pool shuffle and a final board pack dashboard, every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

Excel for Supply Planners: Demand Forecast, Safety Stock & Replenishment

20 hands-on labs for new demand and supply planners: clean demand history, moving average forecasts, MAD, MAPE and bias, season index, safety stock with NORM.S.INV, reorder point, projected inventory balance, MOQ and pack-size orders, ABC classes, supplier lead times, fill rate, a planner dashboard, promotion lift, cartons, pallets and trucks, excess and slow movers, shelf-life risk, fair-share allocation, warehouse rebalancing, open purchase orders and a weekly replenishment plan.

20 lessons · 20 labs

General Excel tutorials rarely match what a specific job needs. The courses in this hub start from the role instead: the sales rep tracking a pipeline and commission, the recruiter watching time-to-fill, the payroll administrator building a register, the founder modelling cash, the landlord tracking rent, and many more. Each one teaches the formulas, layouts and checks that role actually uses, with practice files you work through in the browser.

This topic hub gathers 30 Excel for Your Job: Role-Based Courses courses from Business, Accounting, Excel, Finance: 29 beginner, 1 intermediate. 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: excel for recruiters; excel for sales managers; excel for payroll; excel for startup founders.

Frequently asked questions

Which Excel for Your Job: Role-Based Courses course should I start with?

Start with “Excel for Beginners”. 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 Excel for Your Job: Role-Based Courses 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 Excel for Your Job: Role-Based Courses 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