Image: 200dgr/Shutterstock. Applying multiple criteria against different columns to filter the data set in Microsoft Excel sounds difficult but it really isn’t as hard as it sounds.

To add parentheses in Excel, you can use this function: =” (“&cell-number&”)”. However, here, we have shown several conditional ways to use the same function so that you can replace a ...

This function counts the number of cells in selected ranges that meet multiple criteria This article explains how to use SUMPRODUCT in Excel. The directions apply to Excel for Microsoft 365, Excel ...

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

We can use two functions to add a suffix to multiple (or all) entries across a column. The first one is using the & operator, and the second is using the CONCATENATE function.