Health & FitnessNutrition & Fitness Math
BMI, calorie needs, macros, meal plans, training volume, 1RM and heart-rate zones: build the numbers behind fitness in a live spreadsheet that checks every cell.
BeginnerCertificate$9.99
Health & Fitness
Health numbers, calculated and understood
Health information is full of numbers: calories and macros, heart-rate zones, risk ratios, survival curves, doses. These courses teach you to compute them yourself in a spreadsheet, with every step checked, so you can read studies, data from your own devices and public-health figures with a sharper eye.
The 20 courses range from nutrition and running maths to wearable data, blood-pressure and glucose analysis, dosage calculations, pharmacokinetics, epidemiology, epidemic models, clinical-trial and screening statistics, health economics, psychometrics, workplace safety and EMS response analytics. All content is educational and does not replace advice from a qualified professional.
Courses in Health & Fitness
Health & Fitness
Health & FitnessSports Analytics in Excel
League tables, per-90 stats, true shooting %, expected goals, Elo ratings, Pythagorean wins, z-score scouting and Poisson match predictions: build the numbers analysts use in a live spreadsheet that checks every cell.
IntermediateCertificate$9.99
Health & FitnessRunning & Endurance Training Math
Pace and speed, race-time prediction, training zones, mileage build-up, 80/20 intensity, training load, taper and marathon fuelling: plan endurance training with formulas in a live spreadsheet that checks every cell.
BeginnerCertificate$9.99
Health & FitnessEpidemiology & Health Statistics in Excel
Rates, age standardisation, 2×2 tables, screening tests, NNT, confidence intervals, epidemic curves and life tables: build the core numbers of public health in a live spreadsheet that checks every cell.
IntermediateCertificate$9.99
Health & FitnessHealth Insurance Plan Math: Deductibles, Coinsurance & Out-of-Pocket
Work out premiums, split claims into deductible, coinsurance and the out-of-pocket cap, track a year of claims, compare plans across usage scenarios, find break-even usage, value a health savings account and family deductibles, and pick a plan by expected cost, with every cell checked as you go.
BeginnerCertificate$9.99
Health & FitnessDosage Calculations for Nursing & Pharmacy
Unit conversions, desired over have, mg/kg dosing, IV flow and drip rates, infusion times, dilutions, % and ratio strengths and BSA doses – each lab with a safety check. Practice with placeholder drugs only, not clinical guidance.
BeginnerCertificate$9.99
Health & FitnessHealth Economics: QALYs, ICER & Cost-Effectiveness
QALYs, discounting, ICERs and dominance, the cost-effectiveness plane, net monetary benefit, a Markov cohort model, tornado sensitivity analysis and budget impact: build a health-technology assessment of a fictional therapy step by step in a live spreadsheet that checks every cell.
IntermediateCertificate$9.99
Health & FitnessWearable Health Data: Steps, Heart Rate, HRV & Sleep Analysis
Step averages and streaks, weekly trends, resting heart rate with rolling averages, heart-rate zones, HRV (RMSSD) against a baseline, sleep efficiency, social jetlag and correlations: 8 graded labs on one fictional user's tracker data. Not medical advice.
BeginnerCertificate$9.99
Health & FitnessClinical Trial Statistics: Sample Size, Randomisation & Survival Curves
Plan and analyse a fictional heart-failure trial: sample size and power, block randomisation, the baseline table, the primary endpoint with CI and p-value, NNT, a Kaplan-Meier curve by hand and interim boundaries, in a live spreadsheet that checks every cell. Educational, not medical advice.
IntermediateCertificate$9.99
Health & FitnessEpidemic Modeling: SIR Models, R0 & Herd Immunity in Excel
Growth rates and doubling times, R0 from the generation interval, an SIR model with daily Euler steps, peak and final size, herd immunity and vaccination coverage, interventions, the SEIR extension and a first model fit: build the classic epidemic models in a live spreadsheet that checks every cell. Synthetic data, educational only, not public-health guidance.
IntermediateCertificate$9.99
Health & FitnessPharmacokinetics Basics: Half-Life, Clearance & Steady State
First-order elimination, half-life and k from two levels, volume of distribution, clearance and AUC with the trapezoid rule, accumulation to steady state, time to plateau, infusions and the effect of kidney function, all in a live spreadsheet that checks every cell. Placeholder drugs and illustrative parameters only, not clinical guidance.
IntermediateCertificate$9.99
Health & FitnessPsychometrics in Excel: Scale Scoring, Reliability & Item Analysis
Score a questionnaire like a psychometrician: reverse-keyed items, missing-item rules, z- and T-scores, Cronbach's alpha by hand, corrected item-total correlations, alpha if item deleted, test-retest reliability, SEM and reliable change, norm tables and percentile ranks – 8 labs on one fictional wellbeing scale with synthetic data, every cell checked instantly. Not a clinical or diagnostic tool.
IntermediateCertificate$9.99
Health & FitnessWorkplace Safety Metrics: TRIR, LTIFR, Severity Rates & Leading Indicators
Measure safety performance like an HSE analyst: hours worked and the incident log, TRIR on the 200,000-hour base, LTIFR per million hours, DART and severity rates, the cost of incidents, leading vs lagging indicators with CORREL, site benchmarks with conditional formatting and a 12-month rolling trend chart – 8 labs on one fictional company, every cell checked instantly. Educational only, no affiliation with OSHA, ILO or any regulator.
IntermediateCertificate$9.99
Health & FitnessVaccination Program Logistics: Doses, Wastage, Cold Chain & Clinic Capacity
Plan a vaccination campaign by the numbers: target population and coverage goals, doses with schedules and drop-out, wastage rate and wastage factor with multi-dose vials, cold-chain litres vs fridge capacity, clinic throughput, appointment no-show buffers, weeks of stock and reorder points, and a coverage tracking chart – 8 labs on one fictional district with a generic Vaccine X, every cell checked instantly. Logistics practice only, not medical guidance.
IntermediateCertificate$9.99
Health & FitnessGrowth Charts & Percentiles: Z-Scores, LMS Method & BMI-for-Age
Percentiles and z-scores with NORM.S.DIST/NORM.S.INV, the LMS formula behind WHO and CDC growth charts, percentile curves, BMI-for-age, growth velocity, crossing percentile lines, interpolation by age and a cohort summary: 8 graded labs on synthetic children with illustrative tables. Not medical advice.
IntermediateCertificate$9.99
Health & FitnessEMS Response Time Analytics: Percentiles, Coverage & Unit-Hour Utilisation
Analyse a fictional ambulance service in a live grid: call-to-arrival intervals from CAD timestamps, 90th percentiles, compliance by zone and priority, unit-hour utilisation, demand vs staffing, station coverage, hospital offload delays and a performance dashboard, every cell checked as you go.
IntermediateCertificate$9.99
Health & FitnessGlucose Data Analysis: Time in Range, GMI & Variability from CGM Data
Check data sufficiency, convert mg/dL and mmol/L, compute time in range, below and above with COUNTIFS, the glucose management indicator, the coefficient of variation, the daily pattern by hour, low events of 15 minutes or more and a weekly summary with highlights and a stacked chart: 8 graded labs on one fictional CGM user's synthetic data. Educational only, not medical advice.
IntermediateCertificate$9.99
Health & FitnessScreening Programme Analytics: PPV by Prevalence, Yield, Cost per Case & Biases
Analyse a (fictional) cancer screening programme the way a public-health analyst does: build the 2×2 table from programme data, see how PPV moves with prevalence, pick a cut-off with Youden's J and colonoscopy capacity, combine two tests, measure yield, NNS, uptake gaps and cost per QALY, and put numbers on lead-time and length-time bias, every cell checked live.
IntermediateCertificate$9.99
Health & FitnessBlood Pressure Data Analysis: Home Readings, Averages, Categories & Trends
Clean a home-monitor log, average morning and evening readings with AVERAGEIFS, derive pulse pressure and mean arterial pressure, classify every reading with threshold tables, measure the weekly trend with SLOPE, quantify variability, compare clinic and home averages and build a summary for a doctor's visit: 8 graded labs on one fictional person's synthetic readings. Educational only, not medical advice.
BeginnerCertificate$9.99
Health & FitnessPharmacovigilance Signal Detection: PRR, ROR, Chi-Square & Case Counts
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.
IntermediateCertificate$9.99
Guides with worked examples
TDEE Formula: How to Calculate TDEE (Mifflin-St Jeor)
The TDEE formula step by step: BMR with Mifflin-St Jeor, activity multipliers from 1.2 to 1.9, a calorie target and macros. Worked example for two people.
Sensitivity and Specificity Calculation with PPV and NPV
How to calculate sensitivity, specificity, PPV and NPV from a 2×2 table in Excel, and why a positive result means far less when a disease is rare.
Kaplan-Meier Curve in Excel: Survival Table Step by Step
How to make a Kaplan-Meier curve in Excel: at-risk counts, censoring, S(t) = S(prev) × (1 − d/n), median survival and a step chart. Worked example.
TRIR Calculation: Formula, Example and Excel Calculator
TRIR calculation step by step: recordables × 200,000 ÷ hours worked, a company rate from four sites, a target case limit, DART and LTIFR. Excel example.
SIR Model in Excel: Step-by-Step Epidemic Model with R0
Build an SIR model in Excel: new infections β·S·I/N, recoveries γ·I, daily Euler steps, R0, herd immunity threshold, peak and final size. Worked example.
Half-Life and Elimination Rate Constant Calculator (Excel)
Calculate the elimination rate constant k and the half-life from two drug concentrations, back-extrapolate C0 and see how a drug falls. Excel example.
Frequently asked questions
Can I use these courses for medical decisions?
No. The courses teach calculations with illustrative data. Diagnosis and treatment belong with doctors, pharmacists and other qualified professionals.
Are the nursing dosage courses exam preparation?
They are practice for the calculation methods used in nursing and pharmacy training. Always follow your programme's and employer's protocols.
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.