Microsoft Excel Kaise Use Kare – MS Excel Ki Puri Jankari
Microsoft excel kaise use kare aaj iss post me mein aapko bataunga. Agar aapko microsoft excel ka thodi bahut knowlege hai. Aur isse use karne ki jyada jankari pana chahte hai. To iss post mein excel ke kuch useful tips aur jankari ke ek list aapke sath share kar raha hu. Ummeed hai aapko ye jankari jarur pasand aayegi.
Excel microsoft office ka ek part hai, jisse spread sheet package bhi kaha jata hai. Data ko row aur column me likhkar uske bad usme kisi bhi parkar ki calculation kar sakte hai. Jaise ki financial, statistical aur mathematical calculation etc. Microsoft excel me data ko analysis kar sakte hai. Aur isme report vagerah bana sakte hai. Iske saath hi data ko graph ke roop me present bhi kar sakte hai.
Microsoft Excel Kaise Use Kare – Ms Excel Ki Puri Jankari
Microsoft Excel Me Home Tab Ki Puri Jankari
Excel spreadsheet me approx 8 tabs aur 7 sub tabs hote hai. Main option me Home, Insert, Formulas, Data, Review, View, Developer hote hai. Aur sub tab me Clipboard, Font, Alignment, Number, Styles, Cells, Editing hai. Read more….
Advanced Excel Me Insert Tab Ki Puri Jaankari
Agar aap excel me work karte hai to insert option ke bare me aap acchi tarah se janate honge. Insert tab ki help se hum table or pivot table create kar sakte hai. Pictures, clip art, alag alag shapes, aur symbol, object, word art, text box insert kar sakte hai. Read more….
Microsoft Excel Me Text Formulas Ka Use Kaise Kare
Text formulas me 25 tarah ki commands hoti hai jinka use aap excel excel sheet me alag alag tarah se kar sakte hai. Read more….
Advanced Excel Me Data Text Filter Ki Puri Jankari
Microsoft excel excel sheet me data text filter ka use bahut hi simple hai. Iska use karne ke liye sabse pehle aap apni excel spreadsheet me ek table create kare. Table kuch bhi use kar sakte hai jaise marketing data, total sale data etc. Read more….
Pivot Table Kya Hai Aur Pivot Table Create Kaise Kare
Microsoft excel me pivot table bahut hi useful aur most powerful function hai. Powerful isliye kyuki pivot table ki help se aap data summarize kar sakte ho. Aur excel worksheet me ek big data sets ko sort aur filter kar report check kar sakte hai. Read more….
Excel Replace Function Ka Use Kaise Kare
Excel replace function ek formula hai. Jiski help se aap excel worksheet me kisi perticular cell me available characters set ko replace kar sakte hai. Excel worksheet ki cell me available text string ko excel replace function ki help se another text string me replace kar sakte hai.
Character ki location ke according excel replace function text ko replace karta hai. Isliye aap text string ki location ke base par text or text set ko replace kar sakte hai. Read more….
Advance Excel Me Dropdown List Font Size Ko Increase Kaise Kare
Advance excel me drop down list option bahut hi helpful feature hai. Lekin bahut se logo ko dropdown list ke chhote font size ko lekar thodi problem hoti hai. Agar aapko bhi advance excel me drop down list ke mini font se problem ho rahi hai. Read more….
Advanced Excel Me Hyperlink Ka Use Kaise Kare
Microsoft excel me hyperlink ek tarah ka link hota hai. Jispar click karke aap another page or file ko direct open kar sakte hai. Hyperlink me aap kisi excel, word, image or text file, webpage, or email ko link kar sakte hai.
Excel excel sheet me hyperlink create hone ke baad direct hyperlink par click karke linked source ko open kar sakte hai. Read more….
Excel Macros Kya Hai Aur Macro Record Aur Use Kaise Kare
Agar aap advance excel me kisi kaam ko daily, weely or monthly basis par karte hai. For example data formating, table create karna or daily work me same formulas ka use karna etc. To iske liye aap manuel work ki jagah par macro record apna kaam easy bana sakte ho.
Aur apne kaam ko aur bhi jyada jaldi kar sakte ho. Iske liye aapko sirf ek baar macro record karna hai. Aur jab bhi aapko same data ko process karna ho to usme recorded macro ko run karna hai. Read more….
Excel Keyboard Shortcuts Kya Hai Excel Shortcuts Ki Puri Detail
Hello friends, aaj mein aapko kuch excel keyboard shortcuts ke bare me bata raha hu. Agar aap excel me kaam karte hai to aapko inn excel keys ke bare me pata hona chahiye.
Excel shortcut keys ka use karke aap advance excel work ko aur bhi aasaan bana sakte hai. Aur apna kafi time bhi save kar sakte hai. Read more….
Alphanumeric String Kya Hai Advance Excel Me Iska Use Kaise Kare
Advance excel me alphanumeric string ek VBA command hai. Jiske through kisi ek cell me merge alpha aur numeric characters ko split kar sakte hai. Yani ki excel ki cell me ek sath jude huye akshar aur numbers dono ko alag cell me show kar sakte hai. Read more….
Advanced Excel Me Concatenate Formula Kaise Use Kare
Concatenate formula ko “combine“ ya “ek sath jodna“ bhi keh sakte hai aur iss formula ka use excel worksheet ki do alag cells ke data ko ek cell me merge karne ke liye kiya jata hai. Read more….
Microsoft Excel Me Duplicate Words Kaise Remove Kare
Agar excel list me available duplicate words ko hum manually remove karenge to isme bahut time lag sakta hai. Lekin agar aap data tab me available remove duplicates function ka use karenge to ye kaam seconds me ho jata hai. Aur isko use karne se humara kaafi time bhi save ho jata hai. Read more….
Excel Me Remove Numeric Macro Ka Use Kaise Kare
Ms Excel Me Hyperlink Image Macro Ka Use Kaise Kare
Microsoft excel me kisi website ya online page se koi contents copy karne par kuch images bhi paste ho jati hai. Aur excel spreadsheet me inn images se agar link extract karna ho to excel vba command ka use kar sakte hai. Read more….
Microsoft Excel Me Hyperlink Text Macro Ka Use Kaise Kare
Hyperlink ya link html text ka vo part hota hai jisme kisi other website ya webpage ka address diya hota hai. Kisi website par diye hyperlink par click karne par hum uss webpage par pahuch jate hai jo address hyperlink se link hota hai. Read more….
Data Validation List Advance Excel Me Kaise Use Kare
Advance excel me data validation list feature ki help se aap control kar sakte hai ki worksheet me kya enter hoga ya kya enter nahi hoga.
Data validation ki help se hum niche diye gaye steps apply kar sakte hai.
- Kisi cell me items list ki dropdown list creat karna.
- Kya enter kar sakte hai iske liye custom rules create karna.
- Date aur whole numbers only ke liye restrict entries etc. Read more….
Insert Chart Function Ka Use Kaise Kare
Chart ek esa function hai jiski help se hum data ko graphically communicate kar sakte hai. Aur 11 types (Column, Line, Pie, Bar, Area, Scatter, Stock, Surface, Doughnut, Bubble, Radar) ke use se apne data ko chart me present kar sakte hai. Aur audience ko comparison karne me help milti hai. Read more….
Data Advance Filter Ka Use Kaise Kare
Data advance filter regular filter ka hi advance version hai. Isse aap aur bhi jyada complex criteria ko filter kar sakte hai. Excel worksheet me aap apne data se unique records extract kar sakte hai.
Regular filter se aap kisi perticular dataset ko filter kar sakte ho. Jabki data advance filter se aap other locations ke data set ko extract kar sakte hai. Read more….
Excel Formula Me Symbol Add Kaise Karte Hai
Symbols aap insert function ke under symbol tab me dekh sakte hai. Aur apni command ke hisab se choose kar set kar sakte ho.
Symbol se table ko ek alag look milta hai aur ye dekhne me bhi accha lagta hai. Advance excel formula me symbol add kaise karte hai. Read more….
Data Goal Seek Ka Use Kaise Karte Hai
Microsoft excel me goal seek ka use total amount, rate per quantity or quantity ko check karne ke liye karte hai. Aap chahe bank se loan le rahe ho ya market se kuch samaan purchase kar rahe ho.
Data goal seek ki help se total amount, quantity aur rate per quantity ko easily seconds me check kar sakte hai. Read more….
To dosto aaj ke iss excel tutorial microsoft Excel Kaise Use Kare me bus itna hi. Aur jyada jankari aur new updates ke liye aap iss website ko subscribe kar sakte hai.
I hope aapko ye post microsoft excel kaise use kare pasand aayi hogi. Agar aapko ye jankari helpful lage to apne friends ke sath bhi isse share jarur kare.
