Excel VBA Data Comparison Masterclass

FindDataPro

• Introduction to Compare Data Workbook 21:34

  • 1: Compare data Workbook - PROMO Preview 05:38
  • 2: Introduction to Compare Data Workbook Preview 03:58
  • 3: Download The Amazing Compare Data workbook here 01:00
  • 4: Key requirements for Comparing any Datasets or Worksheets Preview 03:07
  • 5: Our Chosen Tool to Compare Datasets or Worksheets Preview 05:51
  • 6: Data Comparision Basics 02:00

• Comprehensive Introduction to Compare Data Excel VBA Workbook 35:56

  • 7: Overview of Compare Data Workbook Preview 08:50
  • 8: Most Important things to remember before you use compare data workbook 02:59
  • 9: IMPORTANT - First Column as KEY Column with UNIQUE Values 08:37
  • 10: Deep Dive into Compare Data Workbook's environment 09:34
  • 11: How to Change Header Rows for your data 05:56

• Modify VBA Codes to suit your needs 18:06

  • 12: Basics of Using macro enabled Excel files and Code Modules Preview 04:09
  • 13: Changing the Main two sheets name, variance tags in VBA Code 05:19
  • 14: Changing various elements across VBA Code modules 05:05
  • 15: Clear Sheet data button VBA Code - How to change it 03:33

• Data Cleaning, Format and Structure your datasets with Power Query 14:29

  • 16: How to Install Power Query in any Excel/Office Version 01:00
  • 17: Convert Row data into Structured, clean and formatted data with Power Query 1 06:40
  • 18: Convert Row data into Structured, clean and formatted data with Power Query 2 06:49

• Practical and Real world application of Compare data Workbook 43:59

  • 19: Mutual Funds Portfolio - Finding Variances at two different times 07:01
  • 20: Comprehensive Payroll Analysis - Creating Powerful Dashboard 1 05:16
  • 21: Comprehensive Payroll Analysis - Creating Powerful Dashboard 2 06:40
  • 22: Comprehensive Payroll Analysis - Creating Powerful Dashboard 3 08:25
  • 23: Comprehensive Payroll Analysis - Creating Powerful Dashboard 4 07:14
  • 24: Comprehensive Payroll Analysis - Creating Powerful Dashboard 5 08:23
  • 25: XLOOKUP vs VLOOKUP - Detailed Guide 01:00

• Conclusion, Thank you and Some Important Facts about Compare Data Workbook 05:00

  • 26: IMPORTANT Facts and Limitation of Compare Data Workbook 02:44
  • 27: Conclusion and Thank You 01:16
  • 28: My Other Courses for Excel and Data Mastery 01:00

Have you ever had a need to Compare two datasets or worksheets?

As an entrepreneur, accountant, HR personnel, stockbroker, etc. comparing two datasets becomes a regular task in your career.

Whether it is to compare employee datasets, salary or payroll, stocks, sales commission and so much more; you will definitely find yourself coming across tabular worksheets from time to time.

It can get pretty tasking and most discouraging is the fact that traditional methods which you often used in Microsoft Excel such as functions, formula and power query; are not always reliable or can provide you answers.

If you are in the category mentioned above, worry no more. The perfect solution is here — Smart VBA Excel Workbook. With it, you can now find new data, deleted data, variances.

What if I say you could find out CELL level Variances with just a few clicks using the Compare data workbook? Sounds amazing?

That is what Compare Data Excel VBA workbook is designed to do; it compares two similarly structured datasets or worksheets by Row and then by Each CELL.

• You will typically have datasets or worksheets in periodic format, i.e. Last months dataset and Current Months dataset, and you would like to find out variances first at Row level and then at CELL level.

• Compare data workbook finds out added data in a current month, removed data in a current month (from last month) and for datasets/rows/records which are existing in both places (Last month and current month), it highlights variances at each cell level.

This is something awesome, and it is difficult to achieve this with traditional Excel formulas and functions or even with Modern excel tools as Power Query Joins. The only way out is smart VBA coding in Excel.

In this course, I will walk you through how to use this fantastic compare data workbook and teach you:

• How to set up the workbook for best results.

• How to change important VBA Code settings to suit your need.

• How to change the formatting of added data, removed data and variance data.

• How to set up this workbook in an ideal way so that you can create truly dynamic and reusable reports for any complex data analysis.

In the end, we will go through two practical examples:

• We will analyse the Mutual fund portfolio to find out critical variances between the two dates (position).

• We will go through a comprehensive Payroll analysis exercise where I will create a fantastic Payroll variance dashboard to find out variances for various pay types (Basic, HRA, Overtime, deduction etc.) in complex payroll data.

• With these examples, you will also learn how to set up this workbook to maximise your productivity.

Enrol Now and Let your data analysis and data comparison problems go away!

• Accountants & Auditors: Reconcile GL balances, intercompany transactions, or fixed asset registers quickly.
• HR & Payroll Professionals: Compare monthly payroll runs, identify unexplained variances, and ensure data integrity.
• Data & Financial Analysts: Validate data migrations, ETL processes, or system outputs.
• Any Professional who regularly needs to compare two versions of a spreadsheet (e.g., budgets vs. actuals, last month vs. this month).

• Basic Knowledge of Microsoft Excel

• Basic to Intermediate knowledge of Excel Formulas and Functions

• Basic to Intermediate Knowledge of Excel VBA

Mastering data reconciliation and automation with tools like this VBA workbook directly supports career progression in data-heavy UK roles:

1. Data Analyst (£28,000 – £43,000): Clean, compare, and validate datasets to ensure reporting accuracy.
2. Financial Analyst (£32,000 – £60,000+): Reconcile budget vs. actuals, validate model outputs, and ensure data integrity for financial planning

There are currently no Q&As for this course. Be the first to ask a question.