Explain a spreadsheet calculation on screen
A useful spreadsheet explanation connects the inputs, formula and result, then shows one check. A recording demonstrates a calculation; it does not prove the calculation is right.
Start with a sample copy
Make a copy of the workbook and replace real names, amounts and other sensitive fields with invented values that keep the same structure. Remove sensitive sheets from the sample copy; hiding a sheet is not redaction if you also share the workbook. Hide only nonsensitive sheets you will not discuss, and check other tabs at the bottom of the window, because tab names can reveal more than you expect. On a Mac, Reel records the whole display, so close the original file entirely.
Make the formula visible
Selecting a cell shows its formula in the formula bar, but that bar is easy to miss. Say “look at the bar above the grid” the first time. For supported Excel versions, Microsoft documents Formulas > Show Formulas to switch the sheet between formulas and results; switching back and forth on camera shows both clearly.
In Numbers on Mac, typing an equals sign opens the Formula Editor, and Apple’s guide describes instant calculations: select a range and the sum, average, minimum and maximum appear at the bottom of the window. That gives you another calculation to compare without writing a formula; verify the selected range and work a sample by hand too, because both totals can use the same wrong inputs.
Follow inputs, formula, result, check
- Point to the input cells and say what each one represents.
- Select the formula cell and read the formula, naming each referenced cell.
- Show the result.
- Check it: work one row by hand, or select the column and compare the instant calculation with your total.
- Change one input and show the result update, if that is part of what viewers need to understand.
Worked example: discounted price
Column B holds list prices and column C holds discount rates. D2 contains =B2*(1-C2). Select D2 and read it: “list price times one minus the discount”. For row 2, B2 is 80 and C2 is 0.25, so D2 shows 60. Check aloud: a quarter of 80 is 20, and 80 minus 20 is 60. Then select D2 to D10 and compare the sum shown at the bottom of the window in Numbers, or the status bar in Excel, with the total cell.
If the check fails, say so and fix the formula on camera, or stop and re-record. Do not publish an explanation of a formula you have not verified.
Readability
Zoom the sheet so the cells you discuss fill most of the window, and hide unrelated columns. Use a highlight colour on the inputs and the result while explaining, then remove it if the file will be shared. On iPad, the same approach works in Numbers, with Reel recording the full iPad screen and your voice.
Limits
A recording captures one moment of one file. If the workbook is later edited, the video can become wrong without anyone noticing. Note the file name and date at the start, and keep the sample copy with the video so a reviewer can open the same cells.
Does recording a calculation prove it is correct?
No. It shows what the sheet did. Include an independent check, such as a hand calculation for one row.
Can I record the real workbook and blur numbers later?
You can, but every frame must be checked, and scrolling can expose cells you did not plan to blur. A sample copy is safer.
