Compare two Excel sheets for Matches and Differences with Excel VBA Workbook

This course will teach you how to compare two similarly structured (exact same number of columns) data and find the addition of data from old to new, deletion of data from old to new and variances between existing data rows which are available in both data sets.

And you can do this with an already crafted Excel VBA workbook. The workbook has already set structured where you can just compare two data sets (Sheets) and find out differences and similarities at cell level

This is very important for data analysis, especially datasets like HR and Payroll, Stocks and Inventories, Sales commission and sales for each person! and there is much other application of this workbook.

• 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: Excel VLOOKUP Function - A Step by Step Visual 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, 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

• Basic Knowledge of Microsoft Excel

• Basic to Intermediate knowledge of Excel Formulas and Functions

• Basic to Intermediate Knowledge of Excel VBA

If you are new to data analysis and data science career path, this course will give you the basics of data analysis and what tools are best for your data. But since Excel is a well known and very popular application, it would be best to start your journey from this course!

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

Reed courses certificate of completion

Digital certificate - Included