Basic formulas MIN, MAX and AVG in Microsoft excel by Waseem Web Work

Basic formulas in Microsoft Excel: MIN, MAX, AVERAGE

Today's topic very easy and basic level learning for beginners who did not start learning excel can start learning from our youtube channel Waseem WebWork. This tutorial especially provides you basic concepts of excel formulas. We can find many types of results with the help to excel. Now let see how can we use a different formula in Microsoft Excel.

1: MIN formula: 

In this formula, we find the very lowest value from our data. Use of this formula in Microsoft Excel =MIN(Number 1: Number 2 etc.). For example, we have 1 to 10 numbers and if we use this formula the result will be 1 because of its lowest number in the data.

2: MAX formula: 

With the help of this formula, we can find the maximum or highest value from the available data. Use of this formula like this =MAX(number 1: number2 etc.). For example, we have data 1 to 10 numbers so if we apply this formula the result will be 10 because of the highest number.

3: Average formula: 

With the help of this formula, we can find the average or mean value from the data.
Use of this formula =AVERAGE(number1: number2 etc.). For example, if we have data from 1 to 10 so we can calculate in different ways like one method is that we add all numbers =(1+2+3+4+5+6+7+8+9+10)/10 but the easiest way to find the mean or average look below:

Waseem Web Work

In the below tutorial you can learn practical using of these formulas. watch and share 






Visit our facebook page for further information and don't forget like the page.

Also, visit our youtube channel WaseemWebWork and subscribe to our channel.

How to calculate data in Microsoft Excel? Urdu

Calculation with Basic Functions in Microsoft Excel:

The biggest problem in these to calculate a large number of data without any error/mistakes. If we remind the past and for a minute think that time How the people calculate a large number of data? I think it would be more time consuming and expensive at that time. But recently, the time in which we use computer applications for a different type of works through which we can complete our work or task within a short time than before. 

One of the best applications in Information Technology is Microsoft Excel which is used for calculation in the different departments in the Organization for collecting, sorting, and presenting the data. From collecting to presenting the data each and every step is related to formulas through which we calculate our data in different shapes like Sum, Minus or Subtraction, Percentage, Division, and Multiplication, etc.

One by one now is going to discuss in detail below:

1. Sum 

  

Sum function uses for Adding some data or we can say that plus different figures form the data. For example =1+2+3+4=10, we can calculate this formula in different types in Microsoft Excel but here we are using one of them in below screenshot:

The formula should be like this in Microsoft Excel SUM(number1, [number2], …), instead of numbers 1 and 2 we can use a range of data like in the above screenshot look from C9: D9 means the range from C9 to D9. So we can expand this formula from C9 to Z9 and so on.

2. Subtraction or Minus

As we discussed in the above for Sum Function, we are using the Subtraction function in Microsoft Excel as well. =5-3=2, so the question is that how can we calculate in Microsoft Excel? Look in the below screenshot:

Here in the above screenshot, the function for subtraction is E9-D9 (60-50) which is equal to 10. So it is very simple to calculate subtraction in Microsoft Excel. Visit this link for tutorial related to this topic click here 

This is how you can calculate your data even small or large within a seconds and without omission or commission errors. I hope you will share your opinion about this information.

For further information visit our facebook page click here WaseemWebWork

You can visit our youtube channel click here WaseemWebWork for learning these tips practically and don't forget to subscribe our channel for upcoming videos

For contact us, you can email us click on WaseemWebWork