1. Introduction

Excel is the post popular data tool that involves entering, validating, cleaning and analysing data

Data cleaning is a very important part of data analysis since it determines the quality of the data. Data cleaning improves accuracy, handles missing data, removes duplicate data and makes data analysis easy.

This article explains the basics of excel and data cleaning.

I will use fictional laboratory dataset for demonstration of basic excel and data cleaning.