MS Excel Lecture

What Is Excel Formulas

what is excel formulas in hindiDear Students, aaj ke is Lecture me hum what is excel formulas ke bare main bat karege. Yani ke excel formulas kya hai or excel formulas kaise kaam karte hai. Types of excel formulas aadi se related ye sare topic ham is lecture main cover karege.

Lectures Covering Topics

  • Introduction To Excel Formulas In Hindi
  • What Is Excel Formulas In Hindi
  • Some Important Excel Formulas In Hindi
  • Advantages Of Excel Formulas In Hindi

Microsoft excel bahut he powerful application hai. Yah numbers ko calculate karta hai. Excel aapko kuch second main he aapki badi se badi columns, rows ka total, average count aadi karke deta hai.

Introduction To Excel Formulas In Hindi

Dekha jaye to Microsoft excel ki spreadsheet ko eak program ke roop me design kiya gya hai. Excel mian numbers ko calculate karne ke liye hame bahut sare formulas provides kiye gye hai. Lekin ham yan bat kar rahe hai what is excel formulas ki yani ke excel ke formulas ki aakhir kya hai ye excel formulas.

To excel formulas ka matlab hai eaise formulas jo excel ki spreadsheet main calculation karne ke kaam aate hai. Unhe hum excel formulas kahte hai. Jaise numbers ko count, multiply, subtraction, addition etc.

Bese to ye kaam aap khud se bhi karsate ho. Lekin data hamara chhota hai to theek hai. Agar hamara data bada hai to khud se karne ke liye hame bahut time lagega. Excel se in kaamo ko karne ke liye hame kuch second ka time lagta hai. To aisa karne ke liye hame seekhna padega what is excel formulas ke bare main to chaliye padte hai excel formulas ke bare mian.

What Is Excel Formulas – Excel Formulas Kya Hai In Hindi

Students agar hum excel main kaam karte hai. Kisi firm aadi ka account or stock maintain karte hai. To aap excel main uska data feed karte hai. Kabhi total selling karte hai to kabhi total purchasing karte hai. agar hum ye kaam self calculate karke likhte hai.

To ye tareeka sirf aapko result sahi dega lekin aapka time bahut west karega. Apne time ko bachane ke liye ham seekhenge what is excel formulas ke bare mian. Excel formulas ka use karke hum apne time ko bacha sakte hai. Excel formulas ke help se hum sirf apni calculation ko eak bar karte. Or excel formulas us calculation ko bar bar use kar sakte hai.

Excel formulas un range ko set kar lete hai. Jinme hume calculation karni hoti hai. Fir hum us range ke andar data mian koi bhi changes karte hai to vah automatic he total kar leta hai. Hame fir se us range ko calculate karne ke jaroorat nahi hoti hai.

Jaise ki agar mene a12 cell se leke a45 cell ko select karke agar values ko sum karte hai. Sum karne ke bad hum is range main koi bhi change karte hai to total bhi apne aap se change ho jata hai. Theekh isi tarah se hum multiply, subtraction, maximum koi bhi calculation karte hai unme bhi auto change ho jata hai.

Some Important Excel Formulas In Hindi

Jab humne what is excel formulas ke bare mian pad he liya hai. To excel main use hone wale important formulas ke bare mian bhi lete hai. Excel mian bahut sare formulas hai jo pahle se define kiye gaye hai. Jinka use excel mian calculation karne ke liye kiya jata hai. Unme se kuch excel formulas aise hai jinka use aam tor par bahut kiya jata hai jiski list mene neeche likhi hai.

  • Sum:- Iska use hum value ko add karne ke liye karte hai.
  • If:- If ka use hum kisi calculation main condition ko dene ke liye karte hai.
  • Count & Counta:- Inka use columns or row ko count karne ke liye karte hai.
  • Maximum & Minimum:- Diye hui values main se maximum or minimum number find karne ke liye usek karte hai.
  • Average:- Average ka use hum kisi column main diye huye values ka average nikalne ke liye karte hai.
  • Trim:- String main extra space ko hatane ke liye hum trim ka use karte hai.
  • Len:- Kisi bhi string ke length count karne ke liye len formula ka use kiya jata hia.
  • And & Or:- Jab hume eak sath one more then condition use karni hoti hai. Ya fir sabhi condition ko ture karne ke liye in dono function ka use kiya jata hai.
  • Concatenate:- Do ya do se jyada text ko join karne ke liye is function ka use kiya jata hai.
  • Lookup;- diye huye poore data main se hum sirf particular kisi eak rows ka data dekhna chahate hai. Uski row ki sirf eak id ke sath tab hum lookup function ka use kate hai.

Multiply, division, mod, root aadi find karne ke liye bhi hum excel formulas ka use karte hai. Excel main bahut sare formulas diye hote hai but upar bataye gaye sare formulas bahut important hai.

Advantages Of Excel Formulas In Hindi

Abhi tak aapne pada What is excel formulas ke bare main abhi hum padege ki excel formulas ke advantages kya kya hai.

  • Excel formulas ki help se hume calculation one time karni hoti hai.
  • Hum excel formulas ki help se calculation ko reuse kar sakte hai.
  • Spreadsheet ki range main hum jo bhi calculate eak bar kar lete hai. Fir uske value ko change karne par us value ke sath ki gayi calculation ka result bhi auto change hota hai.
  • Excel main formulas ki help se calculation bahut essay ho jati hai.
  • Excel formulas ki help se data ko maintain karna bahut essay hota hai.

Note:- Aapko upar sirf important formulas ko he bataya gya hai. Next Lecture main aapko ye formulas details main bataye jayege.

Dear Students, main aasha karta hun ki aapko what is excel formulas Ka Lecture padh kar samjh me aa gaya hoga ki excel formulas kya hai. or excel formulas ka kaise use karte hai. Yadi aapako (what is excel formulas) ke lecture se related koi bhi problem hai to aap hume comment karke puch skte hai.

What Is Excel Formulas Hindi Tags

Excel Formulas Hindi, Excel Formulas With Examples In Hindi, Examples Of Excel Formulas And Functions, Excel Formulas In Hindi, Excel formulas in Hindi PDF, Excel formulas PDF in Hindi.

Share This Post On

About Author

Thakur Aman Singh

Hey, I am Aman Singh Tomar from Taj City Agra. Through This Blog I want to share my Knowledge with all of you. Read More >>

Leave a Reply

Your email address will not be published. Required fields are marked *