What the research shows
None of these studies tested Excel training directly, so treat them as evidence about how people learn in general, not as a verdict on any particular course.
Watching feels like learning. Doing is learning.
Video tutorials are a fine way to see a technique once. What makes it stick is doing it yourself, getting it wrong, and finding out why. Here's what the research says, and how we built the lessons around it.
| Finding | Key number | Context | Source |
|---|---|---|---|
| Practice testing beats rereading | 61% vs 40% recalled after one week | Students learning prose passages | Roediger & Karpicke, 2006 |
| Retrieval beats concept mapping | 0.67 vs 0.45 on a test a week later | 80 college students, science text | Karpicke & Blunt, 2011 |
| Active learning beats lecture | Failure rate 21.8% vs 33.8% | 225 studies of college STEM courses | Freeman et al., 2014 |
| Doing feels harder but teaches more | Active students learned more yet felt they learned less | Harvard intro physics, 149 students | Deslauriers et al., 2019 |
| Viewers drift off | Median watch time tops out near 6 minutes | 6.9 million edX video sessions (watch time, not learning) | Guo, Kim & Rubin, 2014 |
| Feedback that explains works | Effect size 0.49 vs 0.05 for right/wrong only | 40 studies of computer-based learning | Van der Kleij et al., 2015 |
| Show an example, then fade it | Recommended sequence for beginners | IES practice guide | Pashler et al., 2007 |
Why video alone falls short for formulas
A tutorial shows a formula working on the presenter's data. You nod along, because following a solution is much easier than producing one. That ease is the trap: it feels like progress, and the Harvard physics study found students consistently mistake that feeling for learning.
Formulas also fail in ways a video can't show you: a reference that should have been locked with $, a lookup that breaks when a value is missing, a total that only works on today's numbers. You find those by writing the formula and watching it break.
The question isn't whether you understood the video. It's whether you can write the formula on a blank sheet tomorrow.
How each lesson works
- Watch it done once. A short walkthrough types the formula keystroke by keystroke on sample data. Worked examples help beginners most at the start.
- Do it on a fresh sheet. The exercises use different data, so you can't copy the walkthrough.
- Get graded twice. Your answer is checked, then re-run on changed numbers. A typed-in result fails.
- Find out why. Feedback names the cell and the mistake, and the tutor explains without handing over the answer.
When video is the right tool
For a tour of an interface you've never seen, like the ribbon or a pivot table dialog, a video is quicker than reading. Watch it, then come back and practice the formulas.