Excel is a Microsoft product. It is very essential
for data analysis. By using Excel, we can do thousands of things. But, we need
to know the very basics so that we get going. First, we need to learn addition,
subtraction, multiplication and division.
Then we need to go upwards by using power function and other complex math
function. Actually, it reduces the task of a person. It reduces human error.
Once you have made an excel sheet for analysis or doing a problem, you can get
the results simply by changing the data. That is very easy. I will show you
this in a video. Go through it and learn it.
Using sum function
The sum function is
very important to add numbers in a row in Excel. This function will be shown in
the video. In the example, three students are taken. Their six subjects are given. Our motive is to find the sum of marks obtained in six subjects and then to find the percentage. This is a simple example. You can use this technique for your other problems.
Using average function
This function
helps to find the average. Suppose you have marks for 6 subjects of a student.
You need to find the average marks. Then we will use this one. You need to know
how to find this and use it according to your requirement.
NOTE: This page is continuously updated to include new things in Excel required for your needs.
