Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Here’s Microsoft’s complete list of all Excel functions, but here are some common ones to get you started: =AVERAGE to find the average of a group of cells ...

In Excel 365, the “Unique” function filters out repeated items, showing only those appearing exactly once, while the “Distinct” function lists all distinct items, regardless of frequency.

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...

In such cases, Excel's LOOKUP function can be extremely useful. It allows you to search for a value in a range of cells and return a corresponding value from another range.

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list: =COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).

As an enhancement to Excel’s calculation engine, the Dynamic Arrays functionality enables a single formula to produce results that expand into other cells, as demonstrated in the SORT example below.