You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

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.

Open a new Microsoft Excel spreadsheet by clicking the "Excel Workbook" button on the welcome screen. Create column headers to organize your data set into discrete records.