Applied Excel practice

A lesson teaches one function. These guides put several together on a single task, the way the work actually arrives: a budget that does not add up, two lists that disagree, an import full of stray spaces.

Each guide uses original synthetic data with the source rows and columns shown, so you can reproduce every formula. They are teaching examples, not a reproduction of any employer's assessment.

• Excel interview questions with practical answers

  Solve four original spreadsheet tasks on references, conditional totals, missing lookups and grouped reporting, with complete worked answers.

  Practises references, sumifs, xlookup, worksheet pivots, worksheet charts

• Reconcile two lists in Excel: duplicates and missing IDs

  Work through original equipment receipt lists, detect duplicate keys, aggregate additive postings and distinguish missing records from zero.

  Practises xlookup, countif, sumif, reconciliation, text, value

• Budget vs actual Excel practice: retain the variance sign

  Calculate signed and percentage expense variances, a zero-plan edge case and an overspend-only total with complete workshop data.

  Practises variance, sumifs, abs, share, worksheet charts

• Clean imported Excel data: spaces, fields and numeric text

  Repair six original registration records, split every field, convert seat counts and check that cleanup preserves the row count.

  Practises text, proper, value, textbefore, textafter, array textsplit, array filter, worksheet tables