Learn a skill. Put it to work.

Reconcile a clean quote with accrued interest and cash, solve its yield, then compare duration with exact repricing.

Before you start: Numeric dates, absolute references, decimal rates and the difference between a per-100 quote and a face amount.

You will be able to: Keep regular coupon schedules and day-count inputs aligned while interpreting PRICE, YIELD, DURATION and MDURATION in three complete reports.

0 / 3 tasks practiced · 48 min of lesson material

Checkpoint: Reading saved challenge status…

1. Reconcile clean price, accrued interest and settlement cash
2. Infer yield from a coupon bond quote
3. Compare duration with exact bond repricing

Build a mean interval, preserve matched changes and compare independent groups with unequal variances.

Before you start: Sample counts, averages, sample variation, proportions and the distinction between independent groups and matched records.

You will be able to: Reconcile sample standard errors, two-sided intervals, signed statistics and p values while keeping sampling assumptions and fractional Welch degrees of freedom visible.

0 / 3 tasks practiced · 58 min of lesson material

Checkpoint: Reading saved challenge status…

1. Estimate a mean with a two-sided t interval
2. Compare changes in the same matched records
3. Compare independent groups without pooling their variances

Compare fixed independent trials, finite sampling without replacement and event counts in a scaled observation window.

Before you start: Basic formula references, whole counts and decimal proportions. Distinguish a model assumption from an observed frequency.

You will be able to: Calculate exact, cumulative, inclusive interval and stable upper-tail probabilities; reconcile expected counts and keep replacement/window assumptions explicit.

0 / 3 tasks practiced · 52 min of lesson material

Checkpoint: Reading saved challenge status…

1. Compare exact, cumulative and interval event counts
2. Compare finite sampling with a replacement model
3. Scale an event-count model to its observation window

Combine two predictors in one fitted response, then model proportional changes across actual period gaps.

Before you start: Numeric source values, basic references and separate output formulas. The descriptive-statistics track introduces sample variation.

You will be able to: Read reversed LINEST coefficients, retain the intercept, calculate new TREND/GROWTH estimates and interpret residual diagnostics on the model’s fitted scale.

0 / 2 tasks practiced · 36 min of lesson material

Checkpoint: Reading saved challenge status…

1. Fit two predictors and inspect the residuals
2. Fit a per-unit multiplier and a new level

Compare equal and front-loaded annual charges, reconcile fixed and accelerated balances, then allocate a fractional-year window from one origin.

Before you start: Numeric inputs, absolute references and the difference between an expense during a period and a remaining carrying value.

You will be able to: Use SLN, SYD, DB, DDB and VDB with explicit salvage, year/fiscal controls, rate rounding, switching assumptions and independently reconciled book values.

0 / 3 tasks practiced · 50 min of lesson material

Checkpoint: Reading saved challenge status…

1. Compare annual charges and the remaining carrying value
2. Compare fixed and accelerated declining balances
3. Allocate a partial-year window from one fixed origin

Separate time zero from future periods, keep actual date-value pairs aligned, then explain financing and reinvestment assumptions.

Before you start: Signed numeric flows, decimal percentages and basic references. The loan cash-flows track introduces cash-flow signs.

You will be able to: Use NPV/IRR, XNPV/XIRR and MIRR with explicit timing, unique-yield boundaries and independently reconciled source totals.

0 / 3 tasks practiced · 51 min of lesson material

Checkpoint: Reading saved challenge status…

1. Evaluate a periodic project without discounting time zero
2. Evaluate dated cash flows using actual day intervals
3. Explain a modified return with finance and reinvestment rates

Read AND/OR rules from a criteria table, require exactly one record when retrieving a value, then report the selected numeric population.

Before you start: Basic references, numeric versus text values and formula entry. The criteria-and-references track is useful preparation.

You will be able to: Use DSUM, DCOUNT, DGET, DAVERAGE, DMIN and DMAX without double-counting OR overlaps or disguising missing/ambiguous records.

0 / 3 tasks practiced · 45 min of lesson material

Checkpoint: Reading saved challenge status…

1. Summarize records selected by a criteria table
2. Retrieve exactly one database record
3. Describe the numeric records selected by criteria

Classify genuine errors, replace only missing-value failures, then summarize the actual numeric population in a mixed source.

Before you start: Basic references and a clear spill area. Error-looking text is different from a typed Excel error.

You will be able to: Choose a narrow fallback policy, preserve nonmissing failures and explain the numeric denominator and complete error count.

0 / 3 tasks practiced · 45 min of lesson material

Checkpoint: Reading saved challenge status…

1. Classify real errors without misreading text
2. Replace only missing-value errors
3. Summarize measurements that contain errors

Pair record inputs with MAP, accumulate individually rounded charges with REDUCE, then generate carrier-by-parcel quotes with MAKEARRAY.

Before you start: Formula entry, numeric values and a clear spill area. The dynamic-array reports track introduces one-anchor outputs.

You will be able to: Choose element-wise, accumulator or coordinate-based iteration and preserve source alignment, rounding order and changing output dimensions.

0 / 3 tasks practiced · 45 min of lesson material

Checkpoint: Reading saved challenge status…

1. Calculate rounded charges for paired records
2. Accumulate posted charges after rounding each line
3. Build a carrier by parcel shipping quote matrix

Cross a source column with a horizontal constant, audit Boolean decisions and counts, then return three fields for four lookup requests.

Before you start: Cell references, numeric versus text values and ordinary formula entry. Start here before the larger dynamic-array reports.

You will be able to: Preserve row/column meaning, count overlapping OR conditions once and keep literal first-match lookup results aligned with repeated queries.

0 / 3 tasks practiced · 48 min of lesson material

Checkpoint: Reading saved challenge status…

1. Cross a column with a horizontal array
2. Audit row-wise Boolean masks and counts
3. Return three fields for a batch of lookup queries

Align columns before stacking exports, flatten numeric readings in a chosen scan order, then select the last active records.

Before you start: Basic references, numeric versus text values and a clear spill area. The dynamic-array reports track is useful preparation.

You will be able to: Combine VSTACK, CHOOSECOLS, TOCOL and TAKE with explicit record, type and order rules while preserving zeroes, returns and duplicate observations.

0 / 3 tasks practiced · 45 min of lesson material

Checkpoint: Reading saved challenge status…

1. Combine exports with different column orders
2. Flatten numeric readings in a declared scan order
3. Return the last N active records

Convert a declared timestamp grammar, calculate overnight clock hours and count dates shared with a reporting window, then rebuild calendar/clock components, measure complete year/month intervals and retain multi-day clock carry.

Before you start: Basic references, numeric dates and formula entry. The foundations track is useful preparation.

You will be able to: Keep dates numeric, distinguish normalization from month-end clamping, and apply explicit import, shift, overlap and complete-year/month rules.

0 / 5 tasks practiced · 80 min of lesson material

Checkpoint: Reading saved challenge status…

1. Convert fixed-width local date and time text
2. Calculate hours for a shift across midnight
3. Count dates shared by two inclusive intervals
4. Rebuild dates and measure complete calendar intervals
5. Advance clock components and retain whole-day carry

Choose the posted records, aggregate signed units, then build two-axis means and shares with explicit populations.

Before you start: Basic formula entry, signed numbers and a clear spill area. The dynamic-array reports track is useful preparation.

You will be able to: Use GROUPBY, PIVOTBY and PERCENTOF for three changing reports; distinguish missing intersections from measured zero and recompute totals from original records.

0 / 3 tasks practiced · 54 min of lesson material

Checkpoint: Reading saved challenge status…

1. Group posted net units by region
2. Cross-tabulate posted order means
3. Report each group share of net units

Aggregate split receipts, find missing required records, then compare the complete key population across two exports.

Before you start: Formula entry, literal text IDs and clear spill areas. The clean-and-compare and dynamic-array tracks are useful preparation.

You will be able to: Build three reusable reports with explicit case, duplicate, blank-row and signed-amount rules, including records found on only one side.

0 / 3 tasks practiced · 52 min of lesson material

Checkpoint: Reading saved challenge status…

1. Sum repeated payments for each invoice
2. List required IDs missing from another export
3. Reconcile grouped totals from two exports

Align rate and payment periods, keep cash-flow signs, then reconcile principal and interest across a constant-payment schedule.

Before you start: Basic formula entry, cell references and decimal percentages. The foundations track is a useful starting point.

You will be able to: Build a periodic payment, inspect one end payment and reconcile outstanding debt without rounding the internal payment.

0 / 3 tasks practiced · 42 min of lesson material

Checkpoint: Reading saved challenge status…

1. Calculate a periodic loan payment with consistent units
2. Split a selected loan payment into interest and principal
3. Reconcile remaining loan balance after scheduled payments

Build a clean starting point: combine names, recognise imported numbers, then calculate change with an explicit base rule and compose a numeric quote with formatted business labels, then compare numeric, Boolean, text and reference operators in the same live report.

Before you start: Comfortable selecting cells and entering a formula beginning with =.

You will be able to: Prepare a small imported table and explain why a result needs review.

0 / 5 tasks practiced · 61 min of lesson material

Checkpoint: Reading saved challenge status…

1. Join text fields without extra spaces
2. Convert imported text into numbers
3. Calculate percentage change from a positive base
4. Compose a numeric quote and formatted business labels
5. Compare formula operators and their evaluation order

Separate display cleanup from record identity. Decide what counts as a duplicate, list distinct values and retrieve an exact match.

Before you start: The foundations track, or equivalent experience with references and text values.

You will be able to: Choose a matching policy and test missing, repeated and differently cased values.

0 / 4 tasks practiced · 31 min of lesson material

Checkpoint: Reading saved challenge status…

1. Clean spaces and line breaks in imported text
2. Find and flag duplicate values
3. Count distinct values and show the list
4. Look up a price by an exact ID

Anchor what must stay fixed, count qualifying records, then total a half-open date window without losing refunds.

Before you start: Formula entry, basic comparisons and the difference between text and numbers.

You will be able to: Build and check a reusable report across changing rows and boundary dates.

0 / 3 tasks practiced · 23 min of lesson material

Checkpoint: Reading saved challenge status…

1. Fill formulas across and down with fixed references
2. Count records that meet several conditions
3. Sum amounts that meet several conditions

Choose the population, keep the denominator, then turn a declared metric into a review decision. Finish with a three-output report.

Before you start: Basic formula entry, fixed references and multiple criteria, or the criteria-and-references track.

You will be able to: Build conditional and weighted means, separate missing measurements from zeroes, and explain which metric drives the final flag.

0 / 4 tasks practiced · 41 min of lesson material

Checkpoint: Reading saved challenge status…

1. Average the records that qualify
2. Weight a workload by its case counts
3. Classify deliveries against an SLA
4. Build an operational review with the right denominator

Choose a lookup rule from the question: an exact record, a complete multi-field key with a match count, a row-and-column intersection, a horizontal field, an intentional pattern, explicit source-position modes, or the nearest lower quantity threshold. Then compare a frozen IF policy with its maintained table replacement and resolve overlapping Boolean rules with explicit branch priority.

Before you start: Basic formula entry and fixed references; the clean-and-compare track covers the first exact lookup.

You will be able to: Build lookup formulas that survive reordered tables, missing labels, zero results and boundary quantities; resolve overlapping conditions with an explicit priority.

0 / 9 tasks practiced · 148 min of lesson material

Checkpoint: Reading saved challenge status…

1. Look up a price by an exact ID
2. Look up a rate with multiple criteria
3. Find a value at a row and column intersection
4. Look up fields across a horizontal source
5. Choose wildcard searches or literal product codes
6. Compare MATCH modes and maintained groups
7. Choose a rate from quantity bands
8. Refactor a nested IF policy into a maintained rule table
9. Resolve overlapping request rules with explicit priority

Separate advancing by working days from counting an inclusive interval, then combine a calendar month boundary with a working-day rule and generate a configurable month-end series.

Before you start: Basic formula entry, numeric dates and fixed references.

You will be able to: Build schedules with explicit weekly closures, office holidays, signed offsets and leap-year boundaries.

0 / 4 tasks practiced · 54 min of lesson material

Checkpoint: Reading saved challenge status…

1. Schedule dates with a working calendar
2. Count eligible dates between two endpoints
3. Choose a working cutoff at month end
4. Generate a configurable month-end date series

Build one-anchor reports that change shape, preserve row alignment and expose every intermediate balance.

Before you start: Formula entry, numeric versus text inputs and basic row criteria; the criteria-and-references track is a useful starting point.

You will be able to: Combine LET, FILTER and SORTBY; carry state with SCAN; and summarise rows with BYROW and HSTACK while keeping spill outputs clear.

0 / 3 tasks practiced · 42 min of lesson material

Checkpoint: Reading saved challenge status…

1. Build a filtered priority queue with a stable tie rule
2. Calculate every running balance with SCAN
3. Return one numeric review mean for every record

Compare stored-type counts and explicit mean populations, keep sample size and missing data visible, choose an inclusive percentile, compare both rank directions and tied positions, then build a reproducible two-tail review rule.

Before you start: Basic formula entry and cell references. Summary tasks use separate report formulas; rank columns fill only within their declared scopes.

You will be able to: Explain numeric versus text observations, sample spread, interpolated percentiles, tied values and strict IQR fences without removing original data.

0 / 6 tasks practiced · 106 min of lesson material

Checkpoint: Reading saved challenge status…

1. Count numbers, text, logical values and blank-like cells
2. Compare mean populations without changing stored types
3. Summarise a numeric sample without hiding missing data
4. Rank records without sorting the source
5. Compare a chosen percentile with an allowance
6. Flag observations outside the IQR fences

Split imported records, preserve literal identifiers, compare explicit capitalization policies and build line-separated labels without losing spaces or empty-slot meaning.

Before you start: Formula entry, text versus numbers and a clear spill area. The clean-and-compare track is a useful starting point.

You will be able to: Declare separators and cleanup rules, preserve record order and text identity, and check both the shape and values of a text report.

0 / 5 tasks practiced · 82 min of lesson material

Checkpoint: Reading saved challenge status…

1. Split a pasted log into rows and fields
2. Extract both sides of the final separator
3. Normalize and review structured reference codes
4. Compare upper, lower, proper and preserved text
5. Build and inspect line-separated address labels

Build a scenario table, copy expanding prefixes, then compare OFFSET and INDEX on one controlled physical source range.

Before you start: Basic formula entry, numeric source values and a cell address.

You will be able to: Choose which reference parts stay fixed, inspect actual copies and prove every intermediate result after source changes.

0 / 3 tasks practiced · 42 min of lesson material

Checkpoint: Reading saved challenge status…

1. Fill formulas across and down with fixed references
2. Copy expanding ranges into complete running totals
3. Compare OFFSET and INDEX dynamic ranges