> yet most people are capable of creating spreadsheets (and writing formulas)

Not in my experience.