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.  Aur agar inke alawa aapke mann mein koi aur sawal ya MS Excel se judi koi jankari chahte hain toh humare group se judein aur apna sawal puchein. Hum apki poori sahayata karenge.

Humse judne ke liye niche click karein –. 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.

2) Blank Workbook par click karte hi ek sheet open hojayegi, jisme bahut sari Rows, Columns and Cells honge. 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.

Mar 31, 2018 - Hindi Typing सीखने के लिये आपको तीन चीजों की अावश्‍यकता होती है पहला Hindi Keyboard Layout और दूसरा Hindi Typing. हिंदी फोंट डाउनलोड करे - The most popular fonts for typing Hindi in India is Devanagari font which is used for everyday official and daily purpose. You can also downlowd Agra Hindi Fonts, New Delhi Normal Hindi Fonts (including Bold and Italic), Preeti Regular Hindi Fonts and many more.

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) 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. Crystal reports 2008 serial product key code downloads. 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) 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.