Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

The REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel ...

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.

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

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

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

If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...

Learn how to use the ISNUMBER function in Excel. The ISNUMBER function's purpose is to return TRUE if the function is a number.

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

Thankfully, if you've been using Apple Numbers and need to convert a sheet to Excel, Apple has a built-in function that makes this a painless process.