Do economics majors need to learn Excel?

My first job after finishing my undergraduate degree in economics involved using Lotus 1-2-3 – the first "killer app" spreadsheet program – to create graphs. I'd never been taught to use a spreadsheet, but I worked it out.

Fast forward a couple of decades. Spreadsheets are ubiquitious in the workplace. When a new research assistant joins the Bank of Canada, their first job – like mine – is crunching data with a spreadsheet. Yet, at some universities, it is possible to graduate with an economics degree and never learn how to use Excel.


I'm deeply cynical about the usefulness of training. Having wasted hours mastering Wordperfect and other obsolete programs, I know that specific human capital depreciates rapidly, and is often a poor investment.

Yet spreadsheets are used in so many applications that it is worth getting some basic knowledge of how they work. Spreadsheets, moreover, provide a crucial conceptual basis for linear algebra and econometrics. A matrix is basically a spreadsheet, a vector is basically a column, an observation is a row. Understanding data in the abstract is difficult, picturing it as a spreadsheet is far more straightforward.

So why aren't our students learning how to use spreadsheets?

Spreadsheets seem to be surrounded by a Someone Else's Problem field. High school teachers figure students will learn to use them in university; university professors assume students must have been taught to how use spreadsheets in high school. Theorists and people who teach field courses leave spreadsheet instruction to the business stats instructors – and business statistics profs sometimes do provide spreadsheet tutelage, especially those teaching in business schools. But not every student takes a spreadsheet oriented business stats course.

I don't think that economics degrees should be just like business degrees – I like the fact that economics has strong theoretical underpinnings, that conceptual understanding and rigor is emphasized. Yet at the same time, don't we have a responsibility to ensure that our students graduate with some basic office skills?

51 comments

  1. Alex Plante's avatar
    Alex Plante · · Reply

    Definitely yes. I’m an engineer, and you’d be surprised how many engineering calculations are performed using Excel. I learned fist Lotus 123 then Excel “sur le tas” as we say in French, and finally took a night course in Excel. Many of my colleagues made fun of me, as if I were taking a course in basket weaving, but it was actually one of the most useful courses I’ve ever taken.

Leave a comment