Projects: real work, checked properly

Download a workbook, do the job in Excel itself, then upload your file. We check what you built, including formulas, charts and PivotTables. Your file is checked in your browser, and it isn’t uploaded anywhere.

• Sales and operations

  Regional sales summary

  Turn a raw sales export into a summary a manager can actually use, with totals, a chart and a dropdown.

  SUMIFS · XLOOKUP or INDEX/MATCH · Charts · Data validation

  Open the project

• Business analysis

  PivotTable analysis

  Answer a manager’s question with a PivotTable, the way analysts really do it.

  PivotTables · Reading results

  Open the project

• Finance

  Budget against actual

  Build the monthly budget review that finance teams run: variances, percentages and highlighted overspends.

  Formulas · Absolute references · Conditional formatting

  Open the project

• Operations and marketing

  Customer list clean-up

  Fix an exported customer list: stray spaces, random capitals and duplicate rows, then turn it into a proper Excel table.

  TRIM, PROPER and LOWER · Remove Duplicates · Excel Tables

  Open the project

• Finance and lending

  Loan repayment schedule

  Build the first year of a loan schedule: each month’s payment, interest, principal and balance.

  PMT · Absolute references · Building a schedule

  Open the project

• Retail and supply chain

  Stock and reorder report

  Turn a stock list into a report that flags what to reorder and shows where the money is tied up.

  IF · Conditional formatting · COUNTIF · Sorting

  Open the project