Learn in a useful order.
Each course connects a small set of techniques. Read the examples, check the expected results, then change the inputs to test your understanding.
Spreadsheet reporting essentials
Build a small reporting toolkit: total and count matching records, look up prices, calculate a weighted unit cost, and count a complete reporting month.
View the course →8 lessonsEveryday spreadsheet checks
Inspect imported labels, flag a stock threshold, explain percentage changes and reconcile rounding differences using small, checkable examples.
View the course →8 lessonsGrid Mechanics, Operators & Reference Locks
Master live cell coordinates, operator precedence, relative fill-down/fill-right behavior, and absolute ($B$1) plus mixed (C$2, $B4) reference locks.
View the course →8 lessonsCore Aggregations, Rounding Discipline & Cross-Sheet Links
Build audit-clean totals, blank-vs-zero averages, completeness checks, penny-accurate rounding, weighted averages, and multi-sheet formulas.
View the course →8 lessonsWorkbook Structure, Freeze Panes, Clipboard Modes & Formatting
Master Freeze Panes, Paste Values vs Formulas, non-destructive Currency/Percent formatting, Named Ranges, Conditional Formatting, Sort, AutoFilter, and formula auditing.
View the course →8 lessonsLogical Decisions, Multi-Branch Rules & Error Guards
Build leak-free decision models with blank-guarded IF, AND/OR/NOT/XOR gates, ordered IFS brackets, discrete SWITCH mappings, surgical IFNA vs IFERROR guards, and boundary checks.
View the course →8 lessonsConditional Aggregations: SUMIFS, COUNTIFS & AVERAGEIFS
Build dynamic single- and multi-criteria summaries with SUMIF, COUNTIF, SUMIFS, COUNTIFS, guarded AVERAGEIF/AVERAGEIFS, MINIFS/MAXIFS corridors, wildcards, expanding running counts, and tie-out checks.
View the course →8 lessonsWeighted Analytics, Clean LET Formulas & Dynamic Arrays
Master boolean-masked SUMPRODUCT, blended margins, LARGE/SMALL/RANK/PERCENTILE benchmarks, self-documenting LET variables, and spilled dynamic arrays (UNIQUE, SORT, SORTBY, FILTER, SEQUENCE, VSTACK, HSTACK, TAKE, DROP).
View the course →8 lessonsExact Key Lookups, Missing-Key Guards & Catalog Joins
Master exact VLOOKUP, HLOOKUP, IFNA missing-key guards, modern XLOOKUP (leftward, bottom-up revisions, multi-column spills, cross-sheet joins), TRIM/VALUE key hygiene, CHOOSE switches, and duplicate-key gates.
View the course →8 lessonsINDEX/MATCH, Two-Way Matrix Lookups & Tiered Rate Brackets
Build 1D/2D INDEX + MATCH + XMATCH lookups, dynamic financial statement columns, CHOOSEROWS/CHOOSECOLS matrix slices, floor/ceiling XLOOKUP rate brackets, compound-key boolean matches, and progressive marginal slabs.
View the course →8 lessonsWhitespace Hygiene, Case Normalization & Delimiter Text Slicing
Master TRIM, CLEAN, non-breaking space removal, UPPER/LOWER/PROPER standardization, LEN width gates, LEFT/RIGHT/MID slicing, FIND/SEARCH delimiter offsets, Nth SUBSTITUTE, REPLACE masking, EXACT verification, and REPT zero-padding.
View the course →8 lessonsImported CSV Type Coercion, Composite Keys & Deduplication Audits
Coerce CSV text numbers, strip currency punctuation, parse trailing-minus credits, format dates/numbers with TEXT, join addresses skipping blanks, build pipe composite keys, isolate retry duplicates with expanding COUNTIF/COUNTIFS, repair locale decimals, and snapshot via Paste Values.
View the course →8 lessonsCalendar Construction, Month-End Cutoffs & Tenure Spans
Master DATE/YEAR/MONTH/DAY assembly, 8-digit YYYYMMDD integer repair, DAYS durations, EDATE leap-year renewals, EOMONTH cutoffs, DATEDIF ("Y"/"YM") tenures, fiscal quarters, pro-rata billing, timestamp upper bounds, dynamic monthly headers, DATEVALUE parsing, and chronology guards.
View the course →8 lessonsBusiness-Day SLAs, Holiday Calendars & Receivables Aging
Model ISO WEEKDAY flags, WORKDAY & holiday-aware delivery schedules, NETWORKDAYS SLA turnaround clocks, next-Friday & previous-Monday anchors, AR days past due, 5-tier IFS aging buckets, SUMIFS aging matrices, weighted bad-debt provisions, milestone cascades, monthly capacity hours, and open-ticket cutoffs.
View the course →8 lessonsBudget vs Actual Variance, Favorable/Unfavorable Logic & Margin Bridges
Master zero-guarded revenue variance, revenue vs expense polarity, dual materiality gates, Gross-to-Net waterfalls, blended gross margin, Price-Volume decomposition, YTD TAKE/DROP forecasts, quota run-rates, SUMIFS OpEx rollups, common-size P&Ls, operating leverage, and cross-foot checksums.
View the course →8 lessonsInventory Control, Ledger Reconciliation & Pivot Cross-Checks
Build perpetual stock rollforwards, safety-stock reorder points, MOQ & carton-pack PO rounding, Days on Hand (DOH), obsolescence reserves, Pareto ABC classes, XLOOKUP two-ledger reconciliations, timing vs error gates, SUM/COUNT/AVERAGE PivotTables, stale-pivot tie-outs, PMT/PV leases, NPV/IRR, and CCC cash buffers.
View the course →8 lessonsExecutive KPI Scorecards, Rolling Windows & Cohort Retention
Build selector-driven KPI cards, dynamic rolling 3M/6M TAKE/DROP windows, NRR & logo churn bridges, SaaS Magic Number & CAC payback cards, utilization & realization scorecards, clamped 0–100 SLA composites, cohort retention triangles, scenario switchboards, multi-currency FX consolidations, mid-month payroll ramps, Top-5 LARGE concentration checks, and cross-sheet board packs.
View the course →8 lessonsChart Staging Ranges, Composition Shares & Column/Bar/Doughnut Charts
Turn raw transaction logs into clean one-row-per-category staging ranges, exclude distorting Grand Total rows, sort long labels for horizontal Bar charts, audit 100% composition shares for Doughnut/Pie charts, group small tail items into Other, scale $ Thousands axes, build dynamic TEXT chart headlines, filter zero rows, and highlight Peak or Below-Target bars via split helper series.
View the course →8 lessonsTime-Series Indexing, Moving Averages, Target Bands & Line/Area Charts
Build chronological monthly SUMIF trend tables, rebase multi-scale series to Base = 100, smooth noise with 3-week and 7-day moving averages, add dynamic SLA corridor bands, compare cumulative YTD trajectories against linear quota pace, bridge missing mid-series months without zero drops, stage backlog Area charts, align 12-month YoY overlays, compute Seasonality & Drawdown indices, and weld Historical-to-Forecast handoffs.
View the course →8 lessonsPareto 80/20 Curves, Variance Bridge Helpers & Scatter XY Diagnostics
Sort defect distributions descending for Pareto 80/20 diagnostics, classify Vital Few vs Tail buckets, engineer floating Waterfall bridge Base/Up/Down columns, track Gross-to-Net pocket price realization and corkscrew headcount bridges, plot zero-centered diverging variance & Tornado sensitivity Bar charts, build COUNTIFS histograms, and diagnose XY Scatter relationships with SLOPE, INTERCEPT, CORREL, and Z-Score outlier flags.
View the course →8 lessonsCollaborative Roles, Proposal Staging, Sign-Off Gates & Team Handoffs
Separate editable Contributor inputs from calculated formula columns, design least-privilege Owner/Contributor/Suggester/Viewer role matrices, stage Suggester proposals alongside approved baselines, route minor tweaks via tolerance gates, resolve @mention review threads, consolidate multi-department tabs without cursor collisions, compare v1/v2 snapshots, shield executive Viewer tabs, and enforce unanimous sign-off gates.
View the course →8 lessonsAI-Assisted Workbook Audits, Attachment Staging & Team Capstones
Structure clean headers and contiguous selection contexts for the Arte Sheets AI Assistant, verify AI-generated formulas against zero/tie edge cases, reconcile staged .csv/.xlsx attachment rows against statement totals, audit multi-step voice/text plans, respect Suggester vs Contributor AI role boundaries, catch hardcoded overrides with ISFORMULA, repair drifted locks and off-by-one ranges, stress-test cash runway scenarios, and complete full cross-stage team capstones.
View the course →