Course curriculum
-
1
Introduction to the Course
- Introduction to the course FREE PREVIEW
- Download Amazing Compare Data Excel VBA Workbook and other example files
- Key requirements for Comparing any Datasets or Worksheets FREE PREVIEW
- Our Chosen Tool to Compare Datasets or Worksheets
- Data Comparison Basics
-
2
Comprehensive Introduction to Compare Data Excel VBA Workbook
- Overview of Compare Data Workbook FREE PREVIEW
- Most Important things to remember before you use compare data workbook FREE PREVIEW
- IMPORTANT - First Column as KEY Column with UNIQUE Values
- Deep Dive into Compare Data Workbook's environment
- How to Change Header Rows for your data
-
3
Modify VBA Codes to suit your needs
- Basics of Using macro enabled Excel files and Code Modules
- Changing the Main two sheets name, variance tags in VBA Code
- Changing various elements across VBA Code modules
- Clear Sheet data button VBA Code - How to change it
-
4
Data Cleaning, Format and Structure your datasets with Power Query
- How to Install Power Query in any Excel/Office Version (+my Power query story)
- Convert Row data into Structured, clean and formatted data with Power Query 1
- Convert Row data into Structured, clean and formatted data with Power Query 2
-
5
Practical and Real world application of Compare data Workbook
- Mutual Funds Portfolio - Finding Variances at two different times FREE PREVIEW
- Comprehensive Payroll Analysis - Creating Powerful Dashboard 1 FREE PREVIEW
- Comprehensive Payroll Analysis - Creating Powerful Dashboard 2
- Comprehensive Payroll Analysis - Creating Powerful Dashboard 3
- Comprehensive Payroll Analysis - Creating Powerful Dashboard 4
- Comprehensive Payroll Analysis - Creating Powerful Dashboard 5
- Excel VLOOKUP Function - A Step by Step Visual Guide
-
6
Conclusion, Thank you and Some Important Facts about Compare Data Workbook
- IMPORTANT Facts and Limitation of Compare Data Workbook
- Conclusion and Thank You