The best Excel resources on the web

There are many resources around the web that can help you learn Excel. Check out these free websites for additional tutorials, exercises, and more.

Our goal is for this to be the most comprehensive list of Excel resources on the web. If you have any suggestions for websites or blogs to add, please feel free to let us know in the Comments section below.

• Full-featured Excel sites
  • Deskbright. That's us! Check out our site for in-depth tutorial on some of Excel's most common functions, including IF statements, SUMIFs, VLOOKUPs, and INDEX MATCH.
  • Exceljet. Authors Dave and Lisa Bruns have put together a very comprehensive website on Excel functions and classes. Their video tips and examples get rave reviews from users.
  • Excel Easy. A great starting point for beginners, with excellent tutorials on using the ribbon and succeeding with common Excel formulations.
  • Chandoo.org. Purna Duggirala, also known by his nickname, Chandoo, is a legend in the Excel community. His site contains hundreds of helpful resources, from formula examples to full-fledged training programs.
  • Excel Exposure. Fantasic, free, and comprehensive video tutorials on many of Excel's most important features and functions. Created as part of the University of Reddit course.
  • GCFLearnFree.org. Free, beginner-to-intermediate tutorials on a number of technology topics, Excel included. A non-profit program of the Goodwill Community Foundation.®
• Excel blogs
  • Contextures. This Excel consulting firm, run by Debra Dalgleish out of Ontario, Canada, publishes a number of practical tutorials and helpful templates.
  • Spreadsheet Page. John Walkenbach, author of the Excel Bible series, has a great site with links to his Excel books; downloadable utilities; and function tutorials.
  • Excel User. Fantastic, full-featured blog with explanations of Excel functions and charting tricks. Also sells e-books on various aspects of Excel, including dashboard reporting and professional-quality charts.
  • Easy Excel. Swedish analyst Audun Danielsen's blog provides explainers on a number of common Excel functions, as well as a really helpful list of Excel functions in other languages — including Spanish, French, and German.
  • Spy Journal. Software and web development consultant Tim Miller blogs about Excel, technology, and the web.
  • Better Solutions. Russell Proctor's "Better Solutions" is a Microsoft Office development consultancy that provides a number of fantasic free resources for Excel, Word, Powerpoint, and Outlook learners.
  • Brad Edgar. Personal blog with a number of comprehensive dashboard tutorials. Brad also offers a number of great dashboard templates, downloadable for $5 each.
  • Excel Bytes. Run by Excel specialist Mike Rempel, this frequently-updated blog contains an assortment of miscellaneous how-to tutorials.
  • LearnExcelMacro.com. This blog, hosted by Vishwamitra Mishra of Amsterdam, has a series of solid tutorials focused specifically on VBA and macros within Excel.
  • Excel-Pratique. Run by Excel expert Sébastien Mathier, this website provides a great dedicated VBA course. It's also got a language selection feature for those interested in French-language tutorials.
  • ExcelGuru. A fantastic blog written by Microsoft MVP Ken Puls. Contains a number of more advanced articles on Excel tips, as well as a large forum for help with charts, pivottables, and VBA.
  • Excel by Joe. Helpful blog from a former accountant outlining useful Excel tips and tricks. Joe also runs a sister site called Optimize Lineups, which provides Excel-based tools to manage fantasy sports picks.
  • Excel Experts. An Excel and VBA consultancy that also provides some fantasic video tutorials, free spreadsheet templates, and a full-featured community forum.
  • Online PC Learning. Microsoft Office teacher Trevor Easton provides over 200 free videos on VBA, Excel, and other Office products.
  • WMFExcel. A small blog dedicated to showing users Excel tips and tricks, published by Ming Fung Wong.
  • Excel Super Site. A small blog on practical Excel tips and advice from Brian Krisanski.
  • Excel Juggler. A small blog with miscellaneous articles on Excel's more advanced functionality, including pivot tables, charts, and what-if analysis. Written by Arun Khattri, who aims to help sales professionals use Excel to expedite their work.
  • Excel Esquire. Personal Excel blog run by commercial litigator Ben Kusmin. Focuses on ways for attorneys to speed up their work using Excel.
  • Trump Excel. A helpful website run by Excel expert Sumit Bansal. In addition to Excel tutorials, contains a number of helpful templates for pareto charts, expense calculators, employee time tracking, and more.
  • Acuity Training. Acuity Training offers a fantastic guide to Excel for SEO professionals.
  • Excel Champs. Run by blogger Puneet Gogia, this blog is a good resource for Excel users with detailed function overviews and sample files.
  • Excel Itch. Lee’s wonderful website provides comprehensive Excel tutorials, explaining the key components of Excel in a clear and detailed way. This website is an excellent resource to help transform yourself from the ‘regular user of Excel’ to ‘the go-to guy in the office’ for Excel. Very active and popular on Twitter @ExcelItch and Facebook. Lee also produces YouTube tutorials.
  • MyELesson. A collection of more than 850 free videos on MS Excel, MS VBA, MS PowerPoint & MS Word. The training videos combine just the right dose of fun and learning to let you have an engaging learning experience.
  • Excel Off the Grid. A small blog written by Excel expert Mark Proctor. Focusing upon practical Excel and VBA tips and tricks to save time and achieve more every day.
  • Excel Wiz Kid. A small Excel blog with useful tips and visual walkthroughs on a number of common Excel features.
  • XelPlus.com. Run by Leila Gharani, this website provides free video and written Excel tutorials. Leila also offers online courses on visually effective Excel dashboards, advanced formulas and charts.
• Interview prep
  • TestsTestsTests. A great resource for those preparing for Excel tests — and looking to learn more about Excel in general. Also includes tutorials with matching tests for Word and Powerpoint.
  • Exam Tiger. A multiple choice test on basic Excel features.
  • Mettl. Pre-employment assessments for programs including Microsoft Excel.
  • WiseStep. General advice on topics like interview tips, resume preparation, cover letters, human resources, and more.
• Paid courses
  • Udemy's Beginner tutorial (affiliate link). An excellent series of beginner-to-intermediate Excel tutorials from online education company Udemy. Explains workbook functions, basic formulas, graphics, and charts.
  • Udemy's Advanced tutorial (affiliate link). Udemy's more advanced Excel course, covering conditional functions, lookups, arrays, and Pivot Tables.
  • Excel University. Fantastic online Excel training courses geared towards CPAs and accounting professionals.
  • Excel Everest. Excel Everest is a fully interactive tutorial built inside Excel itself. It's a well-designed, comprehensive way to learn Excel if you're just starting out.
  • My Excel Online. Various Excel resources, from animated gif blog posts that cover Excel features with downloadable workbooks, to online courses that cover Pivot Tables in great detail. Also has a weekly Podcast interviewing fellow Excel experts/MVPs to get their insights and tips on all things Excel.
  • The Excel Trainer. Mike Thomas has put together a number of paid video courses on Excel; he also has a number of free videos on specific Excel use-cases.
  • R for Excel Users. John Taveras' excellent blog and book guide Excel users who want to take their first steps in the programming language R.
  • Yoda Learning. A library of fantastic video tutorials on tips and tricks for Excel, PowerPoint, Outlook, Excel VBA, Access, Excel Dashboards and Data Science. Their online courses explain business applications in clear and detailed way and "help learners become a heroes at their office".
  • Spreadsheet Productions. A solid Excel book for beginner learners looking to brush up on their Excel skills for an interview or test.
  • Graduate Tutor. Higher-end tutoring on Excel modeling from experienced MBAs, CPAs, and CFAs.
• Resources and plugins
  • Ablebits.com. Handy paid add-ins for Microsoft Excel, including tools to help merge tables; consolidate worksheets; remove duplicates; and find broken links.
  • Mac Excel Skin. A brilliant silicone keyboard cover overlayed with Mac Excel shortcut keys. We've found this to be a great fit on our Mac, and an easy way to keep track of the most useful shortcuts in Excel.
  • Excel Translator. Very useful tool for translating Excel commands between languages.
  • Peltier Tech. Excel guru Jon Peltier offers Excel training programs at conferences around the country. He also has a number of chart utilities and add-ins for sale that help enhance Excel's built-in functionality.
  • VBA Express forums. Helpful forum for heavy users of VBA to receive tips and advice from experts.
  • VLOOKUP help. A website created by management consultant Matt Dunn to explain the VLOOKUP function specifically.
  • XLTools. A popular add-in package for Excel that includes a popup date formatting calendar; version control; and automatic data cleaning.
  • Real Statistics. A solid overview of the Excel environment that focuses on use cases in statistics.
  • Excel.tv. Solid paid Excel guides for power-users.
  • Excel Dashboard School. Offers a huge variety of beautiful templates for Excel dashboards (paid resource).
  • Power-user. Power-user is a great add-in for Excel (and for PowerPoint) bring new powerful features such as mekko charts, copy-paste visible cells only, and a merged cells manager.
• Consultants
  • Pearson Software Consulting. Chip Person, Microsoft MVP and Excel / VBA consultant, specializes in Excel and the .NET framework. In addition to offering consulting services, he's got a number of great Excel tutorials and free add-ins on his site.
  • Excel and Access / Excel Consultant. Professional Excel and Access consulting and training for small businesses. Clients include HP, Microsoft, and LinkedIn.
  • Excel Genius. Canada-based Excel programming and consulting services for business process automation.

Comments