FIRSTWEEK OF DIVING INTO EXCEL AND IT'S FUNCTIONS IN REAL WORLD.

Fabian Kirui — Sun, 07 Jun 2026 14:19:50 +0000

My first time learning excel was taught to be much harder in terms of cleaning and organizing large data at once. After one week of learning excel, it came to my understanding that there are basic functions that makes it easier to organize and clean data easily. Functions such SUM, AVERAGE, MINIMUM, and MAX are now easy to work with since i have some clue. More of these functions are as follows:
IF(),AND(),IFAND(),SUM(),MAX(),COUNT(),COUNTIF(),HLOOKUP(),INDEX()TRIM().

WHAT IS EXCEL?

Excel is a powerful spreadsheet software program developed by microsoft. It's main fuctions is to;
_ collect, organize, analyze, calculate, and visualize data accurately.
Data cleaning using excel has made me achieve a well sorted and organized data suitable for working with in any given field.

Excel is mostly used in:

Financial institutions - Financial analysts uses excel to evaluate investments opportunities and forecast economic trends.
Data analysis - Data analysts extract and clean raw data, create dashboards and identify business weak points.
Sales analysis - supermarkets uses excel to analyze daily, weekely and monthly sales trend which helps in identifying most and least sold products and calculations of revenues. for example:

With the above image, you can find out the difference between the current price and the old price basically through a simple basic function [=C2-B2].

CONCLUSION

Before learning Excel, data felt like a bunch of random numbers. But now, I see that data tells a story. With Excel, I can organise numbers, find patterns, and understand what the data is saying. It has helped me become more confident in working with information, and I now enjoy finding answers by just using a few simple formulas. Learning Excel has shown me that even simple tools can make a big difference when it comes to understanding data.

DEV Community: Fabian Kirui

FIRSTWEEK OF DIVING INTO EXCEL AND IT'S FUNCTIONS IN REAL WORLD.

WHAT IS EXCEL?

Excel is mostly used in:

CONCLUSION