Excel is the omnipresent tool to work with data in the world, and it is loved and hated because of this. In this post you will find some useful links, some horror stories and some fun with excel. I strongly believe that you can save yourself a lot of time if you increase your Excel skills!
Useful Resources:
You can obviously find a ton of resources about everything imaginable around Excel. Some of my favourites:
- Excel is fun: A Youtube channel with over 3.000 videos that teach you specific parts of Excel, from basics to very advanced. With well over 500K subscribers this is a very big channel.
- Excelexposure: An Excel online course with video’s and a workbook to do exercises in. The start already feels welcoming:
Excelexposure
Welcome to Excel Exposure!
Congratulations on deciding to improve your Excel skills!
Sometimes the hardest part is getting started, so you’re already doing a great job!
The goal of Excel Exposure is to expose the world to the amazing functionality of Microsoft Excel. This site is an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, and most importantly, save time!
- Stephanie Evergreens site: Stephanie has a great set of how-to articles to create some nice visualisations in Excel that go beyond the regular bar and line charts that are really easy to follow.
- Filtered ten most useful Excel tips: Ten awesome features explained, and a list of the top 100 most useful excel functions that you can download
Horror Stories and mistakes:
Of course, stuff can also go very wrong. If you need an extra incentive to get started with the resources mentioned above, then definitely read about the 5 greatest spreadsheet errors of all time. Also helpful is this article about 10 common spreadsheets mistakes
And to end up with some fun:
- Some people love excel so much they even create a video clip about it, watch this great clip from Clint Tuttle
- While others like Tatsuo Horiuchi use Excel to create art:
- Or have a look at this tool from the awesome Matt Parker (the standup mathematician) where you can convert a photo into an excel spreadsheet!
- Or are you more into games in excel?