Free lessons
Excel and Google Sheets each have 5 free lessons, and Touch typing is free from start to finish. You don't need an account, and there's nothing to install. Lessons run in your browser on a laptop or desktop.
Do the free lessons on your computer.
They run in your browser on a laptop or desktop, and every step is checked as you go. Free, with no sign-up.
On your computer, go tolearnford.com/free-lessons
Beginner · 7 min
Why your formula broke when you copied it
Lock a cell with $ so a formula keeps working when you copy it down.
Start the lessonConfident · 9 min
Remove duplicates
Delete repeated rows from a merged list, and choose which columns decide what counts as a duplicate.
Start the lessonConfident · 7 min
Make a dropdown list
Give a column a dropdown of fixed choices, pick from it, and stop anything else from being typed.
Start the lessonConfident · 10 min
Your first pivot table
Turn 200 rows of sales into totals by region, read the answer, and re-ask the question by rep or product.
Start the lessonConfident · 11 min
Look up a price with VLOOKUP and XLOOKUP
Bring each order's price over from a price list with VLOOKUP or XLOOKUP, and avoid the missing-FALSE trap.
Start the lesson
Beginner · 7 min
Why your formula broke when you copied it
Lock a cell with $ so a formula keeps working when you copy it down.
Start the lessonConfident · 9 min
Remove duplicates
Delete repeated rows from a merged list, and choose which columns decide what counts as a duplicate.
Start the lessonConfident · 7 min
Make a dropdown list
Give a column a dropdown of fixed choices, pick from it, and stop anything else from being typed.
Start the lessonConfident · 10 min
Your first pivot table
Turn 200 rows of sales into totals by region, read the answer, and re-ask the question by rep or product.
Start the lessonConfident · 11 min
Look up a price with VLOOKUP and XLOOKUP
Bring each order's price over from a price list with VLOOKUP or XLOOKUP, and avoid the missing-FALSE trap.
Start the lesson
Touch typing
The whole Touch typing course is free: every lesson, and Practice after them.
Beginner · 10 min
Before you start: F, J and the space bar
Sit well, find the home row by touch and type F, J and space without looking.
Start the lessonBeginner · 8 min
D and K
Type D and K with your middle fingers without looking, together with F, J and space.
Start the lessonBeginner · 9 min
S and L
Type S and L with your ring fingers without looking, together with D, K, F and J.
Start the lessonAlso in development: SQL, Python, coding and chess. See all courses
After the free lessons
Each course has more lessons in its Roadmap, with Skills, paths and a cheat sheet for every lesson you finish.