DGET has only three arguments, making it much more straightforward to use than other Excel lookup functions. The DGET function is an old-school tool!

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

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

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.

Learn how to create a fixed formula using the FIXED function, which is a Text function, in Microsoft Excel. There are 3 ways.

This post shows how to use the TRUNC function in Excel. Use it to remove or truncate decimals, time from date-time format, etc. It is the opposite of Round.

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.

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 GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor ...

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