Ghar baithe online MS Excel Functions kaise seekhe in Hindi

0
63
MS Excel Functions

Yeh Article Hindi mein Padhne ke liye Yahan Click Kare

MS Excel ek tarah ka calculator hota hai. Excel mein bahut asani se calculations ki jaa sakti hai. Chahe kitna bhi badha data ho par excel ki help se kuch seconds mein hi sab calculations ki jaa sakti hai. Iss article ko padhke ghar baithe aap MS Excel functions seekh sakte hai.

Iss article mein aap asani se MS Excel functions seekh sakte hai:

Mathematical functions

Statistical functions

Logical Functions

Text functions

Other functions

MS EXCEL FUNCTIONS

MS Excel functions ke liye ek formula hai joh har calculation mein use kiya jaata hai:

=formula(Value 1, Value 2, Value 3, …… Value 20) press ENTER

 

Values do style mein daal sakte hai:

  • Cell range

=formula(A1:A10) press ENTER

For example: =sum(A1,A2,A3,………..A20) press ENTER 

or, =sum(A1:A20) press ENTER

Iss formula ka use karke humne A1 cell se lekar A20 cell tak ke numbers ko add kardiya hai.

 

  • Individual cell

 

Iske alava symbols ka use use karke bhi calculations ki jaa sakti hai

=Value1symbolValue2 press ENTER

For example: =12+34 press ENTER

=Value1symbol(Value2symbolValue3) press ENTER

For example: =1+(2*6) press Enter

Inn calculations mein hume sabse pehle BODMAS ka concept lagana hoga joh hum sabne school mein sikha tha.  

Inme se agar aap ek hi factor miss kardenge toh aapko calculation ka result nahi milega.

Ek baat ka khas dhyan rakhe ki agar aapne ek barcket ko open ( kia hai toh use close ) karna na bhule.

LIST OF MS EXCEL FUNCTIONS

1. Mathematical Functions
  • SUM: Cell range ka sum (addition) karne ke liye
SUM (CELL RANGE) =sum(cell range) =sum(A1:A10)

 

  • SUM: Alag alag cell ka sum (addition) karne ke liye
SUM (INDIVIDUAL CELL) =Value1+Value2 =A1+A2

 

  • SUMIF: Cells ka sum karne ke liye par jisme ek criterion ho
SUMIF =SUMIF(cell range,”criterion”) =SUMIF(A1:A10,”>8”)

 

 

  • SUMIFS: Cells ka sum karne ke liye par jisme ek se zayda criterion ho
SUMIFS =SUMIFS(cell range,”criterion1”,”criterion2”) =SUMIFS(A1:A10,”red”,”>8”)

 

Sum ke aur fuctions ke liye yaha click kare

  • Subtraction: Cells ko subtract karne ke liye
Subtraction =Value1-Value2 =A1-A2

 

  • Multiplication: Cells ko multiply karne ke liye
Multiplication =Value1*Value2 =A1*A2

 

  • Divide: Cells ko divide karne ke liye
Divide =Value1/Value2 =A1/A2

 

  • COUNT: Cells ko count karne ke liye
COUNT =COUNT(cell range) =COUNT(A1:A30)

 

  • COUNTIF: Cells ko count karne ke liye par jisme ek criterion ho
COUNTIF =COUNTIF(cell range,”>criterion”) =COUNTIF(A1:A10,”>7”)

 

  • COUNTIFS: Cells ko count karne ke liye par jisme ek se zayda criterion ho
COUNTIFS =COUNTIFS(cell range,”criterion1”,”>criterion2”) =COUNTIFS(A1:A10,”red”,”>7’)

 

 

2. Statistical formulas
  • AVERAGE: Cells ka average calculate karne ke liye
AVERAGE =AVERAGE(cell range) =AVERAGE(A1:A30)

 

  • AVERAGEIF: Cells ka average calculate karne ke liye
AVERAGEIF =AVERAGEIF(cell range,”criterion”) =AVERAGE(A1:A30,”<>1”)

 

  • MEDIAN: Cells ka median calculate karne ke liye
MEDIAN =MEDIAN(cell range) =MEDIAN(A1:A10)

 

  • MODE: Cells ka mode calculate karne ke liye
MODE =MODE(cell range) =MODE(A1:A10)

 

  • STANDARD DEVIATION: Standard deviation calculate karne ke liye
STANDARD DEVIATION =STDEV(cell range) =STDEV(A1:A10)

 

  • MAX: Maximum value (sabse badhi value)  dhundhne ke liye
MAX =MAX(cell range) =MAX(A1:A10)

 

  • MIN: Minimum value (sabse chothi value)  dhundhne ke liye
MIN =MIN(cell range) =MIN(A1:A10)

 

Max or min ko detail me sikhne ke liye yaha click kare

 

  • LARGE: Third/Fourth, etc.. Largest value (sabse badhi) dhundhne ke liye
LARGE =LARGE(cell range,value) =LARGE(A1:M1,4)

 

  • SMALL: Second smallest value (second sabse chothi) dhundhne ke liye
SMALL =SMALL(cell range,value) =SMALL(A1:M1,3)

 

 

  • RANK: Cells ko rank (order) mein karne ke liye

Descending order

RANK =RANK(number,ref,[order]) =RANK(B1,$B$1:$B$9)

 

Ascending order

RANK =RANK(value, cell range,1) =RANK(B1,$B$1:$B$9,1)

 

  • Number : cell ka number
  • Ref: number ko pure list of numbers se compare karna $B$1:$B$9. Cell range select karne ke liye $B1:$B$9 ka use kare taaki range same rahe jab aap formula ko neeche copy karenge
  • Order: aapko list kis order mein chahiye ascending ya descending
  • Descending: Zero use kare ya blank chodh de. Eg: ($B$1:$B$9)
  • Ascending: One (1) ya koi bhi number use kare  zero ke alvaa ($B$1:$B$9,1)

Rank function ko detail mein sikhne ke liye yaha click kare

3. Logical Functions

  • IF: IF function check karta hai ki condition puri hui hai ya nahi aur result me ek value ‘True’ hoti hai vo dusri ‘False’.
IF STATEMENT =IF(logical test, “result if the test answer is true”, “result if the test answer is false”) =IF(B2>69,”Pass”,”Fail”)

 

  • EXACT: EXACT function do values ko compare karta hai aur agar dono values same hai toh result ‘True’ hota hai aur agar ek vaue alag hai toh ‘False’ result deta hai
EXACT =EXACT(Value1, value2) =EXACT(B2, C2)

 

  • AND: Agar dono criterion match hote hai toh ‘True’ result hota hai aur agar ek bhi criterion match nahi karta toh ‘False’ hota hai.
AND =AND(Value1,criterion, value2,criterion) =EXACT(B2>30, C2>35)

 

Logical functions ki list dekhne ke liye yaha click kare

4.Text functions

  • JOIN STRINGS: Alag alag cells ke text ko saath me jodhne ke liye
JOIN STRINGS =value1 & “ “ & value2 =A1 & “ “ & B1

 

  • LEFT: Cell ke left side ke characters ko sort karna
LEFT =LEFT(Value1, number of characters) =LEFT(B2, 3)

 

 

Text function ke saare functions ke liye yaha click kare

Excel ke saare functions ko acche se seekhane ke liye yaha click kare 

Excel ko detail mein seekhane ke liye aapko acche se practice karni hogi. Saare functions ko examples ke saath practice kare.

MS Excel ke basics aur MS Excel shortcuts ke liye yaha click kare.

Agar aapko Excel se judhi aur koi jaankari chahiye toh niche comment mein hume likhe. Hum aapko jawaab dene ki puri koshish karenge.

LEAVE A REPLY

Please enter your comment!
Please enter your name here