How Excel Is Used in Real-World Data Analysis

Fidelis Tuwei — Sat, 13 Jun 2026 17:48:43 +0000

Before I thought Excel was just something accountants use to make tables look neat. I was wrong — quite embarrassingly wrong, actually.

This changed how I see spreadsheets entirely. Excel isn't a glorified notepad. It's a proper analytical tool that businesses use daily to make real decisions. Let me share what I've learned and how it connects to the real world.

What even is Excel?
Microsoft Excel is a spreadsheet application that lets you store, organize, calculate, and visualize data. It's been around since the 1980s, but it's still one of the most widely used tools in business today — and after this week, I understand why.

Three ways Excel drives real-world decisions

Financial reporting and budgeting

Finance teams use Excel to track revenue, expenses, and projections. A simple sheet with the right formulas can show a business whether it's on track for the quarter or heading toward a loss — without needing custom software.

Sales and marketing performance

Marketing analysts pull campaign data into Excel, then slice it — by region, by product, by period — to figure out what's working. A pivot table can turn 10,000 rows of messy data into a clean summary in about thirty seconds. I've now seen this myself, and it's genuinely impressive.

Inventory and operations tracking

Retail and e-commerce businesses use Excel to track stock levels, pricing, and supplier data. When I looked at our course dataset — product listings from Jumia with prices, discounts, and reviews — I immediately saw how a business would use something like this to decide which products to promote or discount further.

Three Excel features I've started using
The formula that stopped me in my tracks was VLOOKUP. It lets you search for a value in one column and pull related data from another — like a lookup table. Useful for matching product IDs to product names, for example.

Then there's SUMIF **and **AVERAGEIF, which let you calculate totals or averages based on a condition. Want the average rating only for products discounted above 30%? There's a formula for that.
Pivot Tables have been the biggest unlock for me. You drag fields around and Excel reorganizes the entire dataset into a summary. No code, no formulas — just drag and see patterns. It feels almost unfair how fast it is.

A personal reflection
Honestly, what's changed for me is that I now look at a spreadsheet and see questions rather than rows. When I opened the Jumia dataset for our assignment, my first instinct wasn't "this is a lot of data." It was "what does this data want to tell me?"

That shift — from passive observer to curious analyst — is what Week 1 has given me. I'm only just getting started, but I can already see how much is possible with a tool most people take for granted.

If you're also just starting out with data analysis, don't underestimate Excel. It's worth learning properly.

DEV Community: Fidelis Tuwei

How Excel Is Used in Real-World Data Analysis