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

If you want to compare data in a side-by-side fashion, then we suggest using the Scenario Manager feature in Excel. You can also use it to swap multiple sets of data within a single worksheet.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

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.