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

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such ...

In Excel, you can either use the ISEVEN function to determine even numbers; if the number is even, it will return TRUE; if odd, it will return false. The ISODD function determines odd numbers ...

Note that the following content is based on Microsoft Excel 365 for PCs. Other versions of Excel may work differently. If you would like to follow along in using this function, you can download this ...

A. Excel’s CONVERT function can be used to convert a multitude of units of measurements. For example, to convert 37.3 C in cell B3 below, I’ve entered the formula =CONVERT(B3,”C”,”F”) in cell B9 to ...

The Highlight Function in Excel. Regardless of whether your Excel spreadsheet contains a little or a lot of data, you may want to have cells that meet certain criteria stand out.

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.

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.

In such cases, Excel's LOOKUP function can be extremely useful. It allows you to search for a value in a range of cells and return a corresponding value from another range.