I started studying about excel when when i was in high school. Ever since i liked working on excel Excel is a spreadsheet that allows you to analyze, collect, visualize and calculate data.It is mostly used for both professional and personal data management.
Excel consists of elements:
1.Rows -are labelled in numbers(1,2,3)
2.Columns -are labelled in Alphabets (A,B,C)
3.Name box- its show the name of the selected cell(B1)
4.Worksheet tabs -this are found at the bottom(Sheet 1)
5.Cell- is the rectangle formed where a column and a row meet(B1)
6.Data tools-These are tools that are used to manipulate data(sorting, filtering)
7.Functions and formulas- Functions are used to calculate automatically(sum(),Avg() while formulas are instructions given given to perform a piece of data(+,-,*,/)
Excel is used in real world data by analysis by:
1.Data cleaning
Data cleaning helps by splitting combined text, removing duplicates, formatting(find and replace) and ensuring numbers, dates, currency are well formatted.
2.Organizing data
Many companies,schools and hospitals structure its tables using columns(Name,Region,Age,Gender)
3.Business decision
Many business make decisions by planning promotions based on the sale trend and focus on products that makes the most revenue.
Formula makes it easy when calculating values of the cell.In formula you have to start with an (=) or it will not work.Examples of formulas
1.Sum()- we use it to calculate the total values =sum(B2:B14)
2.Avg()-we use it to find the average =Avg(B2:B14)
3.Datedif()- we can use it to find the difference in months ,days and years.Datedif in years =Datedif(C2:C14,"y"),in months =Datedif(C2:C14,"m") and in days =Datedif(C2:c14,"d").
In conclusion excel has helped in me in organizing data, cleaning data, data visualization,how to use new formulas that i didn't study in high school like "datedif","sumif" and "avgif" and the using of tools. Excel has showed how it is meaningful in business.
Top comments (1)
The article needs improvement. The idea is relevant, but the writing has many grammar issues, repeated words, weak sentence structure, and some explanations need to be clearer; please revise the article, organize the points better, and add stronger real-world Excel examples and screenshots before resubmitting.