Microsoft Excel is considered the standard in both business and education for data analysis. The spreadsheet program is used to gather, maintain, process, and make sense of large data sets.
While Excel can store and display your figures with ease, it makes sense to use the functions available with the program to analyze and present data in the most useful way possible.
Formulas can be entered into cells to compute something, such as a sum or average of a range of cells. If entered properly, that formula will stay updated and recalculate the results whenever you change any of the source data.
What many Excel users don’t realize is that there are multiple ways to enter formulas in Excel as well as dozens of functions that can be combined to produce hundreds of different desired results. While there might be some commonly used formulas and functions, the possibilities for creating complex formulas in Excel are nearly limitless.
This seems like a lot to learn, and it is! Fortunately, there’s online help available to get you started and provide some assistance along the way. Here are the 11 top online Excel tutorial sites, rated and reviewed for 2019.
|Name||Description||Year Est.||Number of Different Tutorials||Website Last Updated||Free Access to Resources||Help||Score|
|Excelchat||Excelchat offers on-demand help in Excel through a combination of AI and knowledgeable experts. The site delivers a ready-made library of thousands of Excel tutorials and solutions that are simple to locate – from the common to the obscure, with new information added daily.||2018||More than 100||Within the past month||Yes||Live Help|
|Mr. Excel||MrExcel.com is a website and message board that has been online for over 20 years. The site provides examples of functions, formulas, and VB procedures.||1998||More than 100||Within the past month||Yes||Forum Help|
|YouTube||The largest repository of video content in the world, YouTube certainly has plenty of Excel formula tutorials on its site. The trick is finding the one that meets your needs. This could be helpful or a time-consuming exercise.||2005||More than 100||Within the past month||Yes||No Help|
|ExcelJet||Exceljet is an online resource for learning and troubleshooting Excel. It was created and is run by a husband and wife team who produce videos and other narratives as tutorials.||2012||More than 100||Within the past 6 months||Yes||No Help|
|Excel Easy||Excel Easy provides online tutorials on a wide variety of Excel functions. There are over 300 examples, divided into chapters, on the website. While the help on the website is free, there is no specialized help available and a lack of frequent updates.||2010||More than 50||Within the past 6 months||Yes||Email Help|
|Excel Tip||Excel Tip is an online extension of the larger Excel Forum. Its aim is to provide tutorials and tips on using various functions in Excel.||2013||Less than 100||Within the past 6 months||Yes||Forum Help|
|Chandoo.org||This is an Excel training site based in India that is run by Vijay Chandoo, whose goal is to help you “become awesome at Excel.” The site has many tutorials on writing and using formulas and functions in Excel.||2004||More than 50||Over 6 months ago||Yes||Forum Help|
|Office||Microsoft Office provides an Excel formula tutorial solution that is Free. You download an Excel file with tutorial topics covered in different tabs. There is no advanced training or specialized help available, though.||1999||Less than 50||Within the past month||Yes||No Help|
|Excel Functions & Formulas||ExcelFunctions.net is a long-standing website that provides some free tutorials on the use of most versions of Excel. It has a list of “popular searches” as well as categories of articles on Excel.||2008||Less than 50||Over 6 months ago||Yes||No Help|
|Corporate Finance Institute (CFI)||CFI is an online resource that aims to help its users become “world class financial analysts.” It offers a variety of courses in accounting, financial modeling, and Excel – including Excel formula tutorials.||2015||Less than 50||Over 6 months ago||Yes||No Help|
|Spreadhseeto||This is an Excel training website based in Denmark. This site has both free and paid Excel training, but there are some free formula tutorials available.||2015||Less than 50||Over 6 months ago||Yes||No Help|
1. Excel Chat
Excel Chat offers on-demand help in Excel through a combination of AI and knowledgeable experts. The site delivers a ready-made library of thousands of Excel tutorials and solutions that are simple to locate — from the common to the obscure, with new information added daily.
Not only can you read tutorials and watch videos about Excel formulas, but there is also problem-specific help available around the clock. If you’d rather have one-on-one assistance, you can open a chat window at any time of the day or night and connect with an Excel expert that can walk you through a formula or help you troubleshoot an issue.
Microsoft Office provides a free Excel formula tutorial solution. You can download an Excel file with tutorial topics covered in different tabs.
The topics that are covered in a single spreadsheet tutorial include Introduction to Functions, Basics, AVERAGE, MIN & MAX, Date & Time, IF statements, Joining text and numbers, VLOOKUP, Conditional Functions, Function Wizard, and Formula Errors. There is no advanced training or specialized help available, though.
The largest repository of video content in the world, YouTube certainly has plenty of Excel formula tutorials on its site. The trick is finding the one that meets your needs.
This site could be helpful or a time-consuming exercise, since you might not find what you need immediately and could spend time watching unhelpful videos. Some of the channels to check out include “Excel Functions,” ExcelIsFun,” and “Technology for Teachers and Students.”
4. Excel Jet
Excel Jet is an established online resource that helps users troubleshoot and learn Excel. It was founded and is maintained by a husband and wife team that produce articles and videos as tutorials.
If you learn by example, this could be an excellent option for getting up to speed with Excel functions. Excel Jet lists more than 500 examples of formulas using various Excel functions such as VLOOKUP, MATCH, INDEX, AVERAGE, RANK, and more.
5. Excel Easy
Excel Easy claims that it is the “#1 Excel tutorial on the net.” It does have many free resources and examples, but the site is not updated frequently.
Excel Easy provides online tutorials on a wide variety of Excel functions. The website offers more than 300 examples that it divides into different chapters. While the tutorials and articles on the website are free, there is no specialized help available.
CFI is an online resource that aims to help its users become “world-class financial analysts.” It offers a variety of courses in accounting, financial modeling, and Excel. Some courses are paid, but it also has some free resources, including tutorials for Excel formulas.
The formula tutorials include help with basic functions as well as advanced financial functions in Excel. There is a free Excel Formulas Guide for Beginners that includes a video tutorial. The advanced guide includes ten advanced formulas that any financial analyst should know.
7. Mr. Excel
Online for more than 20 years, Mr. Excel is a combination message board and website that provides examples of formulas, functions, and VB processes in Excel.
These are free to access, but users might have trouble finding what they need. Some items are located under the “Resources” section and others under the “Archive” section. While there is no live help for problem-specific issues, there is a forum that could provide assistance.
Excel Tip, which was created as an extension of a larger forum for Excel, is a tutorial site meant to assist students and professionals that want to learn to use the program. There are tutorials aimed at Excel basics, Formulas & Functions, Charts, VBA, and Templates & Dashboards.
The Formulas & Functions tutorials section is not extensive. However, it is divided into several categories: Text, Statistical, Financial, Logical, Math & Trig, and Lookup & Reference. These are free resources, but any problem-specific help would need to come from the forum, which may not be reliable or accurate.
This India-based Excel training site was founded by Vijay Chandoo, who wants to help you “become awesome at Excel.” The site has many tutorials on writing and using formulas and functions in Excel, and there are also online classes that are paid.
For example, the Writing Simple Formulas in Excel tutorial is a video training that includes the basics about formulas, SUM formulas, IF and Else formulas, Count of values, and Sum of values. There are also formulas sub-sections and pages that include information on VLOOKUP, SUMIFS, INDEX, and over 100 formula examples.
ExcelFunctions.net is a long-standing website that provides some free tutorials on the use of most versions of Excel. The site focuses on functions and formulas, so it is an excellent resource for tutorials.
It has a list of “popular searches” as well as categories of articles on Excel. There are even lists of functions by year, such as 2003, 2007, 2016, and 2019. However, the site does lack personalized help if this is something you want or need.
This is an Excel training website based in Denmark. This site has both free and paid Excel training, but there are some free formula tutorials available.
These are basic, such as learning what formulas are, how to create them, and the order of operations in formulas. There is a file included with the training, which is helpful, but there is no problem-specific help offered by the site.
As you will see in your training, there are not only multiple ways to get results with Excel formulas but also many pathways to get the help you need. You can decide which method works best for you.
Most Excel users are fond of the combination of AI and knowledge experts provided by Excelchat. Not only are there hundreds of ready-made Excel tutorials available on just about every Excel function, but you also have the benefit of personalized help when you need it.
Live Excel experts are standing by to answer questions or troubleshoot issues with Excel formulas around the clock. And your first session is always free.