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

Unfortunately, if you're using Excel 2019 or earlier, you won't be able to create your own functions using the methods described in this guide.

Functions in Excel give you a deep level of customization for your spreadsheet, and their versatility allows you to craft formulas for nearly any need you may have.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

If you find yourself in a situation where you need to get a count of cells that contain one or more criteria, Excel includes both the COUNTIF and COUNTIFS functions for you to use.

Counting cells in Excel using the COUNT function is very easy, so if you want to learn how to do it, read this post to learn all about it.

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

The COUNTIFS function in Excel is a powerful and versatile tool for counting cells based on multiple criteria. It offers a significant advantage over the COUNTIF function, which is limited to ...

In this tutorial, we will explain how to create a bulleted list using the CHAR function in Microsoft Excel. Bullets are black circle points but can also be any symbol.

Microsoft Excel is the go-to if you want to calculate a lot of data all at once, but even outside of basic math, you can use the app to find specific info.