When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for ...

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell. Search finds data in a cell and returns the ...

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.

How to Subset Data in Excel. Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data ...

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

Learn how to Circle Invalid Data in Excel. We also show you how to remove Invalid Data, and validate and approve the circled data.