Ghar baithe online kaise seekhein MS Excel in Hindi

0
245
Ghar baithe online kaise seekhein MS Excel in Hindi

Microsoft Excel puri duniya mein sabse zyada use kiya jane wala spreadsheet program hai. Excel sabse zyada popular hai for it’s ability to use huge amount of data. Isme bahut sare features and functions hai like from making lists to charts to tracking and organizing information. Iss article mein pehle aap MS Excel in Hindi ke basics ke bare mein seekhenge aur uske baad agar aap use aur acche se seekhna chhate hai toh maine Top 5 MS Excel free courses ke links diye hai. Aap unpe jakar detail me MS Excel seekh sakte hai.

via GIPHY

 

 MS Excel in Hindi ke basics ke bare mein jaane:

1) Sabse pehle aap MS Excel open karien. Jaise hi open hoga apke samne bahut sare templates ka option ayega. Usme se apko Blank Workbook par click karna hai.

Iss picture mein dikhaya gaya hai ki new blank workbook open kaise kare

2) Blank Workbook par click karte hi ek sheet open hojayegi, jisme bahut sari Rows, Columns and Cells honge.

Iss image mein aapko pata chlega ki cell, row and column kya hota hai. Cell name, row number and column header kise kehte hai.

Rows horizontal () hoti hai and inko aap row number se identify kar sakte hai. Jaise aap upar picture mein dekh sakte hai ki left side of sheet ke 1,2,3,4…… likha hua hai toh unko rows bolte hai.

Columns vertical () hote hai and inko aap column header se identify kar sakte hai. Ye sheet ke top me left to right i.e. horizontally run karte hai. Jaise aap upar dekh sakte hai A,B,C,D….. Inko columns bolte hai.

Upar jo aap highlighted red box dekh rahe hai use Cell bolte hai and D5 is the Cell name. You get to know the cell name by the row and column number. Jaise upar wali picture mein column name is D and similarly row ka number is 5, jisse cell name hua D5.

Ab main apko btati hu ki cell me type kasie karte hai, aap kisi bhi cell par jayiae aur apko jo bhi data enter karna hai use type karien. Once you’re done with it next cell par jane ke liye phirse enter press karien. And right, left ya upar neeche jaane ke liye use arrow keys (↓← ↑ →).

3) Agar apko yaad ho toh starting mein apne Blank Workbook open kiya tha, toh jaise kisi book mein pages hote hai iss workbook me sheets hoti hai. Aap alag alag sheets maintain kar skte hai according to your need.

Ab samajhte hai ki sheet kaise add karte hai:

  • Picture me jha sheet 1 likha hua that is the Sheet name. Right click on it and a pop-up will appear (refer the picture given below). Jaise hi aap first option Insert par click karenge ek new sheet add ho jayegi.
  • Pop-up box ke alawa aap seedha add (+) wale symbol par jaise hi click karenge new sheet add hojayegi. (refer the picture given below)

iss picture mein excel mein new sheet add karne ke 2 tareeko ke bare mein btaya gya hai

 

Insert ke alawa apko pop-up box mein aur bhi kayi sare options dikh rahe honge.

Delete

Ise tab use karte hai jab koi sheet delete karni hoti hai.

Rename

 Koi bhi new sheet jab aap add karte ho toh uska default name hota hai Sheet 1, Sheet 2, Sheet 3 and so on depending on the number of sheet. Jaise neeche wali picture mein naam hai Sheet 1. Toh Rename ke option se aap sheet ka naam kuch bhi apni requirement ke according save kar sakte hai.

Move or copy

  This is simply jab apko koi sheet koi ek jagah se dusri jagah copy ya paste karna hota hai. Jaise hi aap move or copy par click karte hai a pop-up box appears (given below).

Tab color

 Aap sheet ko rename karne ke saath saath uska color bhi set kar sakte hai just for better classification. Isse aap alag alag sheets ko colors se identify kar sakte hai.

iss image mein sheet ko copy ya move kaise karte hai uski sari commands ko samjhaya gaya hai

Ye pop-up box is only for Sheet 1 because, I right clicked on Sheet 1. Iska matlab hai aap jo bhi options choose karenge wo Sheet 1 par hi apply honge, so if you want to move or copy sheet 2, 3 ,4 and so on apko un sheets par right click karna padega.

Upar jha likha hua hai Book 1 vha pe apko Book name ya number select karna hai, jaise yha par Book 1 hai. Toh aap jo bhi Book name ya number select karenge Sheet vaha pe move ho jayegi.

Uske baad aapko neeche  Sheet names dikh rahe honge. Yaha se aap choose kar sakte hai agar apko sheet ka order change karna hai toh and last me create a copy pe jab aap click karenge jo toh uss sheet ki ek copy ban jayegi. Aur agar apko ek se zyada copy chahiye toh aap dubara right click karke create a copy pe click kar sakte hai.

4) Picture mein you can see File, Home, Insert, Page Layout etc all these are called Tabs. In tabs ko jab aap click karte hai toh bht sare options appear ho jate hai. (refer the other pic below)

iss image mein excel mein tabs kise kehte hai usko highlight kiya gaya hai

 

iss picture mein commands aur ribbon kise kehte hai aur ye kya hote hai uske bare mein btaya gaya hai

The red highlighted space is called the Ribbon. This space contains all the commands jinko hum editing aur baki cheezo ke liye use karte hai. Kisi bhi tab me apko jitne options/features/functions dikh rahe hai unko Commands bolte hai. Beginners ke liye jo tab sabse zyada important Home Tab hota hai. 

Home tab commands jo apke bahut kaam ayenge

iss image mein home tab ko dikhaya gaya hai ki usme kon konse commands hote hai

 

Clipboard, Font, Alignment and Cells are the most commonly used commands in Home Tab.

Clipboard

Ismein sare basic commands hote hai like cut, copy, paste and ek aur command i.e. Format Painter. Cut, copy and paste ke shortcuts bhi hote hai i.e.

Cut – Ctrl+X

Copy – Ctrl+C

Paste – Ctrl+V

Ab baat karte hai Format Painter ki, iska use aap tab kar sakte hai jab apko format copy karna hota hai. For example, apne ek cell me color add kiya hai and saath mein bold bhi kiya hai. Aur aap use ek aur cell me copy karna chahte hai, toh aap simply uss cell pe jao format painter pe click karke copy karo and then jis bhi cell mein apko paste karna hai vaha jakr copy kardo.

Font

Iski help se aap text ka size, color, font etc choose karke apne according set kar sakte ho.

isme font command ko detail mein samjhaya gaya hai

  • Font mein aap apni requirement ke according type choose kar sakte hai. It has a lot of options from formal font type to casual to comic font styles.
  • Font style mein aap text ka style choose kar sakte hai agar apko text ko bold karna hai ya italic, bold italic ya phir regular hi rakhna hai.
  • Size me aap readability and requirement ke according text ka size set kar sakte hai. Aap ek hi sheet mein alag alag size bhi use kar sakte hai.
  • Color se you can simply choose text kis color ka chahiye.
  • Once you’ve done all the settings according to your needs jaha preview likha hua hai vaha pe pe text appear hoga with all the settings made by you.

Jab apko sab theek lage phir aap bottom right corner mein ok par click kar sakte hai aur sari settings apply ho jayengi.

Alignment

isme allignment ke commands ko btaya hai

Upar jo arrows apko dikh rahe hai wo teeno alignmnet settings ke liye hai. Aap jab bhi cell mein koi data enter ya type karte hai toh uske baad uski alignment setting kar sakte hai. Either you can choose extreme right, left ya center by clicking on the above indicated arrows.

Upar image mein apko Wrap Text ka command dikh raha hoga. Ise text formatting ke liye use karte hai.

wrap text kya hota hai usko samjhane ke liye ek text ko do bar likha hai

Aap dekh sakte hai ki konsa text dekhne mein zyada better lag raha hai. Toh jab apka data ya text zyada bada hota hai aur cell ki boundaries se bahar nikal jata hai toh aap ya toh uss text ko select kare ya uss cell par jaakr Wrap Text par click kare. Usse apka sara text/data ek hi cell me adjust ho jayega.

Similarly, ek aur command hota hai jiska naam hai Merge & Center. Iska use bhi text ki formatting ke liye hota hai. Isse apka text cells ke center mein align hojata hai, mostly ise headings ki formatting ke liye use karte hai.

Cells

iss picture mein cells ke commands ko dikhaya hai

Insert ki help se aap cells, rows and columns ko kisi bhi cell, row ya column ke pehle ya baad me insert (add) kar sakte hai. Aur iss command ki help se aap ek new sheet bhi add kar sakte hai.

Delete command ki help se aap koi bhi cell, row ya column ko delete kar sakte hai.

Dono hi commands ke liye apko bas desired cell, row ya column pe jana hoga and uske accordingly aap choose kar sakte hai ki apko kaha pe new cell, row ya column insert ya delete karna hai.

Calculations

MS Excel mein aap sari calculations kar sakte hai. MS Excel mein bahut sare formulas hote hai jaise add, subtract, mulitply, divide etc jinse aap bahut badi badi calculations asaani se kar sakte hai. Toh neeche ek basic formula explain kiya gaya hai jisse apko help hogi.

AutoSum

isme autosum formula home tab mein kaha hota hai wo dikhaya hai

yaha pe autosum formula ko numerical data ki help se samjhaya hai

 Extreme right mein you’ll find this command. Aapko jitne bhi digits ka sum karna hai just select them, it can be either ways horizontally and vertically too. And jaise hi aap enter press karenge sum appear ho jayega.

Free Online MS Excel Courses

Yeh toh kuch basic commands and batein hai MS Excel in Hindi ki jinhe apko dhyan mein rakhna hai. Ab agar aap MS Excel aur detail mein seekhna chhate hai toh neeche Top 5 free MS Excel courses ke links diye gaye hai jinpar jakar aap seekh sakte hai. 

1. Excel Easy

Yeh website basic information provide karti hai joh un logo ke liye bhi useful hai jinko MS Excel bilkul use karna nahi ata. Isme 300 examples hai MS Excel ke functions and aur bhi kayi cheezo ke bare mein.

2. Chandoo.org

Iss website mein beginners se lekar advanced level ki information hai. Isme apko video tutorials ke saath free E-Books bhi milegi. And aap latest information ke liye newsletters ko bhi subscribe kar sakte hai.

3. Excel Superstar

Iss website par sare tutorials on MS Excel in Hindi hai. Apko yaha par sabkuch step by step samjhaya jayega taaki aap bhi MS Excel mein expert ban sake.

4. Microsoft’s Excel Training Center

Yeh website Microsoft ki hai. Ispar apko bahut accurate information and detailed chapters milenge jisse apko MS Excel ke bare mein sab samajh ajayega.

5. Alison

Ye ek free online courses ki website hai. Yaha par alag alag levels ke courses from experts available hai. Course ko complete karne ke baad aapka ek assessment liya jayega and phir aapko certifictaion ya diploma bhi diya jayega.

I hope iss information se apki help hogi. Agar aap aur courses ke bare mein jante hai ya iss article se related koi bhi sawaal hai to comments mein likhe.

LEAVE A REPLY

Please enter your comment!
Please enter your name here