Excel

Weighted Scoring Models in Excel: Decision Matrices, Normalisation & Sensitivity

Weights that add up, min-max normalisation, SUMPRODUCT scores, knock-out criteria, pairwise (AHP-style) weights, sensitivity, evaluator panels and a decision dashboard: 8 labs for vendor selection, hiring and project prioritisation.

8 lessons · 8 labs · 2 h

IntermediateCertificate$9.99

Excel

Combining Tables in Excel: VSTACK, HSTACK, Lookups, GROUPBY & Reconciliation

Turn monthly files and regional exports into one live table: VSTACK and DROP for stacking, HSTACK for a source column, XLOOKUP to merge columns, missing records in both directions, UNIQUE de-duplication, GROUPBY summaries, reconciliations with a formula rule and a combined dashboard chart: 8 hands-on labs, graded instantly.

8 lessons · 8 labs · 2.2 h

Combine the results of several studies step by step in Excel: mean difference, Cohen's d and log odds ratios with their variances, inverse-variance weights, the fixed-effect estimate with CI and z-test, Q, I² and τ² (DerSimonian–Laird), the random-effects model and prediction interval, a forest plot, funnel plot and Egger's test, and leave-one-out sensitivity, in 8 graded labs.

8 lessons · 8 labs · 2.2 h

AdvancedCertificate$9.99

Data & Analytics

Process Mining with Spreadsheets: Event Logs, Case Durations, Variants & Bottlenecks

Analyse an order-to-cash event log like a process-mining tool, with formulas: cases per month, throughput times with MINIFS/MAXIFS, activity frequency and rework loops, waiting times, TEXTJOIN variants, a directly-follows matrix heat map, a bottleneck chart and a happy-path conformance and SLA check: 8 hands-on labs, graded instantly.

8 lessons · 8 labs · 2.2 h

IntermediateCertificate$9.99

Data & Analytics

Prioritisation Surveys: Ranking Questions, Best–Worst Scaling, TURF Reach & Kano Categories

Find out what customers want most: ranking scores, best–worst counts, the product line-up that reaches the most people and Kano categories, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Classify biological assets, bearer plants and produce, value livestock at FVLCTS, split gains into price and physical change, value growing timber by present value, carry the harvest into inventory, depreciate an orchard under IAS 16, treat grants and build the IAS 41.50 reconciliation: 8 graded labs on a fictional mixed farm.

8 lessons · 8 labs · 1.9 h

Turn a venture debt term sheet into payments and runway, size warrants, find the all-in cost with IRR and XIRR, compare dilution with equity, test covenants and model a default: 8 hands-on labs with a fictional startup and lender. Educational only, not financial advice.

8 lessons · 8 labs · 2.3 h

IntermediateCertificate$9.99

Corporate Finance & Valuation

Credit Scorecards: Weight of Evidence, Information Value & Points Scaling

Coarse classing, WoE, Information Value, monotonic bins, points with factor/offset and PDO, scoring applicants, cut-off strategy and population stability: 8 hands-on labs on one fictional lender's synthetic applications.

8 lessons · 8 labs · 2.2 h

AdvancedCertificate$9.99

Corporate Finance & Valuation

Variance Bridges for FP&A: Price, Volume, Mix, FX & Cost Effects from Budget to Actual

Explain the gap between budget and actual: price, volume, mix, currency and cost effects that add up exactly, plus the bridge chart, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

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.

8 lessons · 8 labs · 2.1 h

BeginnerCertificate$9.99

Investing & Personal Finance

Employee 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.

8 lessons · 8 labs · 2 h

Set a funding goal from tooling, MOQ and platform fees, forecast the backer mix and average pledge, cost fulfilment with a shipping-zone lookup, flag loss-making reward tiers, read the funding curve, price stretch goals, measure the funnel's CAC and ROAS and plan the cash flow after the campaign: 8 graded labs for a fictional product launch.

8 lessons · 8 labs · 1.9 h

IntermediateCertificate$9.99

Business & Operations

Subscription Box Economics: Box COGS, Churn by Cohort, CAC Payback & Skip Rates

Build the cost stack of one box, value the plan mix, read cohort churn and the first-box cliff, price skips and pauses, pay back CAC, value subscribers by plan, forecast next month's inventory and test first-box discounts, with every cell checked as you go.

8 lessons · 8 labs · 2 h

IntermediateCertificate$9.99

Business & Operations

Project Portfolio Prioritisation: Scoring, NPV, Resource Constraints & Capacity

Score proposals against strategy, calculate NPV, IRR, PI and payback, build a weighted priority rank, select projects within a capital budget, check team capacity in FTE-months, handle mandatory work and dependencies, chart the value-vs-cost curve and re-prioritise every quarter: 8 hands-on labs.

8 lessons · 8 labs · 2 h

IntermediateCertificate$9.99

Business & Operations

Freelance Translation & Localisation Business: Word Counts, Match Discounts, Throughput, Rush Fees & Project Quotes

Quote translation jobs with confidence: weighted word counts, fictional match-discount grids, throughput, rush fees and multi-language project prices, with every cell checked as you go.

8 lessons · 8 labs · 2 h

BeginnerCertificate$9.99

Business & Operations

Customer Success by the Numbers: Health Scores, Time-to-Value, Renewal Forecasts, Expansion & Account Coverage

Manage a book of accounts with numbers: health scores, onboarding time-to-value, renewal forecasts, expansion and how many accounts each manager can cover, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

IntermediateCertificate$9.99

Business & Operations

Vending Machine Business by the Numbers: Machine Payback, Location Commissions, Product Mix, Restock Routes & Cash vs Card

Decide if a vending route pays: machine cost and payback, location commissions, slot-by-slot product mix, restock routes and payment fees, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Turn racks and tiers into grow area and plant numbers, calculate crop cycles and yield per m², convert a light recipe (PPFD, DLI) into kWh per kg, add cooling and dehumidification, compare water and nitrogen with field farming, plan labour, build the cost per kg and price, and test the payback against the electricity price: 8 graded labs on a fictional indoor farm.

8 lessons · 8 labs · 1.9 h

Run the numbers of a fictional owners' association like its treasurer: dues by unit share, an operating budget with contingency, a reserve component list, percent funded, a 15-year reserve cash-flow plan, a special assessment versus a loan, late fees and collections, and a budget package with a chart, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

IntermediateCertificate$9.99

Real Estate & Property

Rental Service Charges & Utility Billing: Allocation Keys, Prepayments & Year-End Statements

Share a fictional apartment building's running costs among its tenants: the recoverable cost pool, floor-area and occupant keys, a fixed/variable heating split, water submeters, tenant changes and vacancy, prepayments and refunds, and a complete year-end statement with a chart, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Read a ward's census like a staffing planner, turn patient workload levels into care hours and staff per shift, track hours per patient day against target, convert hours into budgeted FTEs with non-productive time, build a census-based staffing grid, check a roster's RN gaps and skill mix, price overtime, bank and agency cover and split a labour-cost variance into volume, hours and rate – 8 hands-on labs on one hospital ward, with every cell checked as you go.

8 lessons · 8 labs · 2.2 h

IntermediateCertificate$9.99

Healthcare Business

Home Care Agency Economics: Client Hours, Caregiver Scheduling, Travel Time, Pay vs Bill Rates & Overtime

Run a non-medical home care agency by the numbers: client hours, caregiver rotas, travel time, the gap between pay and bill rates and overtime, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Price rooms like a revenue manager: net ADR by channel, comp-set indices, booking pace, stay restrictions and group displacement, with every cell checked as you go.

8 lessons · 8 labs · 2.2 h

AdvancedCertificate$9.99

Hospitality, Food & Leisure

Campground & Glamping Site Economics: Pitches and Units, Seasonal Occupancy, Rate Ladders, Amenity Costs & Payback

Run the numbers on a campsite or glamping field: unit mix, seasonal occupancy, nightly rates, cost per occupied night and the payback of new units, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Quote homes and offices from production rates, price recurring plans, plan supplies and crews and see the monthly profit, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

BeginnerCertificate$9.99

Trades & Local Services

Roofing Math: Pitch Multipliers, Roof Squares, Shingle Bundles, Underlayment, Gutters & Quotes

Measure and quote a roof: pitch multipliers, true roof area, bundles with waste, edge materials, tear-off weight, gutters and the job price, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Bond quotes, current yield, YTM and YTC with the yield ranking, accrued interest with 30/360 and actual/actual under T+1, tax-equivalent yield, option breakevens and max gain/loss for calls, puts and spreads, a covered call and protective put payoff chart, margin equity, SMA and maintenance calls, mutual fund NAV, POP and breakpoints, dividends, splits and rights: 8 graded labs for Series 7 and SIE-style math. Independent practice, not affiliated with FINRA or any exam provider; not investment advice.

8 lessons · 8 labs · 2 h

Measure bounces and complaint rates per mailbox provider, weight seed tests by your list, segment by engagement recency, roll the list forward with a sunset policy, score SPF/DKIM/DMARC, plan an IP warm-up and price the revenue of better inbox placement, with every cell checked as you go.

8 lessons · 8 labs · 1.9 h

IntermediateCertificate$9.99

Marketing Analytics

SMS Marketing Metrics: Opt-ins, Cost per Message, Click Rates & Revenue per Recipient

Measure text-message marketing like an analyst: opt-in sources and list growth, segments and cost per send under GSM-7 and Unicode, delivery and click-through rates, opt-out fatigue, revenue per recipient and ROI, flows vs campaigns, send-time analysis with AVERAGEIFS and SMS vs email per subscriber: 8 graded labs for a fictional coffee shop.

8 lessons · 8 labs · 2 h

IntermediateCertificate$9.99

Marketing Analytics

Market Sizing & Launch Forecasts: TAM, SAM, SOM, Adoption Curves & Bottom-Up Sales Plans

Size a market and forecast a launch: segment-based TAM, SAM and SOM, bottom-up plans, adoption curves and the assumptions that matter most, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

IntermediateCertificate$9.99

Marketing Analytics

Freemium & Free-Trial Economics: Activation, Product-Qualified Leads, Free-to-Paid Conversion & the Cost of Free Users

Make a free plan pay: activation, time-to-value, product-qualified leads, free-to-paid conversion, usage limits and what free users cost, with every cell checked as you go.

8 lessons · 8 labs · 2 h

IntermediateCertificate$9.99

Marketing Analytics

PR Measurement: Coverage Tracking, Share of Voice, Message Pull-Through, Reach & Outcome Metrics

Measure PR the way it works: a coverage log, tiered reach, share of voice, message pull-through and the visits and sign-ups that follow, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Calculate the parts for microcontroller projects: resistors, sensor readings, timing, PWM and a project power budget, with every cell checked as you go.

8 lessons · 8 labs · 2 h

IntermediateCertificate$9.99

IT & Tech

Ad-Funded Apps & Games: Impressions per User, Fill Rate, eCPM, Rewarded Video & Hybrid ARPDAU

Work out what ads really earn in an app: impressions per user, fill rate, eCPM by format and country, rewarded video and the hybrid ads-plus-purchases model, with every cell checked as you go.

8 lessons · 8 labs · 2.2 h

Normalise messy company names, block candidate pairs, score them with bigram and token similarity, combine the evidence into match / review / non-match decisions, measure precision and recall, and merge duplicates into clusters and golden records, in a live spreadsheet that checks every cell.

8 lessons · 8 labs · 2 h

IntermediateCertificate$9.99

AI & Data Science

AI Model Training & Fine-Tuning Budgets: Tokens, Compute, GPU-Hours, Experiment Grids & Scaling Curves

Budget an AI training run before you start it: dataset tokens, compute, GPU-hours, fine-tuning costs, experiment grids and scaling curves, with every cell checked as you go.

8 lessons · 8 labs · 2.2 h

Turn weather records into a transition matrix, raise it to powers with MMULT, solve the steady state with MINVERSE, use the fundamental matrix for absorbing chains, compute gambler's-ruin odds, build a snakes-and-ladders matrix from dice rolls, project brand market shares with a chart and compare a simulation with the exact answer: 8 graded labs.

8 lessons · 8 labs · 2 h

Build the drug × event 2 × 2 table from spontaneous reports, compute PRR and ROR with confidence intervals and the Yates χ², flag signals, and review time to onset, reporting trends and case outcomes, on synthetic data in a live spreadsheet that checks every cell.

8 lessons · 8 labs · 1.9 h

Plan night-sky images: framing, image scale, exposure limits, stacking time and dark windows, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Build your own objects, then use them to turn a thousand-line macro into something you can still read next year.

8 lessons · 1.1 h

Run a talent review in a workbook: nine-box placement, critical roles, successor readiness, flight-risk scores and bench strength, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Estimate and control a document review: volumes from gigabytes, culling funnels, reviewer staffing, sampling for recall and cost per document, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Turn a year of letting into a taxable result under a fictional tax system: income, expenses, depreciation, interest and losses carried forward, with every cell checked as you go.

8 lessons · 8 labs · 2.2 h

Plan a move that fits: volume of your things, boxes and van trips, DIY vs removal-firm quotes, a packing timeline and the cost of overlapping homes, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Turn a syllabus into a study plan: hours per topic, spaced review dates, practice-test trends and the score you need on the final, with every cell checked as you go.

8 lessons · 8 labs · 2 h

BeginnerCertificate$9.99

Teaching & School Admin

Planning a Thesis or Dissertation: Word Budgets, Source Matrices, Milestones, Writing Pace & Feedback Rounds

Plan a thesis like a project: words per chapter, a source matrix, milestones back from the deadline, writing pace and feedback rounds, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Plan a fundraising campaign from the gift range chart to the cash in the bank: prospects needed, pledge schedules and the funding bridge, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

IntermediateCertificate$9.99

Nonprofit & Fundraising

Online & Peer-to-Peer Fundraising: Fundraiser Pages, Giving Days, Matching Gifts, Appeal Emails & Cost per Donor

Run online appeals that add up: fundraiser pages, giving-day pacing, matching gifts, appeal emails and the net cost of every new donor, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Run a fictional hobby apiary with numbers: equipment cost per hive, brood cycles and build-up, mite counts per 100 bees (counting only), split calendars, syrup and winter stores, honey harvest and jars, prices and pollination fees and a season dashboard, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

BeginnerCertificate$9.99

Agriculture & Farming

Grain Harvest & Storage by the Numbers: Harvest Capacity, Moisture Shrink, Drying Costs, Bin Volumes & Store-or-Sell

Plan the grain harvest from the field to the sale: hectares per hour, moisture shrink, drying cost, bin capacity and whether storing pays, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Run a mass-participation race by the numbers: entry forecasts, fee tiers, start waves, aid-station supplies, kit sizes and the event P&L, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Plan a room that fits for a fictional client: floor areas and free space, furniture clearances and viewing distance, rug and art sizes, curtain fabric, wallpaper rolls, a kitchen work triangle and a room budget with delivery dates, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Follow hydrogen from electricity to product: electrolyser output, round-trip efficiency, storage volumes and the levelised cost per kilogram, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

IntermediateCertificate$9.99

Energy & Sustainability

Carbon Credits & Offset Projects by the Numbers: Baselines, Buffers, Vintages, Issuance & Cost per Tonne

Follow a carbon credit from the project baseline to its retirement: reductions, deductions, vintages, project cash flow and a buyer's cost per tonne, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Model how real people choose: hyperbolic discounting, loss aversion, probability weighting, anchoring and defaults, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Plan a tiered cake from guest count to quote: servings, batter batches, frosting and fondant amounts, ganache ratios and a fair price, with every cell checked as you go.

8 lessons · 8 labs · 1.9 h

BeginnerCertificate$9.99

Kitchen & Food at Home

Cocktail & Mocktail Math: Ratios, Dilution, Drink Strength, Batched Recipes & Party Quantities

Mix by the numbers: balanced ratios, dilution from ice, drink strength, batched recipes and how much to buy for a party, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Read the weather for a fictional mountain tour from your own numbers: summit temperatures from lapse rates, dew point with the Magnus formula, cloud base and freezing level, barometric altitude and altimeter drift, pressure trends, wind classes and wind chill, snow water and snowline, and a trip log with fictional planning flags, with every cell checked as you go.

8 lessons · 8 labs · 2.1 h

Log every session and let the numbers tell you when to raise the bar: success rates, criteria steps, practice plans and progress charts, with every cell checked as you go.

8 lessons · 8 labs · 1.9 h

Work out finished sizes, fabric to cut, floss amounts, hoop sizes and stitching time from any chart, with every cell checked as you go.

8 lessons · 8 labs · 2 h

Get your products into shops without losing money: line-sheet prices, channel margins, case packs, payment terms, deductions and reorders, with every cell checked as you go.

8 lessons · 8 labs · 1.9 h

BeginnerCertificate$9.99