# Excel Formulas

The best Excel formulas include detailed examples and functions like XLOOKUP, FILTER, UNIQUE, SUMPRODUCT, and COUNTIFS.

Take a closer look at the formulas that are powered by user-defined functions. Microsoft Excel formulas help you to count, analyze, filter, convert, summarize, and transform data to boost productivity and speed up your work. You can use our free utility, DataFX, to perform advanced calculations. DataFX supports RegEx functions!

For Excel newbies, we have good news; you can read our detailed article about the basics.

## LOOKUP formulas

XLOOKUP changes everything. This section contains modern lookup formulas.

## Formulas and Functions

There are two ways to perform calculations in Excel; using Formulas and Functions. But first, itâ€™s time to clarify their differences.

What is a Formula? Excel Formulas are math statements that can perform calculations and manipulate the values of other cells. Also, it can test conditions and frequently uses logical operators.

Letâ€™s see a simple example: =B1 + B2 + B3 + B4 finds the sum of the cell values between cell B1 and cell B4.

What is a function? Functions are built-in presets, so there are hard-coded Excel formulas. With its help, you can avoid manual data entry, and it has small, user-friendly names.

For example, the =SUM(B1:B4) formula uses the SUM function to sum all cell B1 to B4 values.

## Best practices for using Excel Formulas

Toggle between relative and absolute reference. First, select the cell that contains the formula and use the F2 shortcut to enter the cell edit mode. Then, press F4 to switch between the reference types.

Apply autocomplete formula function. First, type an equal sign (=) and type the first character of the function. Excel shows a dynamic list of built-in functions. Next, select the function that you want to use.

Use Function ScreenTips. Type an equal sign and enter the function name. To add arguments, type the opening parenthesis. A screen tip will appear and show your formulaâ€™s corresponding argument.