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

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

When you track income and outgo in Microsoft Excel, you can use the program's MIN and MAX functions to monitor exceptional values in sets of payments, invoice totals, product orders, manufacturing ...

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’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

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

Various Count Functions in Excel. If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet.

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

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

The Excel ISEVEN function aims to return True if the number is even. This tutorial will show you how to use the ISEVEN function in Excel.