Introduction to MS Excel for Data Analytics

Microsoft Excel is one of the most powerful and accessible tools for basic data analysis. Data analysis is the process of collecting, cleaning, organizing, and making sense of information to help you make better decisions.

Microsoft Excel is a spreadsheet that allows you to:

1. Organize your data
   
   The Header row data is categorized into Employee ID, First name, Last name, Department and Salary.

2. Clearing and Explaining Data
   Sort & Filter are tools used for cleaning and exploring.
   
   Go to the data tab and Click filter and then select any category you want e.g Department (HR and Finance) and you will only see data from the checked category.

Clearing data by use of Remove duplicates

Basic calculations using formulas

=SUM(E2:E12)     Total Salary
=AVERAGE(E2:E2)  Average Salary
=COUNT(E2:E12)   No. of Values
=MAX(E2:E12)     Highest salary
=MIN(E2:E12)     Lowest salary  

![ ](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tv4m98w841pz33bl3i7t.png

Creating and visualization of charts

Use of pivot tables

Creation of charts

Conclusion

Excel is a essential in data analytics by learning how to organize data, apply formulas, create charts and use pivot tables.