Here’s a collection of resources for you: a strange mix of advanced, esoteric and inspirational spreadsheet uses, showing how far some (mad)men and women push their spreadsheets. The list gets more light-hearted towards the bottom of the post!
Somehow I doubt Dan Bricklin would have envisioned all this when he invented the spreadsheet…
Functional programming in Excel from Felienne Hermans all about her research into treating Excel as programming language. Well worth a watch.
Let’s start with keyboard shortcuts. It’s one of the single best investments of time you can make to further your spreadsheet skills. It’s all about reducing your reliance on the mouse and instead harnessing the awesome efficiency of navigating spreadsheets from the keyboard.
Who doesn’t love a dynamic, animated Excel dashboard?
Here’s one I’ve been working on recently, a data visualization of historical U.S. political data, showing party trends, state populations and sitting presidents over time:
In the following post, I delve into the details of how I created this dashboard. It’s not a full cell-by-cell account of how I did it, because that would require an article at least twice as long, but rather a look at the various steps and thought processes along the way.
If it appears a little ragged, that’s because it probably is! Most likely because I’m writing this bleary eyed at 1am, between feeds and diaper changes of my 6 week old son. 😉