Excel Me Calculation Kaise Kare | Formulas Ki Jankari Hindi Me

Excel Me Calculation Kaise Kare | Formulas Ki Jankari Hindi Me

Excel Me Calculation Kaise Kare

Excel Me Calculation Kaise Kare

Aaj sabhi companies apne sabhi kaam ka record rakhti hai, jo kafi jaruri bhi hai par ishe maintain karna itna aasan nahi hai. Aaj sayad hi koi aisi company hogi jo apne data ko excel me save karke nahi rakhti. Kyon ki isme data ko store karna bhot hi aasan kaam hai. Microsoft excel aaj duniya me sabse jaada use hone vali data spreadsheet hai. Sabhi koi apne graphs, calculation ya business me sabhi accounts ko maintain karne ke liye excel ka hi use hota hai. Matlab agar sidhe words me baat ki jaye toh agar excel nahi hota to kisi bhi record ko aap easily maintain nahi kar sakte the. Excel me formulas ko bhi hum bade aasani se use kar sakte hai bas iske liye hume knowledge honi chahie excel me calculation kaise kare. Par isse pahle jaruri hai aapko pataa ho excel ko use kaise karte hai.

Excel ko kaise use kare

Excel ko hum worksheet bhi kahte hai kyoki is par hum bhot se kaam karte hai jaise calculation, graph, programing ke liye bhi use karte hai. Excel microsoft ka product hai, ishe microsoft ne 1985 me banaya tha tabse

Isne apne aakarshak feature se sabko aapni taraf attract kiya hai. Ishe use karne ke liye aapko sabse pahle ise open kare isme aapko ek sheet me 256 columns or 65536 rows najar aaegi. Isme aap column wise or row wise data ko enter kar de or iski file ko humesa “.xls” se hi save karte hai. Thodi excel me formulas ko use karne ki jaankari se aapke liye isme kaam karna or aasan ho jaata hai. Toh chaliye jaante hai excel me formulas ko use karke calculation kaise kare. Iske liye aapko excel me formula bar ko activate karna hoga. To shuru karte hai formula bar ko activate kaise kare.

Formula bar ko kaise excel me activate kare

Formula bar excel ka aisa feature hai jo ishe kaam karne ke liye sabse best banaa deta hai or har koi ishe use karta hai. Par aapko ishe activate karna aana chayie. Ishe use karke hum badi se badi calculation ko bhi badi aasaani se kar sakte hai. Ishe activate karne ke jaise hi aap kisi bhi cell me =(equal) ka sign press karte hai ya click bhi karege toh ye activate ho jata hai. Ishe aap ek dusre tarike se bhi activate kare sakte hai iske liye aapko apne keyborad se f2 key ko press karna hoga, ishe press karte hi aapka formula baar activate ho jaaega. Ab aap aasani se koi bhi calculation isme kar sakte hai. Toh chaliye ab jane Excel Me Calculation Kaise Kare.

excel me calculation kaise kare

Ap chay to excel me formulas ko enter karke bhi calculation kar sakte hai. Ye aapke kaam ko badi aasani se chutkiyo me solve kar dega. Toh chaliye jaante hai excel me formule kaise likhte hai.

Sum ya addition (+) kaise kare

Excel me additon karne ke liye aapko sum ka formula use karna hoga, iske liye aapko formula bar me sum likhne ke baad bracket me first cell address, 2nd cell address dena hoga or jaise hi ap enter karege selected cell me apka result aa jaaega.

“sum(1st cell address, 2nd cell address)”.

Ya aap 2 se jyada cell ka sum karna chahte hai to type kare sum() broacke me cell range deni hogi. Ex-(c1-c3).

Multiply (×)

Multiply karne ke liye aapko apni excel sheet ke formula baar me jitne no ko multiply karna hai vi number. Dene hoonge. Number ke beech me comma ka use kare.

Product(no. 1, no. 2, no. 3…… ) ye formula likh kar enter kare aapka result selected row me chala jaaega.

Maximum

Agar aapko kitni hi numbers me se sabse badaa number chayie to aapko iske liye maximua ka formula apply karna hoga.

Max(cell range exc5-c8) ye aapko c5 se c8 cell me se sabse badaa number de dega.

Minimum

Sabse chota number search karne ke liye aapko minimum ka formula use karna hoga.

Min(yha par aap jo chae vo cell range de sakte hai)

Ex-c2-c5 ye aapko c2 se c5 tak sabse chota no de dega.

Average

Aapko kayi bar calculation me average nikalne ki jarurat padti hogi. Iske liye aap execl ka use kar sakte hai jisme aap badi aasani se apne data ka average nikal sakte hai. Iske liye bas aapko apne formula bar me average ka formula type karna hoga or jitni chay itni rows or column ke data ka average kuch hi seconds me aapke saamne hoga. Iske liye type kare average(cell range ) cell apko vo select karni hai jha tak ki cells ka apko average chayie. Or ye data aapki selected cell me print ho jaaega.

Length

Kuch data me hume words ki length ko count karna padta hai. Iske liye aapko bas jyada kuch nahi karna apne sare data ko excel sheet me store kariye or excel me length formula ka use karke aap apne sabhi words ki length ko count kar sakte hai. Iske liye bas type kare len() or bracket me cell range enter kare

Upper

Kabhi kabhi aapke pass aisa data aa jaata hai jisme sare letters capital nahi hote or aapke liye har ek word ko select karke use capital me convert karna easy nahi hota agar aapke data me lakho hazaro naam ho toh, iske liye aapko presaan hone ki jarurat nahi hai apne data ko excel sheet me save kriye or formula bar me upper case ka formula enter kar de. Yaha bas aapko cell range deni hogi or aapka kaam bs kuch hi seconds me ho jaaega or sabhi lower case upper case me convert ho jaage. Iske liye type kare

Upper(cell range) or aapka sara data upper case me convert ho jaaega.

Ab hum aapko batate hai excel ke special feature ke bare me jise auto fill kahte hai ye kaise kaam karta hai aayie jaante hai.

Auto fill kaise kaam karta hai

Excel ke is feature ko use karne se aapko apna koi bhi use kiya hua formula dobara type nahi karna hoga bus aapko uska naam dena hoga or ye khud hi use calculate kar dega. Aapko na hi to koi no type karna hoga na hi koi formula. Ishe me aapko ek example se smjhata hu. Maan lijiye aapne kahi excel me day ka naam type kiya monday aap is cell ke corner me jaise hi click karege aapko aage ke sare days ki list aa jaegi. Aapko unhe type karne ki jarurat nahi hai or jha chay vha unhe use kar sakte hai.

Ab aap in formulas ki help se apni calculation excel me bhi badi aasani se kar sakte hai, bas excel me calculation kaise kare is article ko dhayan se padhe.

Drive Google Ke Fayde

A project by AnalogFolk © 2017