Excel: A powerful tool for analysis

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.