MicroSoft Excel Ki Jankari | माइक्रोसॉफ्ट एक्स्सेल की जानकारी | Use Kaise Kare


  • Free Recharge on Mobile - Download RichCash
Free Mobile Recharge Kaise Kare
MicroSoft Excel Ki Jankari | माइक्रोसॉफ्ट एक्स्सेल की जानकारी | Use Kaise Kare
MicroSoft Excel Ki Jankari Hindi Me

Humare aaj ke iss lekh ka topic hain Microsoft excel ki jankari. Aaj kal toh har koi inn cheezo ke bare main jankari rakhta hain lekin jin logo ko inn bare main jankari nahi hain unn logo ke liye hi hain humara aaj ka yeh special lekh. Toh jo log Microsoft excel ke bare main detail main jankari hasil karna chahte hain unn logo se hum yeh request karte hain ki aap log humare iss lekh ko dhyan se padhe aur Microsoft excel ke bare main detail main jankari jutakar apne gyan ke bhandar ko aur jada unnit kar lijiye.

MicroSoft Excel Ki Jankari – माइक्रोसॉफ्ट एक्स्सेल

Microsoft Excel ek spreadsheet hai jise Microsoft company dwara nirmit kiya gaya hai. Isay calculation ke liye, Graph banane ke liye, Macro programming ke liye use kiya jaata hai. Ismay aadi line ko “Rows” kaha jaata hai aur Khadi hui line ko “Column” kaha jata hai. Yeh Rows aur Column aapas mein katte huye cell banate hain. Excel mein 256 Columns aur 65536 Rows hoti hain. Is pure area ko worksheet kehte hai. Excel ki file ka format (.xls) hota hai.

Waisay to Excel window operating system support karta hai yani is par mouse chalta hia aur mouse ke dwara aap ismay kuch bhi activity kar sakte hai par iskay aalwa excel mein kuch keyboard shaortcuts hota hain. Yani jo kary aap mouse se karte hain wahi keyboard dwara bhi kar sakte hain tatah keyboard shortcuts se aapki speed badh jaati hai. Aaiye jaane keyboard shortcuts ke baare mein.

Microsoft excel ki jankari

Agar aapko cell address, cell range ke bare main basic jankari nahi hain toh aap pahle excel ke basic tutorial read kare. Taki aapko excel ka basic samajh main aa jaye. Excel ek bahut hi badhiya software hain jis main ek se badhkar ek features hain auto fill.

Auto fill — Auto fill excel ka ek ayesa feature hain jis main agar humne pahle se koi formula use kiya hain aur usse hum auto fill karte hain toh hume woh formula dobara use karne ki zarurat nahi padti. Hum aapko kuchh ayese example de rahe hain jisse aap logo ko auto fill kya hain yeh easily samajh main aa jayega.

Maan lijiye humne kisi month ka name type kiya hain toh uss cell ke corner main click karke usse niche ki or khichna hain. Toh aapne jis month ka name type kiya hain uske baad ke sare month ke names automatically type ho jayenge.

Agar humne 2 type kiya hain aur uske niche wale cell main 4 type kiya hain aur auto fill karte hain toh uske niche wale cells main automatically 2 ki series ban jayenge.

Sum (addition) formula — Agar aapko addition karna hain toh aap sum ka formula use kar sakte hain.

Formula – sum(cell address first number ka, cell address second number ka) or sum(cell range).

Aur agar aap logo ko ek sath bahut se cells ke number ko addition karna hain toh aap log toh aapko cell range select karni padegi.

Multiple — Agar aapko multiple karna hain toh aap product(number 1, number 2, number 3).

Max — Agar aapko kuchh number main se sabse bade number ko choose karna chahte hain toh aap iss formula ko use kariye.

Formula — Max(cell range).

Min — Agar aapko kuchh number main se sabse chhote number ko choose karna hain toh aap iss formule ko use kariye.

Formula — Min(cell range).

Average — Kisi bhi field ka agar aapko percentage nikalna hain toh aap average ke formule ko use kar sakte hain. Iske liye aap niche diye gaye formule ko use kariye.

Formula – Average(cell range).

Length — Agar aapko kisi bhi name ka lenth count karna hain toh aap iss formule ko use kariye.

Formula — Len(cell range).

  • Free Recharge on Mobile - Download RichCash
Free Mobile Recharge Kaise Kare

Upper — Agar aapko kisi bhi name ka case change karna hain ya agar aapko kisi name ke small letters ko capital letter main convert karna hain toh aap iss formule ko use kariye.

Formula — upper(cell range).

Excel File ke liye keyboard shortcuts

Nai excel book banane ki liye “CTRL+N” press kare.

Kisi file ko open karne ke liye “CTRL+O” press kare.

File ko save karne ke liye “CTRL +S” press kare.

File ko save as option se save karne ke liye “F12” press kare.

File ko print karne ke liye “CTRL+P” press kare.

File ka print preview dekhne ke liye “CTRL+F2” press kare.

Excel close karne ke liye “Alt +F4” press kare.

Excel mein kam karne ke kuch shortcuts.

Kisi karya ko kar diya, hai usay nahi karne ke liye(Undo)  “CTRL+Z” press kare.

Kisi karya ko phir se karne ke liye (Redo) “CTRL+Y”  press kare.

Sabhi cell ke select karne ke liye “CTRL+A”  press kare.

Cell ko copy karne ke liye pehle us cell ko select kar len aur phir “CTRL+C”  press kare.

Cell ko cut karne ke liye pehle us cell ko select kar len aur phir “CTRL+X” press kare.

Cell ko paste karne ke liye jahan paste karna hai wahan cursor le jaayen aur phir CTRL+V press kare.

Kisi cell ko Find and Replace karne ke liye “CTRL+F” press kare.

Puri ek Row ko select karne ke liye pehle cursor us row mein rakhen aur phir “Shift+Space bar” press kare.

Pure ek colume ko select karne ke liye pehle cursor us column mein rakhen aur phir “CTRL+Space bar” press kare.

Ek nai woksheet mein chart banane ke liye “F11” dabayen.

Table insert karne ke liye jahan table insert karna chahte hain wahan cursor le jaayen aur phir “CTRL+T” press karen.

Table ki row select karne ke liye pehle cursor table ki us row mein rakhen aur phir “Shift+Space bar” press kare.

Table ke column ko select karne ke liye pehle cursor table ke us column mein rakhen aur phir  “CTRL+Spacebar” press kare.

Pura table select karne ke liye pehle crsor us table mein kahin rakhen aur uskay baad  “Ctrl+A” press kare.

Excel mein cursor ko move karane ke liye Shortcuts.

Screen par cursor ko us page ke upar le jane ke liye “Page up” button press kare.

Screen par cursor ko us page ke niche le jane ke liye “Page down” button press kare.

Screen par page ke right side par jaane ke liye “Alt + Page down” button press kare.

Screen par page ke left side par jaane ke liye “Alt+Page up” button press kare.

Worksheet ke last cell par jaane ke liye “CTRL+End” press kare.

Worksheet ke first cell par jaane ke liye “CTRL+Home” press kare.

Kisi sentence ke pehle cell par jaane ke liye us sentence par cursor le jaayen aur “Shift+Home” press kare.

Kisi sentence ke antim cell par jaane ke liye us sentence par cursor le jaayen aur “Shift+End” press kare.

Cell ki farmating ke liye shortcuts

Kisi cell ko Bold karne ke liye us cell ko select karen aur “CTRL+B” press kare.

Kisi cell ko Italic karne ke liye us cell ko select karen aur “CTRL+I” press kare.

Kisi cell ko Underline karne ke liye us cell ko select karen aur “CTRL+U” press kare.

Kisi cell ko center align karne ke liye “Alt+H+A+C” press kare.

Kisi cell ko left align karne ke liye “Alt+H+A+L” press kare.

Kisi cell ko right align karne ke liye “Alt+H+A+R” press kare.

Toh dosto aap logo ko samajh main aa gaya na humare lekh main diye gaye kuchh lines. Toh ab confusion kaisa, agar aap logo ko Microsoft excel ke bare main thodi bahut jankari hain toh aap log humare aaj ke iss lekh ko padhkar apni uss jankari ko confirm kar lijiye aur agar bilkul jankari nahi hain toh iss lekh ko padhkar aap log Microsoft excel ke bare main puri jankari hasil kar lijiye.

How To Increase Computer Speed?**

What's Your Reaction?

Love It Love It
4
Love It
Like It Like It
0
Like It

MicroSoft Excel Ki Jankari | माइक्रोसॉफ्ट एक्स्सेल की जानकारी | Use Kaise Kare

log in

reset password

Back to
log in