Overview
This comprehensive course on Microsoft Excel: Excel Sheet Comparison with VBA will deepen your understanding on this topic.
After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Excel Sheet Comparison with VBA comes with accredited certification which will enhance your CV and make you worthy in the job market.
So enrol in this course today to fast track your career ladder.
How will I get my certificate?
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
Who is this course for?
There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Excel Sheet Comparison with VBA. It is available to all students, of all academic backgrounds.
Requirements
Our Microsoft Excel: Excel Sheet Comparison with VBA is fully compatible with PC’s, Mac’s, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.
There is no time limit for completing this course, it can be studied in your own time at your own pace.
Career path
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc.
Course Curriculum
- 6 sections
- 23 lectures
- 00:00:00 total length
-
Introduction to Compare Data Workbook
00:06:00 -
Download Resources
00:00:00 -
Key requirements for Comparing any Datasets or Worksheets
00:03:00 -
Tool to Compare Datasets or Worksheets
00:06:00
-
Overview of Compare Data Workbook
00:09:00 -
Most Important things to remember before you use compare data workbook
00:03:00 -
IMPORTANT – First Column as KEY Column with UNIQUE Values
00:09:00 -
Deep Dive into Compare Data Workbook’s Environment
00:10:00 -
How to Change Header Rows for your data
00:06:00
-
Basics of Using macro enabled Excel files and Code Modules
00:04:00 -
Changing the Main two sheets name, variance tags in VBA Code
00:05:00 -
Changing various elements across VBA Code modules
00:05:00 -
Clear Sheet data button VBA Code
00:04:00
-
Convert Row data into Structured, clean and formatted data with Power Query 1
00:07:00 -
Convert Row data into Structured, clean and formatted data with Power Query 2
00:07:00
-
Mutual Funds Portfolio – Finding Variances at two different times
00:07:00 -
Comprehensive Payroll Analysis – Creating Powerful Dashboard 1
00:05:00 -
Comprehensive Payroll Analysis – Creating Powerful Dashboard 2
00:07:00 -
Comprehensive Payroll Analysis – Creating Powerful Dashboard 3
00:08:00 -
Comprehensive Payroll Analysis – Creating Powerful Dashboard 4
00:07:00 -
Comprehensive Payroll Analysis – Creating Powerful Dashboard 5
00:08:00
-
IMPORTANT Facts and Limitation of Compare Data Workbook
00:03:00 -
Conclusion
00:01:00