fx
Practice Spreadsheets
Lessons
Pro
0 of 62
Getting started
What a cell is
Moving with the keyboard
Rows, columns and ranges
Jumping to the edge of the data
Selecting rows, columns and everything
Typing values and your first formula
Copying a formula down
Locking a cell with $
Basics
Add up a column
Find the average
Find the biggest value
Count the rows
Multiply two cells
Round a result
Make a decision
Combine two conditions
Percent of a total
Scenario ·
A monthly household budget
Review: Basics
Conditions
Count matching rows
Pro
Sum matching rows
Pro
Average matching rows
Pro
Count with two conditions
Pro
Sum with two conditions
Pro
Biggest value that matches
Pro
Several outcomes
Pro
Catch errors
Pro
Scenario ·
A small shop’s sales by rep and region
Pro
Review: Conditions
Pro
Lookups
Look up a value
Pro
Look up the modern way
Pro
Handle a missing match
Pro
Look up in any direction
Pro
Find a position
Pro
Scenario ·
Build an invoice from a price list
Pro
Review: Lookups
Pro
Text
Remove extra spaces
Pro
Fix capitalisation
Pro
Take the first characters
Pro
Take characters from the middle
Pro
Count characters
Pro
Join text together
Pro
Replace text
Pro
Split text into columns
Pro
Test for a pattern
Pro
Pull out a pattern
Pro
Join a whole column
Pro
Scenario ·
Clean a contact list for a mail merge
Pro
Review: Text
Pro
Dates
Days between two dates
Pro
Get the month
Pro
Count working days
Pro
Days since a date
Pro
End of the month
Pro
Scenario ·
A clinic’s appointment book
Pro
Review: Dates
Pro
Arrays
List distinct values
Pro
Count distinct values
Pro
Keep only matching rows
Pro
Sort a table
Pro
One formula for a whole column
Pro
Scenario ·
Tidy an event sign-up list
Pro
Review: Arrays
Pro
Projects
Rental property cash flow
Pro
Hospital ward: beds and stays
Pro
Café stock: what to reorder
Pro
Freelancer invoices: who owes what
Pro
A quarterly sales report
Pro
Lesson
1. What a cell is
2. Moving with the keyboard
3. Rows, columns and ranges
4. Jumping to the edge of the data
5. Selecting rows, columns and everything
6. Typing values and your first formula
7. Copying a formula down
8. Locking a cell with $
9. Add up a column
10. Find the average
11. Find the biggest value
12. Count the rows
13. Multiply two cells
14. Round a result
15. Make a decision
16. Combine two conditions
17. Percent of a total
18. A monthly household budget
Review: Basics
19. Count matching rows (Pro)
20. Sum matching rows (Pro)
21. Average matching rows (Pro)
22. Count with two conditions (Pro)
23. Sum with two conditions (Pro)
24. Biggest value that matches (Pro)
25. Several outcomes (Pro)
26. Catch errors (Pro)
27. A small shop’s sales by rep and region (Pro)
Review: Conditions
28. Look up a value (Pro)
29. Look up the modern way (Pro)
30. Handle a missing match (Pro)
31. Look up in any direction (Pro)
32. Find a position (Pro)
33. Build an invoice from a price list (Pro)
Review: Lookups
34. Remove extra spaces (Pro)
35. Fix capitalisation (Pro)
36. Take the first characters (Pro)
37. Take characters from the middle (Pro)
38. Count characters (Pro)
39. Join text together (Pro)
40. Replace text (Pro)
41. Split text into columns (Pro)
42. Test for a pattern (Pro)
43. Pull out a pattern (Pro)
44. Join a whole column (Pro)
45. Clean a contact list for a mail merge (Pro)
Review: Text
46. Days between two dates (Pro)
47. Get the month (Pro)
48. Count working days (Pro)
49. Days since a date (Pro)
50. End of the month (Pro)
51. A clinic’s appointment book (Pro)
Review: Dates
52. List distinct values (Pro)
53. Count distinct values (Pro)
54. Keep only matching rows (Pro)
55. Sort a table (Pro)
56. One formula for a whole column (Pro)
57. Tidy an event sign-up list (Pro)
Review: Arrays
58. Rental property cash flow (Pro)
59. Hospital ward: beds and stays (Pro)
60. Café stock: what to reorder (Pro)
61. Freelancer invoices: who owes what (Pro)
62. A quarterly sales report (Pro)
Basics
·
Section review
Free
Review: Basics
Four mixed problems from this section. The function isn’t named, so you choose it.
Loading…