Today's post is going to be different. While we usually walk through SeoTools functions or explain SEO concepts, I received an interesting question the other day.
What's the coolest Excel hack you've seen?
While technically not a hack, the easy way out would've been to reply with a SeoTools pitch - instead I asked for some time to mull it over and here's my answer.
John Nelson at IDV Solutions walks us through how he uses an Excel hack to make geographic cell maps.
While pivoting data in Excel, it occurred to me that I could drag the latitude data into the row and the longitude data into the column. The result would be a 1980's-Nintendo-looking chunky cell map (which, if I make the cells square, happens to be a pseudo-equirectangular projection). Low and behold.
It's essentially four quick steps: Round latitude and longitude coordinates, bin them with a pivot table, reverse the order of said table, and color with conditions. You've got a rough overview map in a couple of minutes.
Do yourself a favor and catch the post in its entirety here.