Excel Mastery: How to Compare Two Sheets and Find Difference

Compare two datasets or sheets, find out newly Added rows, Deleted rows, and CELL level Variances with just a few clicks

Created by: Prashant Panchal, ACA
Excel & BI Enthusiast, CA, Finance & Accounting Professional

Created by: ExActProBi (Prashant Panchal)
Excel and Data Transformation Expert, Chartered Accountant

What Will I Learn?

• Find out critical variances at each CELL level in Excel worksheets, which is not possible with Formulas and Functions.
• Compare simple to complex datasets or worksheets with few clicks and get accurate variances in the form of matching data, new data added and data removed.
• Make adjustment in the compare data workbook to suit one's requirements.
• Create Effective, Reusable and Dynamic Excel Model effectively by harnessing Compare Data workbook's ability
• Modify Excel VBA code behind the compare data workbook to get accurate analysis and variances

Requirements

• Basic Knowledge of Microsoft Excel
• Basic to Intermediate Knowledge of Excel Formulas and Functions
• Basic to Intermediate Knowledge of Excel VBA

Target audience

• Accountants, Auditors, Analysts who want to accurately compare data with few clicks
• Data Analysts, Data Science Professionals who want to find out data variances quickly
• Busy HR Professional, Sales Professional, Small Business Owners, Entrepreneurs