BeginnerGeneral office
Add up a column and find the average
Total a column of quantities, then find the average order size.
About 4 minutes. 6 steps.Learning paths
Beginner: first formulas
Totals, averages, simple decisions and tidy text. Start here if formulas still feel new.
Intermediate: lookups, dates and summaries
Find things in tables, work with dates, and summarise by group.
- Look up a price from a price list8 min
- Work out commission from sales tiers6 min
- Rank students and find the top scores7 min
- Summarise salaries by department7 min
- Work out years of service and probation dates6 min
- Find due dates and overdue invoices7 min
- Check which items from one list are in another7 min
- Measure marketing campaign results7 min
- Split a full name into first and last name6 min
- Compare loan payments6 min
Advanced: combine functions
Two-way lookups and nested formulas. Comfortable with lookups first.
All tutorials
17 tutorials
BeginnerEducation
Mark pass or fail and give a grade
Turn a score into Pass or Fail, then into a letter grade.
About 6 minutes. 6 steps.IntermediateEducation
Rank students and find the top scores
Find who is first, who is second, and where each student stands.
About 7 minutes. 6 steps.BeginnerSales
Total sales by product and region
Add up quantities for one product, one region, and both at once.
About 7 minutes. 6 steps.IntermediateSales
Look up a price from a price list
Type a product code and get the price back, with a friendly message when the code is wrong.
About 8 minutes. 6 steps.IntermediateSales
Work out commission from sales tiers
Find the right commission rate for a sales total using a sorted table, then calculate the amount.
About 6 minutes. 5 steps.BeginnerAdministration
Clean up names and emails pasted in
Remove extra spaces and fix capital letters in a messy contact list.
About 6 minutes. 6 steps.IntermediateHR
Split a full name into first and last name
Separate “First Last” into two columns without retyping.
About 6 minutes. 5 steps.IntermediateHR
Work out years of service and probation dates
Calculate how long someone has worked here and when a probation period ends.
About 6 minutes. 5 steps.IntermediateHR
Summarise salaries by department
Headcount, average and highest salary for one department.
About 7 minutes. 6 steps.IntermediateFinance and accounting
Find due dates and overdue invoices
Add payment terms to an invoice date and flag what is late, as of a chosen date.
About 7 minutes. 6 steps.IntermediateFinance and accounting
Compare loan payments
Find the monthly payment on a loan and how much interest you pay in total.
About 6 minutes. 5 steps.BeginnerPersonal budgeting
Compare your budget with what you spent
See where you are over plan and by how much.
About 5 minutes. 7 steps.BeginnerOperations
Flag stock to reorder and value your inventory
Spot items at or below their reorder level and find the value of what you hold.
About 6 minutes. 6 steps.IntermediateOperations
Check which items from one list are in another
Find which ordered items arrived and which are missing.
About 7 minutes. 6 steps.IntermediateMarketing
Measure marketing campaign results
Cost per lead, conversion rate and return for each campaign.
About 7 minutes. 7 steps.AdvancedGeneral office
Pick a delivery price from a two-way grid
Look up a price by weight and zone in one formula.
About 7 minutes. 5 steps.No tutorial matches.
Clear the filters, or tell us the job and let’s talk.
Let’s Talk