How Excel is Used in Real-World Data Analysis

Grace Njeri — Sun, 07 Jun 2026 09:37:36 +0000

Data analysis is at the heart of how we spot patterns and improve
systems today. Tools like Python, SQL, Power BI, and Tableau are
everywhere in the data world, but Excel has held its ground as the
starting point for anyone getting into data work, and there is a
reason for that.

What is Excel?

Excel is a spreadsheet built on a grid of rows and columns. You use
it to organize, format, and calculate data. For analysts it is where
messy raw data gets sorted out, numbers get worked through, and
everything gets turned into something that actually makes sense to
look at.

Ways Excel is Used in Real-World Data Analysis

1. Data Cleaning

Raw data is almost never clean. Names are misspelled, IDs get
duplicated, spacing is off, values go missing. None of that is
unusual, it is just the reality of working with real data. Before
any analysis happens the data has to be honest, because if the data
is wrong the results will be too.

Functions like PROPER() and TRIM() are some of the basic tools
that help get data into a state where you can actually work with it.

2. Financial Reporting

Every business, big or small, needs to know where the money is
going. Excel makes that straightforward. SUM() adds up a range of
numbers, AVERAGE() finds the mean, and once the calculations are
done the data can be turned into charts and dashboards that tell the
story of the business clearly. Not everyone in the room is an
analyst, but everyone can read a chart.

3. Business Decision Making

Clean data presented well becomes a decision making tool. What do
customers want? What is working? What needs to change? Sorting
figures from highest to lowest or filtering by region can take
thousands of rows and turn them into something focused and
answerable. That is really what data is for, helping people make
better calls.

Excel Features I Have Learned and How They Apply

Three features that have stood out to me are conditional formatting,
data validation, and cell referencing.

Conditional formatting highlights cells based on rules you set yourself. If a number drops below a certain point it turns red. You do not have to go looking for the problem, the spreadsheet shows you.

Data validation controls what can be entered into a cell. Set up
a dropdown list and whoever is filling in the data picks from
approved options only. It keeps things consistent and cuts down on
errors from the start.
Cell referencing is one of those things that sounds complicated
but is pretty straightforward once you try it. A relative reference
like A1 shifts when you copy a formula somewhere else. An absolute
reference like $A$1 stays put. Knowing which one to use and when
changes how you build spreadsheets entirely.

How Learning Excel Changed the Way I See Data

Learning Excel has totally changed the way I see data. It is
particularly interesting when you imagine how human beings have
always been trying to make sense of numbers, figures, and records.
From spreadsheets 1.0, the clay tablets in Mesopotamia used to track
grain harvests, livestock, and taxes, to the Excel we have come to
learn and use in the 21st century, the need has always been the same.

Excel has shown me that data is, in many ways, a form of memory.

Memories of trade, communities, and societies.
Memories that remind us to look into the past and not repeat its mistakes.
Memories that enable us to understand the present.
Memories that remind us to prepare and look into the future with hope.

DEV Community: Grace Njeri