Learn how to compare Excel sheets for efficient bank reconciliation with step-by-step tips on data prep, pivot tables, discrepancy analysis ...

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.

Open the Excel spreadsheet containing the columns you want to compare. Select the data in both columns, excluding the heading. In the Styles section in the Home tab, click on Conditional Formatting.

I have a client who asked me if I could help him figure something out based on some sales reports. I said I'd look into it, but I'm not really much of an Excel user. Normally, I can figure this ...