Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

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.

The Excel ISEVEN function aims to return True if the number is even. This tutorial will show you how to use the ISEVEN function in Excel.

Learn how to generate random numbers in Excel using RAND, RANDBETWEEN, and RANDARRAY. Step-by-step guide with practical tips included ...

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.