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.

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch 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.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.

Microsoft Excel enables you to quickly find the percentage of two cells by using a formula and changing the cell format. This is especially useful if you have a spreadsheet full of sales data and ...

By referencing this identifier, you can find duplicates even if the data in other columns doesn't perfectly match up due to typos or skipped fields.

Microsoft Excel worksheets can become complicated, especially when comparing columns for validation. Manually cross-checking large datasets on your personal computer may cause you to overlook ...

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

Data is rarely properly formatted and structured when you import it. Try these eight tips for fast data cleanup in Microsoft Excel.