The Complete Tutorial List of Excel Formulas - Compute Expert

The Complete Tutorial List of Excel Formulas

Home >> Excel Tutorials from Compute Expert >> The Complete Tutorial List of Excel Formulas

Want to master the usage of excel formulas? Then, you have come to the right place!

Here, you can find a list containing the links to the Compute Expert’s in-depth tutorials for each formula in excel. In each of the links, we add a brief explanation about the formula’s function. Thus, you will know what you can expect to do if you master the formula usage in excel.

Before we go to the complete list, we will discuss a bit about the details of an excel formula. From the discussion, you should understand its definition, functions, and how to add a formula to your cell generally.

What is an Excel Formula?

An excel formula is a feature excel provides to help us in processing our data into our desired outputs. Excel has many formula variations and each of them has a unique function that can perform a specific task for us.

The Benefits of Using Excel Formulas

There are many benefits we will get if we can use formulas optimally in excel. Each formula has its own unique benefit related to data processing. However, generally, here are the main functions of formulas in excel.
  • Get our desired outputs fast and accurately from the data that we have
  • Create the materials we need for further data processing
  • Automate our data processing if the data we work with in excel is dynamic

Those benefits are crucial if we want to process our data productively in excel. Therefore, try to master as many formulas as possible if you often do your work in excel!

How to Add a Formula in Excel

When you want to write a formula in excel, you have to type an equal symbol ( = ) before you write it. The symbol will inform excel that you want to write some kind of formula in your cell.

After the equal symbol, you should write the name of the formula you want to use. Next, give the inputs you need to use the formula inside bracket signs. Each formula needs different kinds of inputs to produce the result that you want from it.

For example, here is a SUM formula that we write to sum numbers in a cell range. Notice that the formula writing follows the pattern we discussed earlier.

The Complete Tutorial List of Excel Formulas - Screenshot of the Formula Writing Example in Excel

Another way to add a formula in excel is by using the Insert Functions menu in the Formulas tab. You can see the menu location in the screenshot below.

The Complete Tutorial List of Excel Formulas - Screenshot of the Insert Functions Menu Location in Excel

You can click the Insert Functions button and choose the formula you want to use on its dialog box. Alternatively, you can also click the dropdown of the formula type you want to use in the Formulas tab. Then, just choose the formula from the list that shows up.

If you insert your formula using the Insert Functions menu, there will be formula writing helpers from excel you can use. Insert the inputs that the formula needs to the text boxes excel gives and excel will write the formula for you.

The Complete Tutorial List of Excel Formulas

Even with the help of the Insert Functions menu, though, many people still find it hard to use excel formulas correctly. Because of that, Compute Expert provides tutorials on how to use excel formulas on its website!

You can see the full list of the tutorials we have already written below. We list the tutorials alphabetically so you can find the formula you want to learn easily.

Each of our tutorials contains an in-depth discussion on a specific formula that becomes the tutorial topic. We also provide simple exercises so you can practice what you have learned from the tutorial. Hopefully, the content is enough for you to understand the formula usage you wish to learn completely!

Currently, we have 113 excel formulas which we have already made an in-depth tutorial on. We plan to add more tutorials when we see there are adequate demands for them. If you have a suggestion on what excel formula we should make a tutorial on, then please contact us!

Want to Learn More About Excel?

Get updated excel info from Compute Expert by registering your email. It's free!

Want to Learn More About Excel?

Get updated excel info from Compute Expert by registering your email. It's free!

Follow our tutorial content also on

Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation

Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel

Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel

Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition

© 2021 Compute Expert