Course Content

Course Content

Description

How to create MS Excel formula

 

Now we will see the most important feature of MS Excel that is 'Formula'.

 

Formula is usually use to make our work easy.

 

As on our screen there are different sales and expenses of different months, and now we want to calculate the profit, so for that we will just write the formula for it by using cell's location.

 

For example, cell b2=180, and cell b3=160, than we write tye formula as '=b2-b3' on our desirable cell where we want the answer of it.

 

Now suppose if you want to total the sales row, so for that we will use the pre inserted functions in MS Excel. There are total of 450 functions available in Microsoft Excel.

 

So to get the total of all the sales rows, we will write '=sum(' and then select all the column and then after click on any different cell. We will notice that the total of all will be shown in the cell where we entered the formula.

 

Similarly we can use average formula to count average of all the cells which we want.

In this course you will learn how to build Basic and Advance Formulas for MS EXCEL with Easy to Understand Videos in Hindi.

FAQs

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere