Bill MacKenty

Don’t use excel for important work

Computer Science professor Daniel Lemire talks about why folks shouldn't use excel for important work.

Lemire states, "They [spreadsheets] are at their best when errors are of little consequence or when problems are simple.". He also writes (and I agree) "Spreadsheets make code review difficult. The code is hidden away in dozens if not hundreds of little cells… If you are not reviewing your code carefully… and if you make it difficult for others to review it, how do expect it to be reliable". When I get a spreadsheet from my business office, I spend more time understanding the formulas than I do the business problem.

I agree with Prof. Lemire's points, but I also see a language problem in changing. In short: people use spreadsheets because they are easy and accessible AND they lack computational thinking skills to build (write) a program in a more organized, coherent way. Probably, people "know" excel and there is a cost to learning and mastering something new.

In schools, I see excel spreadsheets being used to run virtually all parts of an organization (HR, accounting, purchasing, etc..). I think people use spreadsheets because they are easy and well supported, AND they do not know how to program.

I think Prof. Lemire's point is well said, and his post moves me to do more to help kids learn about programming and computational thinking.