As a video sharing site unleashed to the entire world, the creators of Youtube must have realised that there was going to be a proliferation of randomness uploaded onto it – it certainly is a source of endless procrastination for the modern student! Nevertheless, Youtube has become an excellent learning resource as people who really know what they are talking about have shared their tips and advice online…and a video is much easier and user-friendly than reading a lot of text, particularly on software related issues where seeing it in practice is the best way to learn. So on the topic of Excel skill improvement, Youtube couldn’t be better!
1) https://www.youtube.com/user/ExcelIsFun/videos With an incredible 2000 videos here, ExcelIsFun has to be the definitive Youtube guide to Excel. If you don’t find the skill you are looking to learn/improve here, it probably doesn’t exist. Downloadable workbooks are also offered which will be helpful for the learning process. Mike Girvin often collaborates with Bill ‘Mr. Excel’ Jelen on these videos for joint commentaries. Some of the videos are up to 40 minutes long but the functions explained are complicated and are shown from scratch so should be easy to follow.
2) https://www.youtube.com/user/Subjectmoney/playlists The Youtube channel for the excellent www.excelfornoobs.com. As the title suggests, this is to teach the basics to total beginners covering functions, tables and formulas in hundreds of videos including a shorter ‘crash course’ series. Highly recommended for the initial covering ground to then move onto ExcelIsFun.
3) https://www.youtube.com/user/TheExcelKid?feature=watch The Excel Kid here says he doesn’t want to cover all the old ground that ExcelIsFun and Mr. Excel have done so focuses on KPI dashboards and reporting. This is more specialist knowledge that will be useful for analysts so definitely a must watch after you’re comfortable with the basics.
4) https://www.youtube.com/user/ExcelVbaIsFun In the same vein, this channel offers specialist videos on VBA (Visual Basic for Applications – the language for setting up macros). Includes downloadable workbooks on dropbox.
5) https://www.youtube.com/playlist?list=PLpQQipWcxwt_7KKPzPuw0Re86-WeWe9Gc This is a very good channel for all Microsoft software. So all the know-how for Word, Outlook, Powerpoint and Publisher can also be found on this channel.
6) https://www.youtube.com/user/ExcelTutorials/videos?view=0&shelf_id=1&sort=dd The Youtube channel for the well-known online course website www.chandoo.org For step by step articles to go with these videos, go to the website.
7) https://www.youtube.com/user/contextures Excellent set of videos from the excellent website http://www.contextures.com/tiptech.html which has a great array of articles and blog posts on Excel. The videos are grouped into ‘Functions’, ‘Data Validation’ and ‘Programming’
8) https://www.youtube.com/user/bjele123/videos Bill Jelen’s own channel with some of his top rated videos from www.mrexcel.com (but check out the website for more content, including CD-ROMS to order). Consists of a commentary as he uses Excel to achieve certain outcomes.
9) https://www.youtube.com/channel/UCdG1GHxF95MUruRtFLqq0MQ High ratings for their 11 beginner’s lessons which include conditional formatting and charts
10) https://www.youtube.com/user/ImproveYourExcel/videos Seven of the top videos from www.improveyourexcel.com have been uploaded to youtube here but check out the website for 60 further video tutorials