Sometimes the best way to learn and understand something is to see an example being performed in front of you. That is why videos are such a powerful tool for learning something new. That is why we suggest that you head to YouTube and search to find videos demonstrating Excel functions that you might not necessarily understand completely. The chances that you will find what you are looking for are pretty good. You can also use YouTube to discover the underbelly of Excel and uncover tricks and hacks that might not even be taught in official Excel books and tutorials.
These are the best YouTube channels for learning about Excel:
This is a newer channel where you can find more than 190 Excel tutorials. Most of the videos are not basic but contain lots of interesting implementations of advanced Excel features.
This channel contains both basic and advanced tutorials, but most of them are just for Excel 2007.
This channel is regularly updated and contains tutorials that are explained in very simple terms for users that are just starting out with any version of Excel.
Here is a very comprehensive collection of Excel video tutorials for both beginners and the advance.
You can find a large collection of Excel tricks and hacks at this channel.
Blogs and Websites for learning Excel
If you have a specific problem with Excel, you can post questions on the official Microsoft Excel forum. However, if you want to learn new stuff for free, the best way to do it is to follow blogs.
Blogs provide a great way for learning about Excel because they are updated regularly and allow readers and authors to interact better than static websites. Here is a list of some of the best blogs for learning Excel. Some of them are for advanced users, so don’t get discouraged if you don’t understand a thing. Dig deeper to find more basic articles and tips. There is useful information for everyone.
The Chandoo website contains lots of tutorials for learning Excel. There are tutorials for both beginners and advanced users. Also, there is a forum where users can ask and answer Excel related questions.
This website is a great resource for everyone learning Excel. In the tips section, you can find tips about almost any aspect of Excel. There is also a section with useful templates and an interesting blog which is regularly updated with new features and tutorials.
3. Bacon Bits
At this blog, you can find really good tutorials, but most of them will probably be more suitable for advanced users.
This blog is regularly updated and suitable for users of all levels.
When you get to this website, at first you might be confused because of you are seeing many different sections, but once you spend some time here, you will be able to navigate easily through the many tutorials and tips that the blog has to offer.
As the name says, this websites shows us some unusual implementations for Excel, like in gaming, for example.
This website is pretty comprehensive. It offers a variety of simply explained tutorials and templates.
8. Excel Charts
This blog talks about Excel from the aspect of data visualization.
Useful tips for advanced Excel students are offered here.
This blog has Excel tips offered directly by the Microsoft Team. This site is designed with beginners in mind for the most part.
MrExcel is probably one of the most comprehensive resources for learning Excel on the web.
This Excel blog is specially designed for engineers and scientists or students of both engineering and science.
13. Peltier Tech
Here is an exceptionally detailed blog with tons of resources for all types of Excel users, from beginners to programmers.
14. Spreadsheet Page
Spreadsheet Page offers a large numbers of tips and good advice for Excel users, as well as numerous other resources and free add-ons.
There are plenty of freebies for Excel earners at this blog, such as add-ons, templates, training, macros and much more.
16. Pearson Excel
As you can see, there are plenty of tutorials for Excel formulas, tables and more here.
17. Excel Exposure
Excel Exposure is part of the class curriculum taught at Reddit University, so you know it has a lot of excellent tips and tutorials.
18. Excel Theatre
This website is not actually a tutorial blog, but it offers a collection of the most interesting tweets on the topic of Excel. If you are having a hard time learning complicated formulas and tables, this website will certainly make you feel better, because you’ll realize that you are not alone.
Since Reddit is full of helpful people, you can join their subreddit for the discussion of Excel problems.
Finally, this website offers lot of free templates which can be of a great help.