Spreadsheet formulas and reconciliation
Make analysis inspectable by someone else.
What you should be able to do
Build a sourced calculation table with an independent check.
A short guide
Build a tidy table with consistent rows and clear fields. Separate inputs, calculations and conclusions. Practise sums, conditional summaries and lookups; reconcile totals and row counts. Record rules for missing values, duplicates and dates before making changes.
An example
Revenue 120 minus cost 75 gives profit 45; margin is 37.5%. Keep amounts and percentages separate.
Your task
Enter six fictional revenue/cost rows and reconcile row profits against total revenue minus total cost.
Start with this source
Formula basics, SUM, tables and filters; complete a conditional summary.
This source is awaiting renewed review. Try the task above and adjacent skills; reviewed sources will appear here.
Your learning checklist
Required items: 0 / 10 completed or already known
Next: Read a role through its responsibilities
Checklist statuses are self-reported; exercise scores are recorded separately. You can reset any item.