ArcGIS and Excel are Worthwhile

Posted to The Times  |  Nathan Yau

If I've learned anything in my first month at The Times, it's that ArcGIS and Microsoft Excel are not worthless.

For a while now, since I started grad school, I had this beef against Microsoft Excel. I hated how everyone used it and how I didn't have the money to buy the Office suite or even cared enough to want to buy it. It seemed so limited in what it could do compared to a quickly setup MySQL database.

Then last year, I took this crash course on ArcGIS. It was four days, eight hours a day of mapping. I hated ArcGIS after that workshop. The whole software suite seemed sluggish, bloated, and so not worth my time.

Today I saw some ArcGIS and Excel proficiency I had never seen before. My co-worker flew through giant spreadsheets, punched in formulas, and joined columns left and right. It was quite the scene. Once the data were prepared in Excel, she shot it over to ArcGIS. She quickly loaded a shape file for all counties in the Tri-state region, changed some limits, and voila, a few seconds later we had the map we needed. Put in some labeling, some numbers, and the graphic was complete.

Yes, ArcGIS and Excel are worthwhile.

I have so much to learn.

Growing Minority Populations



Pizza Place Geography

Most of the major pizza chains are within a 5-mile radius of where I live, so I have my pick, …

How We Spend Our Money, a Breakdown

We know spending changes when you have more money. Here’s by how much.

Real Chart Rules to Follow

There are rules—usually for specific chart types meant to be read in a specific way—that you shouldn’t break. When they are, everyone loses. This is that small handful.

Most popular porn searches, by state

We’ve seen that we can learn from what people search for, through the eyes of Google suggestions: state stereotypes, national …