About this guide
A course description can tell you what it teaches. One small project can tell you which part you would choose to do again. Try a no-cost inventory exercise, check your own work and decide what would be worth paying to learn.
In this guide
A friend asks you to help at a neighborhood food drive on Saturday. Three boxes arrive. The delivery slip says there should be twelve cans of beans, but you can only find ten. Another volunteer will take over in twenty minutes. What would you leave on the table so they know exactly what to do?
That is enough material for a first lesson in spreadsheets and inventory. You can do it with a pencil, a few things from your kitchen and invented numbers. Nothing needs to be bought or donated. Checking a delivery against a record and noting differences are tasks O*NET lists for shipping and receiving clerks. Here is a small version you can try at home.
Build a handoff sheet on Saturday
On paper or in a spreadsheet you already have access to, give each item a row. Use these practice quantities, or make up three of your own. Put a single unit at the top of each row. Twelve cans and twelve cases are very different deliveries.
| Item | Expected | Counted | Difference |
|---|---|---|---|
Cans of beans | 12 | 10 | -2 |
Bags of rice | 6 | 6 | 0 |
Packs of pasta | 8 | 9 | +1 |
Subtract expected from counted. If your headings are in row 1 and the quantities are in columns B and C, enter =C2-B2 in D2. Copy the formula down and check one row by hand. On paper, do the subtraction and have someone read a row back to you. The interesting question is the same either way: can the next volunteer tell what needs attention?
Write one handoff note in your own words. “Beans are two cans short. I checked both boxes. Please confirm the quantity with the person who packed them.” Resist the urge to tidy the numbers until everything matches. The mismatch is the part worth communicating.
On Sunday, see what happens when the count changes
Suppose someone finds two cans of beans in the pasta box. Change the bean count to twelve. Did the difference return to zero? Does your handoff still ask the next person to investigate a shortage that has been resolved? Update the note. If someone nearby can spare a minute, give them the sheet and ask which item they would check next. See what they can figure out before you explain it.
You can split the exercise across two short breaks. If entering figures on a phone is awkward, finish the paper version first. Later you can try the formula on a larger screen and compare the two. The work you did on paper still tells you something about how you think.
Pay attention to the part you want to repeat
Maybe you liked tracking down the missing cans but found arranging the columns tedious. Try a second receiving problem with a packing slip. Maybe the satisfying moment came when the formula fixed itself. Try a free lesson on cell references, then change the quantities again. Or perhaps the best part was writing the note that made the next shift easier. Try writing instructions for another everyday task and asking someone to follow them.
If you save the sheet as a work sample, write “independent practice project using fictional data” at the top. You can describe what you built and checked without implying you managed inventory for an employer. The guide to showing the work behind your résumé can help you find the right wording.
Make a decision before entering a card number
Finish this sentence: “I would pay for help learning how to ___.” An answer like “make the total change automatically when a delivery changes” gives you a lesson to look for. Compare the course outline with that exact task. Look at the full cost, any software it assumes you own and whether someone will give you feedback on your work.
If you liked the work itself, follow a shipment through receiving, planning and purchasing to see where the skill could lead. If the task left you cold, keep the sheet anyway. For the cost of a little time, you have learned which question to ask before spending money.
Sources
Sources reviewed 2026-11-20. Editorial policy