Arte SheetsLearn. Try. Understand.
Guided learning

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.

7 lessons

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 lessons

Everyday spreadsheet checks

Inspect imported labels, flag a stock threshold, explain percentage changes and reconcile rounding differences using small, checkable examples.

View the course →
8 lessons

Grid 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 lessons

Core 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 lessons

Workbook 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 lessons

Logical 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 lessons

Conditional 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 lessons

Weighted 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 lessons

Exact 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 lessons

INDEX/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 lessons

Whitespace 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 lessons

Imported 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 lessons

Calendar 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 lessons

Business-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 lessons

Budget 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 lessons

Inventory 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 lessons

Executive 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 lessons

Chart 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 lessons

Time-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 lessons

Pareto 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 lessons

Collaborative 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 lessons

AI-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 →