FreeJobToolsFree spreadsheet practice for work
FreeJobTools is a free spreadsheet trainer for people who want practical office skills. Each lesson starts with a guided example that tells you which cell to select and what to type, then gives you a fresh set of data so you can do the same task on your own. Everything runs in your browser. There is no account to create, nothing to install, and nothing to pay.
What a lesson looks like
| A · Revenue | B · Cost | C · Profit | D · Margin | |
|---|---|---|---|---|
| 2 | 500 | 300 | 200 | — |
| 3 | 800 | 480 | — | — |
| 4 |
Select cell C2 to calculate the dollar profit for Product A: revenue in A2 minus cost in B2, written as =A2-B2.
Written for adults starting from zero
Anyone who has opened a spreadsheet and not known where to click. If you already use spreadsheets, the later lessons on lookups, sorting, and summaries are a quick way to check what you know.
Job search
Job seekers
You see “Excel skills” on a job posting and want hands-on practice with the tasks employers mean: totals, lookups, sorting, and summaries.
Back to work
People returning to work
After time away, start again with the basics at your own pace. There is no time limit, and repeating a lesson is fine.
Own records
Small business owners
Keep your own records: invoices with tax, profit and margin, budgets, and counts of orders that still need attention.
See it done once, then do it yourself
Learn with me
The trainer walks you through a worked example one step at a time. It shows which cell to click, which formula to type, and why that formula gives the right answer. When a step is correct, the lesson moves on by itself. If you get stuck, open “Help with this step” for a hint.
Your turn
When the example is finished, practice starts automatically with new numbers. This time the task is described in plain words, the way a supervisor might ask for it, and you work out the formulas yourself. You can go back and review the example at any time without losing your practice answers.
15 lessons, from first formula to pivot table
Totals, averages & text
Add sales with SUM, find an average, clean up text with UPPER and LEN, and join first and last names.
Margins, budgets & IF
Work out profit and margin, find the largest and smallest expenses, and mark results Pass or Fail with IF.
Invoices, counts & lookups
Build an invoice, apply a fixed tax rate, count order statuses, total spend by department, look up prices, and handle empty periods.
Sorting & pivot tables
Sort a list from highest to lowest without mixing up rows, then summarize sales by region and department.
The formulas work the same way in Microsoft Excel and Google Sheets. Your points and progress are saved on your own device, so you can stop and come back later.
Beginner guides with worked examples
Spreadsheet basics for beginners
Cells, rows, columns, Enter, and your first spreadsheet formula, with a short practice task.
Add a column of sales with SUM
A worked example, step-by-step instructions, common mistakes, and answers to first-time questions.
Find an average
Find a typical score, sale, or daily count, understand blanks versus zeros, and round the result.
Calculate an invoice with tax
Line totals, a subtotal with SUM, a fixed tax rate with dollar signs, and the amount due.
Count order statuses with COUNTIF
Count Pending, Shipped, and Cancelled orders, and total spending by department with SUMIF.
Look up a price with XLOOKUP
Find a price from a code, show a clear message when a code is missing, and fix #N/A errors.
Sort a list without mixing up rows
Keep each name with its own numbers. Covers header rows, sorting by two columns, and common mistakes.
Formulas used at work
SUM, AVERAGE, IF, COUNTIF, text cleanup, profit and margin, and what to check when a formula is wrong.
Finish all 15 lessons and print your certificate
Your points add up as you complete lessons. When all 15 are done, the certificate unlocks. Add your name and print it, or save it as a PDF.
- Free, with no fee to unlock it
- No account needed
- Shows the skills you practiced
Start with the first lesson
Open the free spreadsheet trainer and start with “Quarterly Sales Total.” No account, nothing to install.