Let's Talk Excel

gikonyo-v — Sat, 06 Jun 2026 14:13:51 +0000

Excel Isn't Just Grid and Tables. Here's What It Actually Does.

First time I opened Excel, I stared at a blank grid of rows and columns and thought what am I supposed to do with this? Up until recently, I've learned how create and analyze data in excel. So, let's talk about it...

What Excel Actually Is
Microsoft Excel is a spreadsheet software that lets you collect, organize, analyze, calculate, and visualize data. The interface looks simple at first, you know, rows running horizontally, columns labeled A, B, C running vertically, and cells where they intersect. But that humble grid is the foundation of some seriously powerful work.

In real life, Excel shows up in:
Financial reporting. Most businesses if not all, use Excel to track budgets, building up income statements, and monitor cash flow. It's powerful isn't just storing numbers, it's the fact that formulas actually update automatically. Change one figure and everything connected to it recalculates stat.

Sorting + filtering data. Imagine you have a ton of customer orders and need to find every sale above KES 1,000 from Beginning of the year or month. Excel's filter feature lets you do that in seconds, you can hide irrelevant rows and show exactly what you need. Even sorting by what you want to work with, be it date, by amount, by region etc., any order you choose.

Tracking and grading performance. Teachers use Excel to manage student scores. With functions like =AVERAGE(), =MEAN(), and =MIN(), a user can instantly find a class average, the mean score, or flag who needs extra support without touching a calculator.

What stuck with me is;

SUM and AVERAGE functions. These were my entry point. Instead of adding numbers manually, =SUM(B1:B5) adds an entire range in one shot. =AVERAGE(B1:B5) gives the mean. Simple, but the moment you see a formula update when you change a cell value, that's when it clicks.

Conditional Formatting. This one was eye opener. You set a rule, say; highlight any score below 50 in red, and Excel does it automatically across hundreds of rows. It turns a wall of numbers into something you can visualize at a glance. I used it to errors, and the thing works like Sherlock Holmes.

Cell References + Dragging. This had me raising an eyebrow at first. When you drag a formula down, Excel adjusts the references automatically. Once I understood this, my formulas stopped breaking in mysterious ways.

It actually changing how I view data.Learning Excel isn't just teaching me a tool, it's changing how I think.

I now look at information differently. A list of sales figures isn't just numbers, it's more than information, it's actual data, waiting to be sorted, filtered, and summarized. A column of names with inconsistent formatting isn't a mess, it is a =PROPER() function away from being clean.

I'm still learning. But I've gone from staring blankly at a grid to actually asking questions and getting answers.
And that's not a small thing.

Which Excel concept surprised you the most when it finally made sense? Drop it below.

DEV Community: gikonyo-v

Let's Talk Excel