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.

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

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

One way to get around this issue is to convert the Excel table to a range by selecting any cell in the table, and clicking ...

In Microsoft Excel, the SIGN number is a math and trigonometry function that returns the sign of a number. Learn how to use it.

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3" for March or "12" for December.

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.

In this post, we show you how to use the TAN function in Microsoft Excel. The TAN function is a Math and Trigonometry function.