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.
Top comments (1)
The article feels like a last minute delivery. The first line of the first paragraph, I had to re-read it multiple times to understand it. Secondly, the font was a bit off. Thirdly, The first paragraph caught me off guard as you packed a lot of information in it. The content in the post has terms such as clean and organize data, what does that mean to you as a data analyst/data scientist. What is the function of the first image, could you breakdown each of those functions written in that image, maybe add some code that takes us through data cleaning and data organization.