MICROSOFT EXCEL
Definition this is one of the most used tools in the corporate world to store clean and organize data .in ourcase we will be using it in a data analytics point of view and how it can help and simplify our analysis
EXCELS INTERFACE AND FUNCTIONS
Once you open your Microsoft excel you will have to know the difference between a Row , column , and a cell
The picture below illustrates more
column this is the highlighted part of the worksheet that goes downwards
row this is the highlighted part of the worksheet that goes across
cell this is where the row and column meet and its where we record our data
BASIC FUNCTIONS IN MS EXCEL
We use functions to simplify on finding certain values easily with no struggle when dealing with large datasets
There are various common functions that are the mostly used in excel that a beginner should grasp when starting off
listed below are various functions used and will further explain some of them
. SUM
. AVERAGE
. COUNT
. COUNTA
. COUNTIF
. SUMIF
. MAX
. MIN
. IF
SUM
This function is basically for doing the normal addition of numbers
that we do on a normal maths class or on our day to day life while counting our money
below is the formula used for sum
Above is the total bonus of all employees using the SUM formula
AVERAGE
This formula helps you find the mean performance for any column in a data
as illustrated below
so we basically calculated the average age of the employees
MAX
This basically identifies or finds the highest performance
In the above screenshot we were looking for the max of the project count column
IF
This makes decisions of classifies data in different categories
for example you can decide to promote or demote different personnel according to a certain performance
Above screenshot describes that if a certain employee project count is 15 or less than 15 is retained at the position and those above 15 will be promoted
COUNTIF
This formula helps in counting how many cells meet a condition that you specifically want
for example we can decide to count how many peoples project count were above 15
This shows that 186 people's project count were above 15
CONCLUSION
This are just a few of the basic functions as a beginner you should know.
Take time to learn on the other functions listed and many more
All it takes is practice and you will have fun analyzing any data
Thats it for my beginner friendly introduction to excel
ADIOS
Top comments (0)