
Use Paste Special to Separate a Spreadsheet Result from Its Formula
Compare a copied formula with pasted values in a tiny spreadsheet, then check what happens when the source cells change.
Small, practical ways to turn an online lesson into something you can use.

Compare a copied formula with pasted values in a tiny spreadsheet, then check what happens when the source cells change.

Two files can look almost identical while only one meets the task. Showing a correct example beside a carefully chosen near-miss can help a learner notice…

Following a tutorial with every instruction visible can feel smooth. A short rebuild from a blank file asks a different question: which decisions can you…

An assignment may limit the introduction rather than the whole document. Checking only the total word count can make a section seem longer or shorter than…

A familiar shortcut can behave differently when focus moves from a document into a search box, sidebar, or another application. The keys are only part of…

When two people learn a tool together, the more confident person can end up doing every action. Alternating the operator and observer roles gives both…

Pressing Enter repeatedly can push a heading onto the next page, but the arrangement may shift when earlier text changes. A page break expresses the…

“Practise using the spreadsheet” is too broad to tell a beginner when the exercise has worked. A small task with an expected result makes practice easier to…

A red cell can draw attention to an overdue item or an unusual number. Before acting on the colour, inspect the rule behind it and the value the cell…