DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...

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

How to add a wildcard in Excel Don’t worry if you’re not familiar with wildcards, but they are something you should review because they really come in handy.

How to Use Trig Functions in Excel. Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic ...

The Excel Not function is a built-in Logical function in Excel, and its purpose is to reverse the logic of its argument. Learn how to use it.

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.

How to Use the Less Than or Equal to Function in Excel. Microsoft Excel has a powerful conditional IF function that allows you to change a cell's formula if a certain condition is met.

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

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.

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

The Excel ASIN function returns the arcsine or inverse of a number. In this tutorial, we will explain how to use the ASIN function in Excel.