MS Excel kaise use kare -: Excel use kaise kare in hindi.

Ms Excel Microsoft Office ka hi ek software hai jo computer me sabse jyada use kiye jane wale software me se ek hai. Ms excel ek tarah ka spredsheet program hota hai. isme hum badi hi aasani se table create kar sakte hai aur koi bhi bada se bada mathematical calculation kar sakte hai. Excel ki adhik jankari ke liye excel kya hai hamari is post ko padh sakte hai.
Excel kaise use kare

Excel use kaise kare complete jankari

Aaj hum Excel kaise use karte hai iske bare me janne wale hai jisme hum ise sabhi tab jaise ki home, insert, page layout, developer aur baaki sabhi tools ke bare me detail se janenge. Humne niche ek table banaya hai isme hamne sabhi title de diye hai ki hum is article me aapko kya-kya batane wale hai.

Excel kaise use  kare puri jankari
Excel kaise open kare
home tab ki jankari
Insert Tab ki jankari
Page Layout Tab
Excel Formulas ki jankari
Data Tab in Excel
Review Tab ke bare me
Excel me View Tab
Developer Tab ki jankari

Computer me ms excel open kare

Ms Excel ko use karne me sabse pahle hum ise open karne ke bare me janenge kyoki bahut sare logo ko excel open karna bhi nahi aata hai. Excel open karne ke liye vaise to kai sare tarike hote hai. Aapko bhi agar excel open karne ka tarika janna hai to niche diye read more par click karke aap hamari excel kaise open kare is post ko padh sakte hai. Yaha par hamne detail se excel open karne ki jankari share kari hai.


Home Tab in Excel

Excel use karne ki shuruat hum excel ke home tab se karenge. Excel ke home tab me hame 7 sub tabs ya groups dekhne ko milte hai.  Jaise ki - ClipboardFont Alignment, Number, Styles, Sales, Editing, copy, paste aur cut iske alawa Format Pinter, Tex decoration, margin, shading, text wrapper highlights, text ke liye numbering jaise bahut sare option home tab me dekhne ko milte hai.Jinka use hum ka sakte hai.

Insert Tab ki jankari

Excel me dusri tab hume Insert ki milti hai. Insert tab me total 5 Group hoti hai. Jaise- Table, Illustration, Chart, Link, Text.  Jinme kai tarah ki alag-alag option milte hai jinki help se hum Excel sheet me Table, Image, Clip art, Shapes, Smart Art, Sheet ko aasani se samjane ke liye Chart formats, Links, Word art, Symbol aadi milte hai. Jinki help se hum badi hi aasani se Excel sheet me kisi bhi other object ko sheet me dal sakte hai.

Page layout tab in excel

Excel me Page layout Tab, Is tab me hume Total 5 Group dekhne ko milte hai. Jaise- Theme, Page setup, scale to fit, Sheet option, Arrange. Jinki help se hum Excel sheet ki Theme ko change kar sakte hai. Sath hi Page Setup ki help se hum Excel sheet print karne ke pahle Printable area kar sakte hai. Aur sirf selected area ko hi print kar sakte hai. Sheet ke liye Background bhi set kar sakte hai. Arrange option ki help se Inserted object ko arrange- Bring, Front bhi kar sakte hai. 

Excel me Formula lagaye

Excel me Text function formula me aapko 25 tarah ki alag - alag command dekhne ko mil jayegi jinka use bhi different tarike se hi hota hai. Isme sabse pahli command Find hoti hai jiska kaam hota hai ki kisi word ki kya position hai wo kon se number par hai iska pata lagaya jata hai. Jaise ki Lucky me c kitne number par hai. Iske alava Function library me Financial, Logical, Lookup & Reference, Math & Trig ke function formula milenge. Inke baare me aur adhik janne ke liye Read more par click kare.

Excel Data tab ki jankari

Data tab ka use, banayi gayi sheet ke data ko analysis karne ke liye kiya jata hai. Isme 5 Group hote hai. Data tab ki Sort ka use karke Data ko sequence me aur filter ka use karke sirf specific category ke data ko dekh sakte hai. Data validation, Consolidate, What if analysis, Outline group Excel data analysis ko aur bhi powerful bana deta hai. Inki help se hum 2 sheet ke data ko ek sheet me, Maths tricky question solve, Selected cell ke liye data ki limit ko set kar sakte hai. Agar aap chahte hai ki Sheet me 4000 aur 10,000 ke bich ki value hi enter ho sake. To, aap Data validation se esa kar sakte hai. 

Review tab ki jankari

Data tab ka use, banayi gayi sheet ke data ko analysis karne ke liye kiya jata hai. Isme 5 Group hote hai. Data tab ki Sort ka use karke Data ko sequence me aur filter ka use karke sirf specific category ke data ko dekh sakte hai. Data validation, Consolidate, What if analysis, Outline group Excel data analysis ko aur bhi powerful bana deta hai. Inki help se hum 2 sheet ke data ko ek sheet me, Maths tricky question solve, Selected cell ke liye data ki limit ko set kar sakte hai. Agar aap chahte hai ki Sheet me 4000 aur 10,000 ke bich ki value hi enter ho sake. To, aap Data validation se esa kar sakte hai. 

view tab ki jankari

Data tab ka use, banayi gayi sheet ke data ko analysis karne ke liye kiya jata hai. Isme 5 Group hote hai. Data tab ki Sort ka use karke Data ko sequence me aur filter ka use karke sirf specific category ke data ko dekh sakte hai. Data validation, Consolidate, What if analysis, Outline group Excel data analysis ko aur bhi powerful bana deta hai. Inki help se hum 2 sheet ke data ko ek sheet me, Maths tricky question solve, Selected cell ke liye data ki limit ko set kar sakte hai. Agar aap chahte hai ki Sheet me 4000 aur 10,000 ke bich ki value hi enter ho sake. To, aap Data validation se esa kar sakte hai. 

Developer tab- Secret Tab

Developer tool ek hidden tool hota hai ye pahle se excel me nahi hota hai ise hume excel me lana padta hai. Isme 5 Group hote hai. Data tab ki Sort ka use karke Data ko sequence me aur filter ka use karke sirf specific category ke data ko dekh sakte hai. Data validation, Consolidate, What if analysis, Outline group Excel data analysis ko aur bhi powerful bana deta hai. Inki help se hum 2 sheet ke data ko ek sheet me, Maths tricky question solve, Selected cell ke liye data ki limit ko set kar sakte hai. Agar aap chahte hai ki Sheet me 4000 aur 10,000 ke bich ki value hi enter ho sake. To, aap Data validation se esa kar sakte hai. 

In Conclusion

Finally is post se aapko MS Excel me tabs kaise use kare iski jankari to ho hi gayi hogi abhi bhi excel ke bare me janne ke liye bahut kuch bacha hai Hum keval ek post me excel to sikh nahi sakte hai. Excel se judi chijo ke bare me hum aage bhi janenge isliye aap hamari website ke sath jude rahe. Excel ki jankari ke liye aap abhi hamari website ko subscribe kare. Hamne niche bhi excel see jude kuch behtrin article share kiye jinhe aapko padhana chahiye.

No comments:

Post a Comment

apna comment kare