Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.

Learn these top skills to create your own formulas and functions.

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.

Find links to examples of commonly-used formulas, including some video examples.

An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of …

How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.

Date and time: Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. This function is not available in Excel for the …

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference. To perform basic mathematical operations, such as addition, subtraction, multiplication, or …

Formulas are equations that perform calculations on values in your sheet. All formulas begin with an equal sign (=). You can create a simple formula by using constant and calculation operator. For …