If you want to count the frequency of a text in Excel, you can use the Countif function. This article explains the step-by-step procedure.

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.

In this tutorial, we will explain how to use the COUPDAYBS, COUPDAYS, and COUPDAYSNC financial functions in Microsoft Excel.

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.

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range.

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