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

The REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel ...

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.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

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.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

How to Use the Countif & Countifs Functions in Excel. Microsoft Excel 2010 is a powerful spreadsheet program that business owners can utilize to track everything from employee's schedules to ...

The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how ...

How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what ...

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

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.