Excel Functions

A function is a predefined formula that performs calculations in a particular order using specific values. Excel functions are split into 14 categories:

  • Compatibility
  • Cube
  • Database
  • Date and time
  • Engineering
  • Financial
  • Information
  • Logical
  • Lookup and reference
  • Math and trigonometry
  • Statistical
  • Text
  • Used defined (that are installed with add-ins)
  • Web

Over the years, the number of Excel built-in functions continued to grow and more versatile functions XLOOKUP, FILTER, UNIQUE, or LAMBDA are being developed. If you want to benefit from everything Excel has to offer, then I strongly encourage you to get a Microsoft 365 subscription.

To use a formula you need to write its name and insert the required arguments. You can find out more about a function by using the built-in help menu.

How to use functions in Excel

Most used Excel functions

You may be wondering which are the most used Excel functions. According to Microsoft, the top ten functions are SUM, IF, LOOKUP, VLOOKUP, MATCH, CHOOSE, DATE, DAYS, FIND, and INDEX.

Recently published tutorials

I have included below a list of important functions that I use frequently. Understanding how they work can greatly help you work faster and smarter in Excel.

How to use COUNTIF - COUNTIF applies a condition to a given range, counts the number of occurrences matching the criterion, and returns the number of matches.

How to use EOMONTH - EOMONTH returns the last day of a month, a specified number of months into the future, or the past.

How to use IF - IF is one of the most popular functions in Excel. It allows you to make logical comparisons and return either TRUE or FALSE.

How to use INDEX and MATCH - The INDEX-MATCH combo is incredibly powerful and allows you to overcome the limitations of VLOOKUP.

How to use PMT - PMT is a financial function that returns the periodic payment for a loan based on a constant interest rate, the number of periods, and the loan amount.

How to use IPMT - IPMT is a financial function that returns only the interest payment for a loan. IPMT is the abbreviation for interest payment.

How to use PPMT - PPMT is a financial function that returns only the principal payment for a loan. PPMT is the abbreviation for principal payment.

How to use SUM, SUMSQ, SUMIF, and SUMIFS - SUM is the most basic Excel function. Use it to add the values in cells. SUMIF and SUMIFS allow you to add some of the cells but omit others, based on the criteria provided in the formula.

How to use VLOOKUP - VLOOKUP is used to search and retrieve data from a specific column in a table.

Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?

Essential Functions

Popular Articles

Excel courses

I have compiled a list of the best Excel online courses. It covers basic and advanced topics, VBA, and Power BI.
View courses
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created ExcelExplained.com to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2022 ExcelExplained.com
>