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.
Enter your email below to join over our community of over 12,000 data analysts and Google Sheets aficionados and get:
The Monday Tips email – a weekly, actionable Google Sheets tip. 👍
A copy of my free, 79-page ebook, Spice Up Your Sheet Life, packed with 35 interesting tips and tricks for Microsoft Excel and Google Sheets. 👍
Exclusive content not found anywhere else. 👍
The best deals on future training courses! 👍
Free updates to any free templates. 👍
Spice Up Your Sheet Life ebook
This book contains 35 detailed case studies, covering practical and esoteric, easy and difficult, short and long, Excel and Google Sheet tricks and techniques. My hope is that you’ll find some magic in these pages, to inspire you or show you new ways to use spreadsheets you didn’t know were possible.
For example, did you know you can build a language translation tool in a Google sheet? Or create a chart of stock prices in under 30 seconds? All possible and covered in these pages!
What about other weird tricks like looking up leftwards with VLOOKUP? Or lookups with multiple criteria? Writing SQL code in your spreadsheets? Check, check and check. All possible and covered in this book.
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. 😉