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 use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions ...

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

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

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

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.

Excel uses the Visual Basic for Applications (VBA) language to generate functions used within the spreadsheet. Most developers use Excel functions to automate processes such as importing data from ...

How to Graph a Function in Excel. A mathematical function is a formula that takes an input, x, applies a set of calculations to it, and produces an output called y. By calculating a function at a ...

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

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.