A FACT or FACTDOUBLE function is both a Math and Trigonometry function. Learn how to use both the FACT and FACTDOUBLE functions in Excel.

The PI function is a Math & Trigonometry Function. Learn how to use the PI function in Excel, or how to multiply by PI, using this tutorial.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Generally, you can use the greater than, less than and equal signs you may remember from math class. If you want to check if two values are not equal, use the special Excel not equal notation ...

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.

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

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect ...

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.