Excel Help & Resources

Excel HelpI went to ALL the Excel Discussion Groups on the internet and asked all the Excel Gurus, MVPs etc one question…

<drumroll included for dramatic effect>

<you’re thinking of a drumroll aren’t you? :)>

What are the Best Excel Links on the Web?

Well, as of this writing there are 41 comments. And you will see that a LOT of those comments are by Excel MVP’s and site owners… providing their own ideas on who should be included in this guide.

If you scroll down to the Training Section, you will see a list of tutorials as well as paid training that can help you get up to speed on most areas of Excel, from the beginner, to the VBA programmer.

The BLOGS Section is PACKED with Excel MVPs and gurus. These BLOGS contain hints and advice for anyone that uses a spreadsheet. And if you are looking for tips in a more structured format, there is an entire section dedicated to Tips and Articles.

Ohh… And don’t forget the Youtube Channels and the LinkedIN Groups :)

There’s a TON here in this list. And a DOUBLE-TON in the comments section. So look around.

And if you have some ideas that you think we may have missed, feel free to add them in the comments section.

SuperSites

  • Mr Excel – No list is complete without this guy. One of the biggest Excel sites on the web and author of many Excel books.
  • Contextures – Debra Dalgleish is your host. Site is known many things including a very robust tutorial on drop down menus.
  • Excel Guru – Ken Puls does a great job at this popular site. Forum, knowledge base, etc. Plus a Pivot Table Course.
  • Chandoo – The pointy-haired Dilbert. Great site for Excel training, Excel Dashboards, and Project Management Templates

 

Training

  • Magic of Pivot Tables – Excel Guru – At one time, I lost out in a “competition” that Ken was having where the prize was a copy of this training. Yep… I lost. Ken felt bad for me and gave me a copy anyways. LOVED IT. This is a one hour video course that comes with sample files, an e-book and an immediate download. This link takes you to an Excel 2010 Class.. but he also has them for 2007 and 2003. Check it out.
  • ExcelHero – Daniel Ferry’s site. From dashboards… to VBA.
  • Chandoo’s Training – Classes from Excel School, to VBA, to Dashboards
  • myOnlineTraininghub – an extensive excel blog and is packed with training materials for Excel, Word, and Outlook.

 

Forums

  • Excel Forum – This is a large forum site. If you type “Excel Help” into your web search engine, this site will show up.
  • Ozgrid.com – This is a very robust forum with links to lots of templates. Also allows you to post excel tasks for programmers to bid on.
  • Mr Excel Message Board – I am typing this on a Sunday and there are 1,000 people on his forum. Its big :)
  • Excel Guru FORUM – Ken asks… Why go anywhere else? Come learn from the GURUs
  • Excel & Charting FORUM – by Chandoo
  • VBAExpress – Dedicated to all the VBA Nerds – my people :)

 

Discussion Groups

 

VBA

  • CPearson- Ready to be impressed? then overwhelmed? and then impressed again? Sure… why not? Then head on over to Chip Pearson’s site and click the menu button titled “Topic Index”. When it comes to VBA… the site has a TON to offer.
  • Beyond Excel – In the words of primary contributor Craig Hatmaker, “Beyond Excel is a free “cookbook approach” to extending Excel with VBA. Practical solutions are offered instead of abstract theory.” I could spend day after day on this site. Even the resources page is a gold mine. Bookmark this page.
  • Andy Pope – VBA Coding techniques, solutions and examples
  • Option Explicit VBA – A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations.
  • VBA Express – VBA Forum, Knowledge Base, Articles… All VBA All the Time
  • Erlandsen Data Consulting – Tips about Excel and VBA programming
  • VBA4Play – Cary Walkin Blog with Guest Posts by Jordan Goldmeier of OptionExplicitVBA.com. This is a Enormously Detailed and Cool tutorial on VBA. This is a MUST See. Video Games in Excel. Check it out.
    • UPDATE: I did a video review of Cary Walkin’s video game that was built entirely in an Excel Spreadsheet. Here is the Review

 

PowerPivot

  • PowerPivotPro – Rob Collie was one of the founding engineers behind PowerPivot at Microsoft during his 14 year career in Redmond. He offers classes to get you up to speed on PowerPivot. This site is the center of the PowerPivot Universe (outside of Redmond, or course)
  • SQLBI – These guys – Marco Russo and Alberto Ferrari (awesome name :) ) – write the books you read. Several books and online PowerPivot classes.
  • The Great PowerPivot FAQ – Loaded with content from all the thought leaders on PowerPivot. Bookmark this page.
  • Javier Guillen – PowerPivot and SSAS Blog
  • Dick Moffat’s Spreadsheet BLOG – Recommended by Winston Snyder. PowerPivot, BI, etc. This BLOG hits on a lot of topics that I like.

 

Youtube

  • ExcelIsFun – Over 2,000 videos on Excel. Mike Girvin is the host and he does a great job
  • Bill Jelen – 2 minute video tip about excel every weekday
  • Contextures – Over 6,000 subscribers. Lots of tutorials.
  • ExcelVBAIsFun – One of the more common questions I hear in Discussion Groups is “Where can I learn VBA for FREE” … ANSWER… errr.. here! at ExcelVBAIsFun Youtube Channel

 

Utilities

  • Excel Translator – Mourad Louha has put together a handy site for all those doing international work. Type in your function, along with your source and target language and have the formula translated. Handy tool.
  • Peltier Tech – Jon Peltier has some great tips and Excel Utilities. I have used his “Magic Quadrant” tips several times in my own consulting.
  • Spreadsheet Page – John Walkenback’s site. Mostly known as an author. I recently purchased his VBA book. Very good. But he also has several utilities that you can purchase on his site.
  • Name Manager by JKP – Range Names made easy. Utility to manage defined names in workbooks
  • Data Pig Dashboard Add-in and Data Pig Excel Explosion – Slick Add-in from the PIG.
  • Add-In Express – Development tools to create various extensions for Excel and other Office applications.
  • Ablebits.com -
  • SpreadsheetGuys – Several Products & Templates
  • ASAP Utilities for Excel – PC Magazine called ASAP Utilities “the one essential add-in for all Excel users” in its 2005 Ultimate Utility Guide and rated ASAP Utilities 5 stars: their maximum rating. Kees Jacobs (in the comment section) notes that it is Free for Home & Students

 

Blogs

  • Daily Dose of Excel – A great place to get regular updates and tips
  • RAD Excel – MVP Colin Legg’s site. Updated regularly. Focus on VBA.
  • Bacon Bits – Mike Alexander’s site. This blog supports the Data Pig Technologies site (see utilities section above). This is actually a good read. Entertaining. In today’s post, he has a cartoon from the Oatmeal. I laughed and almost posted it on FB. :)
  • Mr Excel Blog – Where Mr Excel keeps his podcasts and commentary.
  • Debra’s Contextures Blog – Regularly updated tips and tricks.
  • Ken’s Excel Guru BLOG – Hey… He even mentioned me one time. So it’s gotta be a good read :)
  • Excel Blog – myOnlineTrainingHub – Philip and Mynda Treacy add content to this Excel BLOG at least weekly
  • Chandoo’s Blog – Chandoo adds to this BLOG several times a week.
  • SmittyPro – Excel MVPs Chris (Smitty) Smith & Zack Barresse have put up some helpful posts on Forms, Data Validation, VBA, etc..
  • DataProse – Your host Winston Snyder notes that his blog is “Heavy on Excel and VBA, but wide open to anything related to data, information, business intelligence and data visualization.”
  • Excel Tables – Excel MVP Zack Barresse expands on his book Excel Tables: A Complete Guide for Creating, Using, and Automating Lists and Tables – with this website and blog dedicated to Tips and Tricks with Excel Tables. Tap into an Excel MVP Author by visiting this BLOG

 

Tips & Articles

  • Ron de Bruin – Tips and Tricks. Including a section on Excel for Mac
  • Decision Models – Articles Tips & Tricks. Especially for speeding up spreadsheets.
  • JKP Excel Articles – Articles Tips & Tricks from Jan Karel Pieterse
  • xlDynamic – Bob Philips site for Excel and VBA Tips. Also several utilities that you should check out

 

Templates

  • ExcelUser – There are lots of decent Template sites on the web, but ExcelUser dominates. If you go to many of the sites listed above and look at the templates in the margin… they point back to ExcelUser.
  • Project & Portfolio Management – Chandoo makes some cool looking templates :)
  • BusinessSpreadsheets.com – High End VBA-Driven Business Templates
  • Spreadsheet123.com – Ultimate Guide to the World of Excel Templates
  • ExcelDashboardTemplates.com – The title says it all. This site seems to be updated daily and includes FRIDAY CHALLENGES where a question is offered and you are given the opportunity to submit creative solutions.

 

Charts & Graphics

  • E90E50charts – WOW. This is a really cool site. Many of the graphs they have here I didn’t even think were possible. As an added bonus, they let you download the files. Really cool site to expand you mind on what is possible with Excel.
  • Peltier Tech
  • Tushar-Mehta
  • Andy Pope – Excel charting techniques, solutions and examples
  • ExcelCharts.com – Best practices for effective excel charts in the corporate environment
  • Clearly and Simply – This blog is providing showcases, dashboards, tools, techniques and templates. Most of the posts will come with example files or templates for free download.

 

In Many Languages

  • EXCELGAARD – English and Danish (for the Vikings).
  • Excel-Inside – German. Excel Author and Expert Alois Eckl’s site.
  • Monsieur Excel – French. — (those who can read French — let me know what you think in the comments section)
  • Lasakovi.com – Czech. Compilation site. — (those who can read Czech — let me know what you think in the comments section)
  • ExcelForum.pl – Polish. Possibly the largest Polish Excel Forum — (those who can read Polish — let me know what you think in the comments section)
  • Apocotenexcel.pl – Polish. — (those who can read Polish — let me know what you think in the comments section)
  • VBATools.pl – Polish. Excel MVP — (those who can read Polish — let me know what you think in the comments section)
  • ExcelWorld.ru – Russian. Excel MVP — (those who can read Russian — let me know what you think in the comments section)
  • WimGielis.de – Belgium. Excel MVP — ( – Run by Excel MVP Wim Gielis

 

The MotherShip

 

Other Excel Resource Pages

 

Well… what did you think? Did I miss anything? If so, please leave me a comment, I would like to keep this list as updated as possible — So if you have a personal favorite, let me know and I will review it.  Also, you can click here for the most complete list of Excel Books on the planet.  They are categorized by function and recommended by some of the biggest excel gurus around.

 

58 Responses to “Excel Help & Resources”

Read below or add a comment...

  1. Hi Rick,

    I’d appreciate a mention on your top 10 sites for Excel :-) We have an extensive Excel blog:

    http://www.myonlinetraininghub.com/blog

    I also have a hugely popular Excel dashboard course that is recommended by Mr Excel, Debra Dalgleish and Daniel Ferry to name a few:

    http://www.myonlinetraininghub.com/excel-dashboard-course

    Plus we offer Excel, Word and Outlook training.

    If you have any questions I’d be happy to answer them.

    Kind regards,

    Mynda.

  2. Tim Marston says:

    Hi Rick

    Thanks for his resource, as you know from the help you have been me I REALLY struggle with spreadsheets!

    Cheers

    Tim

    • Thanks for stopping by Tim. There are lots of training resources in the list if you decide to dive in a little deeper :)

      Thanks for being a long-time member of the community.

      Rick

  3. Sue says:

    Hi Rick,

    Have bookmarked your page as there are some great resources here – I often need to find out how to do something with excel as I really only have the basics but this is a great list, thanks

    Sue

  4. Hi Rick, thank you very much for your words. I’m really glad you liked e90e50chart and I hope which will please even to visitors of this site
    best regards
    r

  5. Geoff Hornbeck says:

    Mr. Grantham,

    You’re right, after discovering your website through Google, this page has helped me immensely. All the sites you mentioned are top notch and worth a look.

    Thank you.

    • Thanks Winston. This is a robust list. I guess I have my weekend work cut out for me — going through these and adding them. Thank you. My readers appreciate a thorough list :)

    • Thanks Richard. Question for you. I hear Data Bison mentioned a lot. Its a phenomenal looking site. Looks like the kind of site I would like to own :)

      But is it still being updated/maintained?

      The last activity I see was from 2010. Perhaps I am looking in the wrong place :)

      Regarding your site… Pivot Table Zen… I like the concept. I am combing through it now

      Thanks Richard.

      Rick

  6. Hi Rick,

    many thanks for listing my site here :-)

    Best Regards,
    Mourad

  7. Hi Rick,

    thanks for excellent list of English pages of Excel. There are also sites in other languages. For example, in Czech ;).

    Pavel

    • Thanks Pavel.

      I am adding your excel page now. http://office.lasakovi.com/excel/ … I must be honest that I am handicapped by my inability to understand sites in other languages. Are there other sites in other languages that you would also recommend to my readers?

      Rick

      • Thanks Rick,

        most frequently I used English articles (sometimes German, Slovakia). In Czech are interesting page:
        http://excelplus.net/

        German
        http://www.arstechnica.de/computer/msoffice/vbaindex.html

        Pavel

      • Alojz Lacko says:

        Well, I am not going to be the judge here, however, let me express my personal feeling:
        If you are putting together the list of websites where one can find some original ideas (by original I mean particular issue was most probably solved / solution was invented / published first time in there, although it might be rather questionable and difficult to verify who was the first in fact), then, I am sorry to say so, but Pavel’s pages do not qualify. It’s rather a compilation of many solutions originally published somewhere else. Good for someone unable to understand English, apart from that, just compilation, nothing original (although well designed and presented) and, even worse, without links to original sources. Not a big respect to intellectual property of the others, I guess.

        Regards,
        Alojz

        • Thanks Alojz.

          You and Winston are highly respected in the excel arena (see Jordan G.’s comment below). I will note it as being a compilation site for the time being and ask for ongoing feedback for all sites (particularly non-english).

          Thank you
          Rick

          • Alojz Lacko says:

            Rick, thanks. See my comment I have left below what Jordan has written.
            I am pleased if anyone like Jordan appreciates my willingness to help.

  8. Hi Rick
    This is indeed a commendable work. Many congratulation for it. I generally blog and use this website for my excel related work.
    Regards
    Naveen

  9. Hi Rick,

    lock here for a nice German Excel-Site.

    Armin

    • Thanks Armin.

      I can’t read German… So I will add your site to the list and let our readers decide. It is definitely a nice looking site :)

      Rick

    • As a follow up from my previous comment. (see above or below depending on how this saves :) )

      Someone that I respect in the German Excel community sent me a message about this site and states that the site is from Alois Eckl — author and well know Excel expert in Germany.

      Alois- I don’t know if you will ever read this, but if you do… I am happy to have your site on the page.

      Rick

  10. Jordan G says:

    Thank you for placing my blog on your list. In addition, I want to direct readers to two outstanding individuals who don’t run blogs but who freely help others online in LinkedIn forums. (Indeed, both have also posted in your comments section here.) Winston Snyder and Alojz Lacko are Excel experts who have no problem providing their technical expertise and advice on LinkedIn. I would strongly urge folks to follow them and join the forums to which they contribute.

    • Alojz Lacko says:

      Thanks, Jordan, for kind words. Especially appreciated from one whose work I admire a lot. To be honest, I have learned a lot from Winston’s contribution, not sure my knowledge is any close to his, yet keep doing my best.

  11. Heya Rick,

    I’d like to add my blog: blog.smittypro.com

    Excel MVP Zack Barresse and I have put up some helpful posts on Forms, Data Validation, VBA, etc., although I don’t get to write nearly as much as I’d like.

    Regards,

    Smitty
    Microsoft Excel MVP (2007-2014)

  12. Debi says:

    Check also this blog:

    http://www.myengineeringworld.net

    It has a lot of posts about VBA.
    I have used their code snippets many times.

    Regards,
    Debi

  13. Rick Nederpelt says:

    Hi Rick,

    You site was tipped to me on my LinkedIn Account.
    Just wanted to let you know you got lot’s of great links to great content here.

    I really appreciate the time and effort you took to put this list together.
    Congratulations on it.

    Best Regards,
    Rick

    • Thanks Rick.

      I appreciate it. Its actually been a lot of fun and very interesting to investigate all these sites. There are a lot of talented, insightful people in the Excel community.

      Rick

  14. Petros says:

    Rick

    Please review
    http://www.spreadsheet1.com
    http://www.RibbonCommander.com

    Ribbon Commander is a framework for rapid Office UI development. It aims to both simplify and extend the existing XML-based programming model for the Office UI, by exposing a complete object model for the Ribbon and Backstage (while also fully supporting XML)

  15. Winston Snyder says:

    Rick,

    Huge oversight on my part for the PowerPivot category. Excellent blog: http://dmoffat.wordpress.com/

    • Thanks Winston.

      It looks like Dick Moffat keeps this fairly up to date. Plus his most recent post is about BI, which is near and dear to my heart.

      Thanks for recommending this.

      Rick

  16. Alois Eckl says:

    Hi Rick,

    Thanks for the link to Excel Inside;). That really makes me happy that my site is ranked on the list.

    Kind regards

    Alois

    • My friends in the German Excel community speak very highly of you. You are a noted author and contributor to the Excel community. Thank you for stopping by the site Alois. I would love to line you up for an interview if your schedule allows it.

      Rick

  17. Hi Rick,

    I run the VBA4Play blog which has detailed tutorials on using excel for video games. It’s definitely niche but I think it’s one of a kind on the internet. Feel free to check it out here: http://carywalkin.ca/category/vba4play/

    Cheers,
    Cary Walkin

  18. VBA4Play… Love the title :)

    Cary, This is a VERY detailed step by step tutorial on how to build some really cool stuff. I am kind of blown away, to be honest.

    This is definitely added. Also sending you an email.

    Rick

  19. Peter Daly says:

    Hey Rick,

    Thanks a lot for putting them altogether.

    There are two websites of our company which are into this excel training –

    http://www.audiosolutionz.com/microsoft-excel.php
    http://www.excelskillssociety.org/

    Thanks,
    Peter Daly

  20. Dan Strong says:

    Hey Rick,

    Thanks so much for this mighty list! What a resource!

    I’d love it if you consider mentioning ExcelVbaIsFun as one of your Youtube sites. Thanks so much again for your hard efforts, sir.

    Dan, ExcelVbaIsFun

    • Dan.

      Honestly, I am a bit embarrassed that ExcelVBAIsFun was missed on the original list. Oooops. Hopefully people don’t read this far down the page to see my error :)

      Definitely added. Great YouTube Channel for those looking to learn VBA.

      Its great to have you here.

      Rick

  21. Pete says:

    I often refer to, use, and post in Exceldashboardtemplates.com

    This is a very good site for learning various charting techniques and tricks for use in dashboards.

    -Pete

  22. Kees Jacobs says:

    Hi Rick

    I added this site to my favourites!
    Surprised I didn’t find Asap Utilities in this list. I use it many Years ;-)

    http://www.asap-utilities.com/
    (Free for Home & Students)

    Cheers,
    Kees Jacobs

  23. BariAbdul says:

    Another fairly decent Excel site by Wim Gielis ,It is in Belgium language but got quite useful stuff,My apologies if you have already included it.
    http://www.wimgielis.be/

  24. Jordan G says:

    Under forums you should include VBA Express: http://www.vbaexpress.com/portal.php. Not sure how I missed recommending this one the first time around.

  25. Jenny says:

    Thank you! As an excel beginner I am grateful for all tips about excel. At the moment I deal with the issue “pivot filter”. So far, I help myself with a website which shows you the function step by step by a easy description and videos. Maybe do u like to see it: http://www.excel-aid.com/excel-pivot-filtersmodifying-and-filtering-pivotcharts.html In any case I will try the functions presented by you.

  26. Renat Lotf says:

    Thanks a lot, very helpful page.
    About Excelworld.ru. This is one of the biggest resourses in russiantalking area, I always use it, when I have some questions about Excel.
    Very interesting section called Brainstorming, where excel guru compete in easiest and shortest way of some Excel task.

    Here is another good site in russian devoted Excel- http://www.exceltip.ru/

  27. Dave Bruns says:

    Hi Rick – I’d like to (humbly) suggest our site, Exceljet. We have a good list of Win and Mac shortcuts here: https://exceljet.net/keyboard-shortcuts. We’re also working on useful resources for functions and formulas, as posting weekly video tips.

    Dave

  28. wow – what a great list.. thx for collecting all those excel resources. I also follow your Excel TV show on youtube. Great Job !

Leave A Comment...

*