How Microsoft Excel is Used in Real-World Data Analysis

EXCEL

Definition:Microsoft Excel is a spreadsheet program developed by Microsoft that allows you to Collect, Organize, analyze and visualize data using tables and charts.

Through examples I will explain to you on how data analysts' use Ms Excel on the day to day basis when working with datasets

DATA ORGANIZATION

Many companies deal with very large amounts of data and when it comes to organizing and cleaning the data, thats where Excel comes in.
Many data comes very messy ,unstructured and with missing values and it needs to be formatted and cleaned to get better structured datasets for analysis
WAYS TO FORMAT AND CLEAN DATA

One of the ways to clean your data is by Remove duplicate
To remove duplicates you simply Select your dataset, go to the Data tab
click Remove Duplicates
below is an example

changing columns to their respective data types

Data analysis with formulas

Excel allows users to perform calculations quickly
Below are the different types of formulas used in excel by majority of data analyst
COUNTIF
Is a function used to count the number of cells that meet a specific condition.

SUMIFS this is mostly used while dealing with multilple columns

Pivot tables

PivotTables are one of Excel’s most powerful features that help in
summarizing large datasets, grouping data by categories and compare trends

Data visualization

Excel can turn raw data into charts:

Bar charts → compare categories
Line charts → track trends over time
Pie charts → show proportions

CONCLUSION

Excel is so popular because its easy to learn but very powerful
and it works for small and large datasets with no coding required (but supports it) but most important of it is widely used across industries