Data Analyst Journey

  Excel Data Cleaning: A Beginner's Guide In the previous article, we learned what Excel is and why it is important for Data Analysts . But before we can analyze data, there is one important step we need to understand: Data Cleaning. In the real world, data is rarely perfect. It can contain duplicate records, missing values, spelling mistakes, extra spaces, incorrect formats, and many other problems. If we analyze dirty data, our results may be incorrect. In this article, we will learn the basics of data cleaning in Excel and how beginners can prepare messy data for analysis. What is Data Cleaning? Data cleaning is the process of finding and fixing incorrect, incomplete, duplicate, or inconsistent data. For example, imagine we have this customer dataset: Name City    Age        Sales Sanka     Colombo 22 50000 Kasun     Colombo 24 45000 Nimal     Kandy 60000 Sanka     Colombo 22 50000 Amal     Galle 2...

  What is Excel and Why is it Important for Data Analysts? When people think about data analysis, they often think about advanced tools such as Python, SQL, or Power BI. However, one of the most important and widely used tools for working with data is Microsoft Excel . Excel is a powerful spreadsheet application that helps users store, organize, clean, analyze, and visualize data. For beginners who want to become Data Analysts, Excel is one of the best places to start. In this article, we will learn what Excel is, why it is important for Data Analysts, and some of the essential Excel skills you should learn. What is Microsoft Excel? Microsoft Excel is a spreadsheet software developed by Microsoft. It allows users to work with data using rows, columns, cells, formulas, functions, tables, charts, and other features. For example, imagine you have information about 1,000 customers: Customer   Age City     Product Sales John 25     Colombo   Laptop ...