In this series, we are going to see how we can use Excel, XML, XSD and VBA in order to validate our data set. According to your task, you can use all of them or the ones you need. In data analytics and data science, these four can be used very frequently depending on your problem and I think it is a good habit to read these types of blog posts to keep yourself updated. Moreover, it is even better if you put an effort and practice on these subjects in order to make solid of your understanding about them.
Briefly, let’s write what we will cover for the following sections;
· Data Validation Series: Excel-XML-XSD-VBA The Holy Rectangle (this is the introduction post and this very post.)
· What Is Excel? How Do We Use It in Data Validation?
· Step by Step: How to Prepare A Test Data Set in Excel?
· What Is an XML File? How Do We Use It in Data Validation?
· Step by Step: How to Import an XML File to Excel?
· Step by Step: How to Export an XML File from Excel?
· What Is an XSD File? How Do We Use It in Data Validation?
· Step by Step: How to Create an XSD File to Validate Data in XML?
· What Is VBA? How Do We Use It in Data Validation?
· Step by Step: How to Write A VBA Code to Copy Data from One Sheet to Another in Excel?
· Step by Step: How to Write A VBA Code to Check Valid Cell Values in Excel?
Throughout the series, we are going to give brief descriptions about Excel, XML, XSD and VBA. Along with that, we will give some examples that you can use and apply to your work as well.
Note: You can also check this blog post and some other interesting topics on my personal web page.
