Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Top Excel Formula Tutorial Sites, Rated and Reviewed for 2019

Female student in front of chalkboard appearing in deep thought.

The right Excel formula tutorial can help you make sense of various functions.

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. 

Spreadsheet on a document with a calculator and magnifying glass.

Formulas in Excel allow you to automate complex and repetitive functions.

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 StarStarStarStarHalf star
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 StarStarStarStarHalf star
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 StarStarStarStar
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 StarStarStarHalf star
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 StarStarStarHalf star
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 StarStarStarHalf star
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 StarStarStarHalf star
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 StarStarStar
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 StarStarHalf star
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 StarStar
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 StarStar

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. 

2. Microsoft Office

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.

3. 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 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.

Table top with notebook and calculator.

When you understand how to use Excel formulas, you can save time and work more efficiently.

6. 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. 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. 

8. Excel Tip

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. 

Laptop computer with spreadsheet displaying.

A live chat service can provide you with problem-specific guidance with Excel formulas.

9. Chandoo.org

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.

10. Excel Functions & Formulas

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. 

11. Spreadsheeto

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. 

 

Solution examples
I need a formula that will check if 2 or more cells containing names match then add the adjacent cells to matching name together.
Solved by F. D. in 59 mins
I'm trying to use something, like index/match, to find data then sum it across rows
Solved by M. F. in 60 mins
Hi, I need some help setting up a formula that takes info from my 'Purchase Log' sheet so it updates my 'Totals By Media Channel' sheet The formula first needs to identify whether Column I reads 'Google' or 'Media Alpha' of my Purchase Log, and then I need it to SUM up everything that says 'Google' in Column I and then take that total and multiply it by 12 x 1.5 x .8 so it then updates my Totals by Media Channel sheet. I feel like it should be the 'IF' function version of this formula: =(SUM('Purchase Log'!H2:H39))*(12)*(1.5)*(0.8)
Solved by G. J. in 37 mins
I have a list of cost prices in one column and i would like to know what formula to use to add a percentage value. E.g if my cost price is just £1 i would like to create the sell price to be perhaps £3, but if my cost price is £1000, i would like the sell price to perhaps be £1,100 (not £3,000).
Solved by M. Y. in 60 mins
How can I automatically change different cells and the information they display if we select different option from a drop down list?
Solved by V. U. in 59 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc