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.

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 ...

How to find missing records using VLOOKUP() in Microsoft Excel Your email has been sent In Microsoft Excel, I have used many different solutions to compare lists. Sometimes the solution finds ...

How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.

When it comes to working with data, whether it's a basic list of entries or a large dataset, Excel is usually one of the go-to tools for most people, and for good reasons. First off, it allows you to ...

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 ...

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...

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 want ...

Excel 2013 can locate duplicate rows as long as one column contains a unique identifier for each record, such as a product ID or account number. By referencing this identifier, you can find duplicates ...

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