Like the person at work who — even after having been taught about 200 times — still "doesn't know" how to use spreadsheets.

Hahaha... with this example you expressed it very rightly. That's usually a problem, especially with new technology. I think at some point some people even identify with that ignorance. It's very annoying for me too. But I have learned to notice when someone does not have the will to learn. That's the point, I think.