Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

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

You can use the VLOOKUP function in Microsoft Excel to efficiently find corresponding data for a specific value.

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.

Microsoft Excel affords considerable control over the data your store in it. VLOOKUP is a great way to find and return data, which can then be presented in various other ways.

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

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

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

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.