Websites

OK, so ExcelWhizz.com is obviously the best dedicated Microsoft Excel website out there, but there are some other decent ones too. Here’s the best of the rest:

 

Mr Excel
Simply the best! Bill Jelen is a terrific Excel author, a veteran of over 40 (yes, FORTY) Excel-related books. There is loads covered on his website but by far the most valuable section is his forum. Full of some of the best Excel brains in the world happy to help solve your problems (albeit with a little sarcastic humour from time to time), the chances are your question has been asked and answered before so it’s worth searching first. As we speak, there are 859,251 threads in the Excel Questions forum alone, and over 4 million posts. If you can’t find an answer to your query, this is the best place on the Internet to ask for one!

 

Chandoo
A brilliant blog written by a genius Excel brain. Chandoo also produces a regular Excel podcast (50+ episodes) and is a real expert on dashboard reports and charting.

 

Contextures
Debra Dalgleish’s site has some fantastic tips. Most of which are aimed at the more advanced user, but explained in a simple manor that most can follow. A great resource for charts and data visualisation and lots of solutions for manipulating Excel to do what you want it to do.

 

Excel Itch
Lee’s wonderful website provides comprehensive Excel tutorials, explaining the key components of Excel in a clear and detailed way. Aimed primarily at the beginner or intermediate Excel user, this website is an excellent resource to help transform yourself from ‘regular user of Excel’ to ‘the go-to guy in the office’ for Excel. Very active and popular on social media with a big Twitter following @ExcelItch Lee also produces YouTube tutorials.

 

Daily Dose of Excel

One of the best Excel blogs online, a number of different authors contribute to this. Tailored for advanced Excel users, the articles often feature VBA script. Worth checking on a regular basis to find new material relevant to your work, or just for a bit of inspiration.

 

Mike Girvin’s Excel Is Fun YouTube channel

This guy is absolutely prolific, with over 2500 videos on his YouTube channel at the last count. If there’s anything you want to do in Excel, you can bet he will have covered it at some point. His style is easy to follow and clear, he doesn’t miss any steps but at the same time it isn’t too slow-paced. As great as all the books are, Mike’s YouTube site is probably the most effective, cheapest and definitely the quickest way to learn how to do something in Excel.

 

Option Explicit VBA

Jordan Goldmeier is another top Excel author. His books are very easy to follow and he often challenges the conventional methods of doing things in Excel coming up with alternatives that are in many cases far more simple to use. In amongst his blog you will find some really whizzy coding and some fantastic ways of visualising data.

 

Spreadsheet Guru

Chris ‘Macro’ Newman’s site is focused on how to make you a more productive analyst. Another newsletter worth signing up to, and blog worth keeping an eye on.

 

Power Pivot Pro

A great website to help familiarise yourself with the (relatively) new Power BI functions of Excel – Power Pivot, Power Query, Power Maps, etc.

 

Excel University blog

Specialised content and training tailored for accounting professionals to help them make sure they are using Excel in the most efficient and effective way. This site should be a regular ‘go to’ for all accountants!

 

Datascopic by Oz du Soleil

Oz is a really likeable and personable character and gets his points across in a fun and down-to-earth manner. He is a master of data cleansing and there are plenty of interesting blog posts and videos found within this site.

 

Excel Champs

This site offers Excel training and has a very lively blog attached to it. Lookout for some fantastic free-to-download template files too.

 

Excel.TV video tutorials

Starring a selection of Excel gurus including Oz du Soleil and Jordan Goldmeier, this site posts some great video tutorials and also TV-style Excel debates with some of the Excel greats from around the world.

 

Excel Hero

Dan Ferry’s Excel Hero blog is full of great content although it hasn’t been updated for a good while now. The site also includes Dan’s Excel Hero Academy training course which has received some rave reviews.

 

Excel Campus

Jon Acampora’s website features a regularly-updated blog with a keen focus on VBA and a number of Excel add-ins that Jon has developed. The site also offers an in-depth VBA training course.

 

Trump Excel

Sumit Bansal is an Excel MVP who runs this website and blog, offering high quality tutorials and training and including a wealth of valuable free content. Courses are available including dashboard design and VBA where you can benefit from Sumit’s expertise and improve your own Excel skills.

 

Power Query training

This site offers a vast array of Power Query training, with courses, books and walkthrough examples of how to do some incredible things with Power Query.

 

Peltier Tech

Jon Peltier’s blog, showing off his Excel expertise and particularly specialising in charting and dashboards.

 

My Excel Online

Another with a regular podcast, John Michaloudis’ site includes his renowned pivot table training programme and an exciting new Power Query & Data Cleansing course with John accompanied by Oz du Soleil. John is an excellent presenter as you can see from numerous webinars on his site and his blog posts and overall website is really professional, clear and simple to use.

 

Ron de Bruin’s Excel automation site

A fantastic resource for acquiring pre-written reusable VB code to help automate common tasks in Excel. Scheduling a report refresh, emailing files out automatically, you name it – Ron will have some code for you.

 

Desk Bright

Desk Bright offers established Excel training courses including advanced functions and their Excel Mastery Certification. There’s also plenty of articles and free content for you to browse at your leisure. This site comes highly recommended for everyday users of Excel who are comfortable with the basics but want to learn more about the next level of Excel’s capabilities.

 

Spreadsheeto

Spreadsheeto offers Excel training courses along with packages which include access to coaching from their experts, assignments and certificates on completion of the courses. Go to their blog and read the in-depth tutorials on pivot tables, lookups and numerous other beginner / intermediate Excel skills to get a feel of the kind of training available.

 

How To Excel

There are some great free resources on this website. The site includes sections on Power Query, VBA and Charts packed full of valuable free content, easy-to-understand tutorials and a free e-book.

 

Learn Excel Visually blog

As well as being an Excel expert, Diane is an expert at visually presenting information and this is evident in the look and feel of this blog. The posts are always thorough, infotmative, well thought out and presented beautifully.

 

These are some of the finest Excel minds on the planet and fine examples of the quality and quantity of free content there is available to help you improve your Excel skills. I’ve added links to some more sites below, these are non-Excel sites but might be of interest to data analysts.

 

OTHER

Perceptual Edge is a good resource for general data visualisation techniques and training.

 

Clearly and Simply is another of the same ilk, with great ideas for analysing data and presenting information.

 

Football-Data.co.uk is an excellent resource for those of you interested in football (soccer) betting based on sound logic and statistical data. You can use some of the Excel techniques found within the tips pages to come up with profitable systems and test them before you start with the historic data available. We built a VB module for merging the data from all leagues automatically (as some leagues have less data available than others, this can be a real time-saver), so feel free to make use of that!.