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.

There are two other methods to use the LOG10 function. We hope you understand how to use the LOG and LOG10 functions in Microsoft Excel. What is the difference between LOG and LOG10 in Excel?

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.