{"id":14820,"date":"2019-07-15T14:43:05","date_gmt":"2019-07-15T09:13:05","guid":{"rendered":"https:\/\/www.joshtalks.com\/joshkosh\/?p=14820"},"modified":"2020-11-12T05:42:37","modified_gmt":"2020-11-12T00:12:37","slug":"ms-excel-in-hindi-full-tutorial-beginner-course-free-part-1","status":"publish","type":"post","link":"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/computer-skills\/ms-excel-in-hindi-full-tutorial-beginner-course-free-part-1\/","title":{"rendered":"MS Excel in Hindi Full Tutorial Beginners Course Part 1"},"content":{"rendered":"\n<h2>Learn Excel For Free in Hindi ek Hafte Mein examples ke saath<\/h2>\n\n\n\n<p class=\"has-regular-font-size\">Naukri Chahiye to MS Excel Sikhni zaruri hai. Agar naukri mein tarakki chahiye to bhi aapko Excel master banna hoga. Chaliye sikhte hai MS Excel in Hindi is tutorial ke madhyam se.<\/p>\n\n\n\n<p><strong>Yeh MS Excel tutorial baaki excel courses se behtar hai kyonki<\/strong>:<\/p>\n\n\n\n<ul><li>Yeh hindi excel tutorial 100% FREE hai <\/li><li>Iss course mein humne aapko <strong>simple examples<\/strong> se excel ke baare mein bataya hai<\/li><li>Yeh course <strong>beginner level se shuru hoke advanced level<\/strong> tak hai<\/li><\/ul>\n\n\n\n<p> <strong>Aapko Beginner course part 1 ki zarurat hai agar<\/strong>:<\/p>\n\n\n\n<ul><li>Aapko <strong>MS excel ke baare mein kuch nahi aata<\/strong> aur aap excel Hindi mein sikhna chahtein hai<\/li><li><strong>Aap fresher hai<\/strong> aur excel ke baare mein pata na hone se aapki naukri nahi lag rahi hai ya naukri ke liye aap excel sikhna chahtein hai <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<p><strong>Yeh MS Excel full course tutorial in Hindi ka pehla part hai. Isko complete karne ke baad aap baki 3 parts bhi kar sakte hain. <\/strong> Niche diye gaye links par click karke aap uss tutorial pe ja sakte hai &#8211;<\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Beginner course part 2 -  MS Excel ko use karke data analysis kaise karte hai (Sort aur Filter kaise kare) (opens in a new tab)\" href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-beginner-course-free-part-2\/\" target=\"_blank\">M<\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-part-2-sort-filter-find-replace\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"S Excel in Hindi full tutorial Beginner course part 2 -  MS Excel ko use karke data analysis kaise karte hai (Sort aur Filter kaise kare) (opens in a new tab)\">S Excel in Hindi full tutorial <\/a><strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-part-2-sort-filter-find-replace\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"S Excel in Hindi full tutorial Beginner course part 2 -  MS Excel ko use karke data analysis kaise karte hai (Sort aur Filter kaise kare) (opens in a new tab)\">Beginner course part 2<\/a><\/strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-part-2-sort-filter-find-replace\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"S Excel in Hindi full tutorial Beginner course part 2 -  MS Excel ko use karke data analysis kaise karte hai (Sort aur Filter kaise kare) (opens in a new tab)\"> &#8211;  MS Excel ko use karke data analysis kaise karte hai (Sort aur Filter kaise kare)<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-in-hindi-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Advance course part 1 - MS Excel formulas basic level wale Hindi Mein (opens in a new tab)\">MS Excel in Hindi full tutorial <\/a><strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-in-hindi-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Advance course part 1 - MS Excel formulas basic level wale Hindi Mein (opens in a new tab)\">Advance course part 1<\/a><\/strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-in-hindi-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Advance course part 1 - MS Excel formulas basic level wale Hindi Mein (opens in a new tab)\"> &#8211; MS Excel formulas basic level wale Hindi Mein<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">MS Excel in Hindi full tutorial <\/a><strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">Advance  course part 2<\/a><\/strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\"> &#8211; MS Excel advance formulas in Hindi<\/a> <\/p>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<p>Chaliye dekhtein hain ki aap iss beginner part 1 mein kya sikhenge.<\/p>\n\n\n\n<h3><strong>Beginner Part 1 MS Excel tutorial in Hindi mein hum sikhenge <\/strong><\/h3>\n\n\n\n<p><a href=\"#ms-excel-kya-hai-and-usse-kaise-open-kare\">MS Excel kya hai and usse kaise open kare<\/a><\/p>\n\n\n\n<p><a href=\"#excel-worksheet-kya-hoti-hai-and-usmein-kaise-kaam-karte-hain\">Excel worksheet kya hoti hai and usmein kaise kaam karte hain<\/a><\/p>\n\n\n\n<p><a href=\"#kaise-apne-data-ko-excel-mein-copy-and-paste-kare\">Kaise apne data ko excel mein copy and paste kare<\/a><\/p>\n\n\n\n<p><a href=\"#kaise-apne-data-ka-font-and-styling-change-karke-usse-thoda-attractive-dikhayein\">Kaise apne data ka font and styling change karke usse thoda attractive dikhayein<\/a><\/p>\n\n\n\n<p><a href=\"#kaise-total-kare\">Kaise total kare<\/a><\/p>\n\n\n\n<p><a href=\"#kaise-excel-ka-basic-apply-kare-through-example\">Kaise Excel ka basic apply kare through example<\/a><\/p>\n\n\n\n<p>Chaliye ab MS Excel in Hindi sikhna shuru karte hai upar wale ka naam leke. <\/p>\n\n\n\n<p>Article padhne ke baad live example zarur karna jiske zariye aapne jo kuch sikha hai woh pakka ho jayega. <\/p>\n\n\n\n<h3><a name=\"ms-excel-kya-hai-and-usse-kaise-open-kare\">MS Excel kya hai and usse kaise open kare<\/a><\/h3>\n\n\n\n<p><a href=\"https:\/\/products.office.com\/en-in\/excel\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">Excel Microsoft ka banaya gaya ek spreadsheet program hai<\/a> jisse se aap apne data ko organise kar sakte hain, unke charts, unki calculations, unke pivot tables bana sakte hain, isse aap VBA (Virtual basic Application) se programming bhi kar sakte hain. Iske kayi version hai jaise 2007, 2012 aur 2016.                 <br> <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Microsoft-Excel-kaise-seekhe-app-1.jpg\" alt=\"MS Excel kya hai and usse kaise open kare\" width=\"1072\" height=\"602\"\/><\/figure><\/div>\n\n\n\n<p><strong>Excel kaise open kare<\/strong><\/p>\n\n\n\n<p>Sabse pehle aap sab Excel ko open kare, ye agar aap Start button par click karke programs mein jayenge toh aapko Microsoft office mein as  Microsoft Excel miljayega. Aap search mein jakar bhi MS-excel type karenge toh aapko ye easily miljayega. <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-opening-view-adding-blank-sheet-1.jpg\" alt=\"MS Excel Kaise Sikhe- Open excel\" width=\"1079\" height=\"819\"\/><\/figure><\/div>\n\n\n\n<h3><a name=\"excel-worksheet-kya-hoti-hai-and-usmein-kaise-kaam-karte-hain\">Excel worksheet kya hoti hai and usmein kaise kaam karte hain<\/a><\/h3>\n\n\n\n<p>Excel open karne ke baad aapko ek badi se table form mein sheet dikhegi, iss sheet ko excel <strong>w<\/strong><em><strong>orksheet<\/strong><\/em> kehte hai, iss sheet ka use hum apne data ko <em>tabular<\/em> form mein, <em>graphical<\/em> form mein ya bahut saare number <em>data ko<\/em> <em>store<\/em>  karne ke liye use karte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-worksheet-view-1.jpg\" alt=\"MS Excel Kaise Sikhe- Excel Worksheet\" width=\"1080\" height=\"554\"\/><\/figure><\/div>\n\n\n\n<p>Yahan aap dekh sakte hai ki sabse upar bahut saare tabs hain jaise File, Home, Insert, Design, Layout, etc. Iss poore icons aur buttons ke strip ko Ribbon kehte hain. <\/p>\n\n\n\n<p>Chaliye ab jaanein inn tabs ke bare mein basic information.<\/p>\n\n\n\n<p><strong>FILE TAB<\/strong><\/p>\n\n\n\n<p>Inn tabs mein sabse pehle tab <strong>File<\/strong> hai jispe click karke aapko kayi options dikhenge. Inn options ko aap choose karke ek naayi sheet create kar sakte hain, isse aap koi aur worksheet open ya apni banayi hui worksheet ko save bhi kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/MS-Excel-kaise-seekhe-File-tab.jpg\" alt=\"MS Excel Kaise sikhe- file tab\" width=\"1077\" height=\"754\"><\/figure><\/figure><\/div>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/MS-Excel-kaise-seekhe-File-tab-options.jpg\" alt=\"MS Excel Kaise sikhe- file tab options\" width=\"1079\" height=\"1220\"><\/figure><\/div>\n\n\n\n<p>Isse aap <strong>Ribbon<\/strong> mein aur bhi tabs daal sakte hain, ye aap file tab mein options mein jakar<strong> <em>Customize Ribbon<\/em><\/strong> mein jo tab aapko add karna hai uspe tick karke kar sakte hain. <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Cutomize-Ribbon-1.jpg\" alt=\"MS Excel part 1- ribbon options\" width=\"1053\" height=\"861\"\/><\/figure><\/div>\n\n\n\n<p>Isme ek aur option ka use kaafi hota hai <strong>Export<\/strong> karne ka, iss export ke option se aap apni excel worksheet ko <em>pdf me convert<\/em> kar sakte hain. <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Export-2.jpg\" alt=\"MS Excel part 1- Export data\" width=\"1071\" height=\"950\"\/><\/figure><\/div>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Export-to-pdf-2.jpg\" alt=\"MS Excel part 1- Export data and create pdf\" width=\"1061\" height=\"852\"\/><\/figure><\/div>\n\n\n\n<p>Chaliye ab aayein Home tab pe. <\/p>\n\n\n\n<p><strong>HOME TAB<\/strong><\/p>\n\n\n\n<p>Home tab par click karne par aapko bahut saare chote chote icons dikh rahe honge, inka use hum text formatting ya kahe apna data ko attractive banane ke liye use karte hain. Iss tab mein aapko kayi groups dikh rahe honge jaise Clipboard, Font, Alignment, Number, Styles, Cells aur Editing.<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-Tab-1.jpg\" alt=\"MS Excel part 1- Home tab\" width=\"1075\" height=\"559\"\/><\/figure>\n\n\n\n<p>Chaliye ab inn groups ko ek ek karke inka use dekhein.<\/p>\n\n\n\n<h3><a name=\"kaise-apne-data-ko-excel-mein-copy-and-paste-kare\">Kaise apne data ko excel mein copy and paste kare<\/a><\/h3>\n\n\n\n<p style=\"font-size:19px\"><em><strong>CLIPBOARD<\/strong><\/em><\/p>\n\n\n\n<p>Sabse pehle ismein hai <strong>Paste<\/strong> ka option, iss aap apne data ko kahi se copy karke paste kar sakte hain, isse aap kayi tarikon se apne use ke according paste kar sakte hain jaise keep <em>Source formatting, Merge formatting<\/em>, etc. Next hai <strong>Cut<\/strong> ka option jise use karke aap apne text ko cut karke kahi bhi paste kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-Tab-Clipboard-group-1.jpg\" alt=\"MS Excel part 1- clipboard grp\" width=\"1049\" height=\"941\"\/><\/figure><\/div>\n\n\n\n<p>Iske niche hai <strong>Copy<\/strong> ka option jisse aap text ko select karke copy kar sakte hain. Ab aayiye Clipboard ke last option pe <strong>Format painter<\/strong> jisse aap use karke kisi bhi already formatted text ki formatting copy karke usse kisi aur par laga sakte hain. <\/p>\n\n\n\n<p>Chaliye ab dekhe Home tab ka next group, Font group.<\/p>\n\n\n\n<h3><a name=\"kaise-apne-data-ka-font-and-styling-change-karke-usse-thoda-attractive-dikhayein\">Kaise apne data ka font and styling change karke usse thoda attractive dikhayein<\/a><\/h3>\n\n\n\n<p style=\"font-size:19px\"><strong><em>FONT<\/em><\/strong><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-Tab-Font-group-2.jpg\" alt=\"MS Excel part 1- font grp\" width=\"1004\" height=\"856\"\/><\/figure><\/div>\n\n\n\n<p>Font ka option se aap apne data ko attractive bana sakte hain. Ismein aap dekh sakte hain font ka ek scroll button, jisse aap apne selected text ka font ya kahe writing style ko change kar sakte hain jaise Calibri, Arial, Arial Black, etc., and side mein koi bhi number select karke apne text ka size choose kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Font-Font-style-1.jpg\" alt=\"MS Excel part 1- font grp options\" width=\"1044\" height=\"878\"\/><\/figure><\/div>\n\n\n\n<p>Iske side mein aapko ek large A and small size A dikha raha hoga, isse bhi aap apne text ko apne according size mein  one by one small ya large kar sakte hain. Ab aap dekhein scroll ke niche likha hua hai <strong>B, I, U<\/strong>  inka use hum selected text ko <strong>Bold<\/strong>, <strong>Italics<\/strong> aur <strong>Underline<\/strong> karne ke liye use kar sakte hain. <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Font-Bold-2.jpg\" alt=\"\" width=\"1056\" height=\"866\"\/><\/figure><\/div>\n\n\n\n<p>Ab inke side mein aap dekh sakte hain ek small square jo bana hai jise aap <strong>Border<\/strong> kehte hain aur isse aap apni selected cells mein apne according border add kar sakte and uss border ko format bhi kar sakte hain. Iss square ke side mein aap ek <strong>Fill color<\/strong> ka option dekh sakte hain jisse aap apne selected cells mein apna favorite color fill kar sakte hain. Ab iska last option dekhein <strong>Font color<\/strong> jisse aap apne selected cell ke text ka color change kar sakte.<\/p>\n\n\n\n<p>Next group hai humara Alignment ka.<br><\/p>\n\n\n\n<p style=\"font-size:19px\"><strong><em>ALIGNMENT<\/em><\/strong><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Alignment-1.jpg\" alt=\"\" width=\"1033\" height=\"841\"\/><\/figure><\/div>\n\n\n\n<p>Alignment group se aap apne page mein alignment change kar sakte hain. Aapko iss group mein kuch lines dikh rahi hongi jisse aap apne <em>top alignment, bottom, middle, left, right and center alignment<\/em> ko select kar sakte hain. Inn lines ke side mein diagonally likhe hue <strong>ab<\/strong> se aap text ka orientation change kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Alignment-options-1.jpg\" alt=\"\" width=\"1032\" height=\"877\"\/><\/figure><\/div>\n\n\n\n<p>Aur apne text ko cell border ke left ya right side mein karne ke liye aap inn lines ke side mein arrow ke saath di hui lines jise <strong>Indent option<\/strong> kehte hai se kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Indent-1.jpg\" alt=\"\" width=\"1082\" height=\"1094\"\/><\/figure><\/div>\n\n\n\n<p>Iske next dekhein alignment mein <strong>Wrap text<\/strong> ka option, ye kaafi useful hota hai jise aap click karke cell mein likhe hue long text ko poora dekh sakte hain. Isi option ke niche dekhein <strong>Merge and Center<\/strong> ka option jisse aap cells ko combine karke fir unhe center kar sakte hain, ye option multiple columns ke liye label banane mein bahut helpful hota hai.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Wrap-Text-1-1.jpg\" alt=\"\" width=\"1061\" height=\"897\"\/><\/figure><\/div>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Wrap-Text-2.jpg\" alt=\"\" width=\"1069\" height=\"1005\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:19px\"><strong><em>NUMBER<\/em><\/strong><\/p>\n\n\n\n<p>Number group mein aap apne numbers ka format choose kar sakte hain jaise currency, date, percentage, time, etc. Aap apna account number format karne ke liye <strong>yellow orange icon<\/strong> ka use kar sakte hain aur iske side ke options mein se <strong>percent and comma style <\/strong>bhi change kar sakte hain. Aap ismein ye point zero wale options se aap no. of zeroes after decimal add ya delete bhi kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Number-1.jpg\" alt=\"\" width=\"1048\" height=\"873\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:19px\"><strong><em>STYLES<\/em><\/strong><\/p>\n\n\n\n<p>Next group Home tab mein hai <strong>Styles<\/strong> ka, jisse aap apni table mein&nbsp;<strong>Conditional formatting<\/strong> kar sakte hain ya table style change kar sakte hain, ye styles options bahut kaam ke hote hain jinka extensive use hum aapko apni aage ke articles mein batayenge.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Styles-1.jpg\" alt=\"\" width=\"1042\" height=\"710\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:19px\"><strong><em>CELLS<\/em><\/strong><\/p>\n\n\n\n<p>Agla dekhiye Home tab mein <strong>Cells<\/strong> ka option, ismein <strong>Insert<\/strong> and <strong>Delete<\/strong>&nbsp;option bahut helpful hai. Isse aap row aur columns apni worksheet mein add ya delete kar sakte hain aur apni table mein cells ki height and width ko choose kar sakte hai <strong>Format <\/strong>option me.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Cells-1.jpg\" alt=\"\" width=\"1055\" height=\"863\"\/><\/figure><\/div>\n\n\n\n<h3><a name=\"kaise-total-kare\">Kaise total kare<\/a><\/h3>\n\n\n\n<p style=\"font-size:19px\"><strong><em>EDITING<\/em><\/strong><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Editing-1.jpg\" alt=\"\" width=\"1049\" height=\"943\"\/><\/figure><\/div>\n\n\n\n<p>Agla option Home tab mein hai aapka <strong>Editing<\/strong> ka jismein <strong>Autosum<\/strong> pe click karke apne selected cells ka automatically sum kar sakte hain aur iske saath mein scroll options mein jakar aap apne data mein basic <strong>Functions<\/strong> apply kar sakte hai. Ab dekhiye <strong>Fill<\/strong> ka option jisse agar aapka data koi series ya pattern follow kar raha hai toh vo aap automatically ispe click karke uss series ko fill kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Editing-Autosum1-2.jpg\" alt=\"\" width=\"1046\" height=\"919\"\/><\/figure><\/div>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Editing-Autosum2-2.jpg\" alt=\"\" width=\"1058\" height=\"902\"\/><\/figure><\/div>\n\n\n\n<p><strong>Clear<\/strong> option se apne selected cell mein text, hyperlink ya apne use ke according cells ka content bhi clear kar sakte hain. Ab side mein hai <strong>Sort and Filter<\/strong> ka option jisse aap apne data ko alphabetically ya apne according <strong>Custom sort<\/strong> ya <strong>Filter<\/strong> laga sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Home-tab-Editing-Sort-and-Filterfond-and-Replace-1.jpg\" alt=\"\" width=\"1041\" height=\"932\"\/><\/figure><\/div>\n\n\n\n<p>Iss Home tab ka last option hai <strong>Find and Replace<\/strong> jisse apne apne data mein kuch bhi find ya kisi text ko replace ya text ko format bhi kar sakte. Ye Sort and Filter aur Find and Replace ka option bahut kaam ka hai, iska extensive use hum aapko aage ke articles mein batayenge.<\/p>\n\n\n\n<p>Next hum dekhenge baaki tabs ke sabse useful features ko.<\/p>\n\n\n\n<p><strong>INSERT<\/strong> <strong>TAB<\/strong><\/p>\n\n\n\n<p>Ab hum dekhenge Home tab ke side mein <strong>Insert<\/strong> ka tab jisse hum apni worksheet mein apne data ko select karke usmein kuch bhi add kar sakte hain jaise pictures, charts, link, tables, pivot table, wordart, text box, equation, symbols, etc., ye hum apni according kisi bhi icon par click karke kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Insert-tab.jpg\" alt=\"\" width=\"1054\" height=\"529\"\/><\/figure><\/div>\n\n\n\n<p><strong>PAGE LAYOUT<\/strong><\/p>\n\n\n\n<p>Page layout ke tab se aap apne page mein apne according themes, margin, orientation, height, width, etc., change kar sakte hain.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Page-Layout-1.jpg\" alt=\"\" width=\"1053\" height=\"657\"\/><\/figure><\/div>\n\n\n\n<p><strong>FORMULAS<\/strong> <strong>TAB<\/strong><\/p>\n\n\n\n<p>Next dekhiye sabse important tab Formulas ka jisse aap kayi different types ke formulas use kar sakte hain.<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Formulas-Tab-1.jpg\" alt=\"\" width=\"1056\" height=\"669\"\/><\/figure><\/div>\n\n\n\n<p><strong>DATA<\/strong> <strong>TAB<\/strong><\/p>\n\n\n\n<p>Iske next hai <strong>Data<\/strong> ka tab jisse aap apne data ko clean kar sakte hain. <strong>Sort<\/strong> and <strong>Filter<\/strong> data ko  analyse kar sakte hain aur yahan dekhiye ek option <strong>Text to columns<\/strong> ka jisse aap apne multiple columns ke text ko different cells mein direct convert kar sakte hain. <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Data-tab-3.jpg\" alt=\"\" width=\"1061\" height=\"532\"\/><\/figure><\/div>\n\n\n\n<p><strong>REVIEW TAB<\/strong><\/p>\n\n\n\n<p>Review tab mein aap <strong>Spell<\/strong> <strong>check<\/strong> ya <strong>Thesaurus<\/strong> use kar sakte hain. Aap ismein <strong>Smart lookup<\/strong> ka bhi use kar sakte hain aur isse flowchart bhi bana sakte hain.<\/p>\n\n\n\n<p><strong>VIEW TAB<\/strong><\/p>\n\n\n\n<p>Iss tab mein kayi options hain but aapke sabse use aana wala option hai <strong>Freeze panes<\/strong> ka option jisse aapki sheet ka kuch portion freeze ho jate hain aur jab aap apni sheet ko scroll karte hain tab bhi aap inn freezed panes ko dekh sakte hain, iss option se hum apne headers aur labels niche scroll karte time loose nahin karte. Ismein aap apne <strong>Macros<\/strong> ko run bhi kar sakte hain.<\/p>\n\n\n\n<p><strong>HELP<\/strong> <strong>TAB<\/strong><\/p>\n\n\n\n<p>Yahan aapko ek aur option dikh raha hoga <strong>Help<\/strong> ka option jisse aap microsoft ka official support le sakte hain.<\/p>\n\n\n\n<p>Isse humara aaj ka excel ka basic finish hota hai.<\/p>\n\n\n\n<h2><a name=\"kaise-excel-ka-basic-apply-kare-through-example\">Kaise Excel ka basic apply kare through example<\/a><\/h2>\n\n\n\n<p>Chaliye ab hum ye basic ka use ek example ke saath dekhtein hain. Yahan hum lenge aapki marksheet ka example jispe aap basic excel use karna sikhenge. Iss example ke saath hum discuss karenge ki:<\/p>\n\n\n\n<p style=\"font-size:25px\"><strong>Marksheet ka data worksheet mein table form mein kaise enter kare <\/strong><\/p>\n\n\n\n<p style=\"font-size:25px\"><strong>Kaise marks ke table ko attractive banaye<\/strong><\/p>\n\n\n\n<p style=\"font-size:25px\"><strong>Apni marksheet mein total marks kaise nikale<\/strong><\/p>\n\n\n\n<p style=\"font-size:25px\"><strong>Marksheet mein apne max. aur min. marks kaise pata kare<\/strong>  <\/p>\n\n\n\n<p style=\"font-size:25px\"><strong>Kaise apni percentage nikale<\/strong><\/p>\n\n\n\n<p style=\"font-size:25px\"><strong>Subject wise performance graph kaise banaye<\/strong><\/p>\n\n\n\n<p><br>Sabse pehle aap apni excel worksheet open karle.<\/p>\n\n\n\n<p style=\"font-size:24px\"><strong>Marksheet ka data worksheet mein table form mein kaise enter kare <\/strong> <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter\"><img width=\"600\" height=\"310\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/MS-Excel-kaise-seekhe-Marksheet-example-2.jpg\" alt=\"\" class=\"wp-image-18638\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/MS-Excel-kaise-seekhe-Marksheet-example-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/MS-Excel-kaise-seekhe-Marksheet-example-2-300x155.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure><\/div>\n\n\n\n<p>Ab apni marksheet ka data worksheet mein enter karna start kare, aap chahein toh kuch iss tarah data ko enter kar sakte hain &#8211;<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-data-entering-1.jpg\" alt=\"\" width=\"1051\" height=\"693\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:24px\"><br><strong>Kaise marks ke table ko attractive banaye<\/strong> <\/p>\n\n\n\n<p>Ab aap table ko thoda format kar sakte hain aur colorful bana sakte hain dekhiye aise-<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/MS-Excel-kaise-seekhe-Example-data-entering2.jpg\" alt=\"\" width=\"1086\" height=\"564\"\/><\/figure><\/div>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-Format-as-table-1.jpg\" alt=\"\" width=\"1079\" height=\"973\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:24px\"> <br><strong>Apni marksheet mein total marks kaise nikale<\/strong> <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-SUM-function1-3.jpg\" alt=\"\" width=\"1083\" height=\"908\"\/><\/figure><\/div>\n\n\n\n<p>Aap apne total marks nikal sakte hain. Ye directly cells ko select karke Home tab mein <strong>Autosum<\/strong> option se  kar sakte hain ya fir aap  SUM function bhi laga sakte hain dekhiye aise-<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-SUM-function2-3.jpg\" alt=\"\" width=\"1080\" height=\"967\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:24px\"><strong>Marksheet mein apne max. aur min. marks kaise pata kare<\/strong>   <\/p>\n\n\n\n<p>Chaliye dekhein ki humare max. marks aur min marks kitne hain. Ye hum MAX and MIN function use karke karenge. <\/p>\n\n\n\n<p>Sabse pehle dekhte hain MAX finction. Iskeliye aap sabse pehle likhein-<\/p>\n\n\n\n<p><strong>=MAX(<\/strong><\/p>\n\n\n\n<p>Phir apni range select karlijiye jismein se aap max. no. nikalna chahtein hain. Aur phir bracket close kardijiye aise-<\/p>\n\n\n\n<p><strong>=MAX(E9:E13)<\/strong><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-MAX-function1-1.jpg\" alt=\"\" width=\"1080\" height=\"968\"\/><\/figure><\/div>\n\n\n\n<p><br>Press <strong>ENTER. <\/strong>Aapko apna maximum miljayega.<br><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-MAX-function2-1.jpg\" alt=\"\" width=\"1080\" height=\"923\"\/><\/figure><\/div>\n\n\n\n<p>Ab dekhiye MIN function. Iskeliye likhein-<\/p>\n\n\n\n<p><strong>=MIN(<\/strong><\/p>\n\n\n\n<p>Phir apni range select karlijiye jismein se aap min. no. nikalna chahtein hain. Aur phir bracket close kardijiye aise-<\/p>\n\n\n\n<p><strong>=MIN(E9:E13)<\/strong><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-MIN-function1-2.jpg\" alt=\"\" width=\"1083\" height=\"1011\"\/><\/figure><\/div>\n\n\n\n<p><br>Press <strong>ENTER. <\/strong>Aapko apna minimum miljayega.<br><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-MIN-function2-2.jpg\" alt=\"\" width=\"1083\" height=\"961\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:24px\"><strong>Kaise apni percentage nikale<\/strong> <\/p>\n\n\n\n<p>Agar aapko apni percentage nikalni hai toh aap ye formula lagayein-<\/p>\n\n\n\n<p>=( Select cell jismein hai <strong>Total marks obtained<\/strong> \/ Select cell jismein<strong> Total max marks<\/strong> or type <strong>500<\/strong> )<\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Percentage1.jpg\" alt=\"\" width=\"1079\" height=\"469\"\/><\/figure><\/div>\n\n\n\n<p>Ab aapko decimals mein number milega. <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Percentage2.jpg\" alt=\"\" width=\"1081\" height=\"493\"\/><\/figure><\/div>\n\n\n\n<p><br>Isse percent mein convert karne ke liye jayein &#8211;  <strong>Home Tab &gt; Number <\/strong>group<strong> &gt; %<\/strong><br><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Percentage3.jpg\" alt=\"\" width=\"1082\" height=\"1158\"\/><\/figure><\/div>\n\n\n\n<p><br><strong>% <\/strong>par click karte hi aapko apne decimals percentage format mein miljayega.<br><\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Percentage4-2.jpg\" alt=\"\" class=\"wp-image-24697\" width=\"1080\" height=\"1338\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Percentage4-2-242x300.jpg 242w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Percentage4-2-324x400.jpg 324w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Percentage4-2-338x420.jpg 338w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/><\/figure><\/div>\n\n\n\n<p style=\"font-size:24px\"> <br><strong>Subject wise performance graph kaise banaye<\/strong> <\/p>\n\n\n\n<p>Ab dekhiye ki excel mein performance graph kaise banaye aur har subject ka performance kaise visually represent kare aur usse pata lagaye apne max. aur min. marks. Aap pehle select kare vo column jo aap chart mein dekhna chahte hain, yahan mai select kar rahi hu subject wali column aur <strong>Ctrl<\/strong> press karke marks obtained ka column. Dhyan rakhiyega ki aap column ka selection sahi se kare otherwise  aapka chart sahi nahi banega. Selection ke baad jaye <strong>Insert tab<\/strong> me. Yaha aap dekh sakte hain <strong>Recommended Charts<\/strong>, ismein se aap koi bhi chart le sakte hain, mai yaha choose karungi <strong>Clustered Column<\/strong> kuch iss tarah- <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-Chart-Selection-Clustered-Column-1.jpg\" alt=\"\" width=\"1083\" height=\"745\"\/><\/figure><\/div>\n\n\n\n<p><strong>OK <\/strong>par lick karte hi aapko apna chart miljayega aise-<br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-chart-1.jpg\" alt=\"\" width=\"1083\" height=\"815\"\/><\/figure><\/div>\n\n\n\n<p>Aap apne chart ke styles bhi change kar sakte hain. Iskeliye aap click kare ek baar apne chart par, aap dekhenge ek tab <strong>Chart design<\/strong> ribbon mein appear ho raha hoga  jisse aap apne chart ka design change kar sakte hain, dekhe jaise maine kiya hain    yahan &#8211; <\/p>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Example-Chart-design-1.jpg\" alt=\"\" width=\"1081\" height=\"865\"\/><\/figure><\/div>\n\n\n\n<div class=\"\"><figure class=\"aligncenter is-resized\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/MS-Excel-kaise-seekhe-Changed-chart-design-2.jpg\" alt=\"\" width=\"1082\" height=\"809\"\/><\/figure><\/div>\n\n\n\n<p>Ab iske saath hum ye lesson conculde karte hain. Iss lesson mein humne sikha excel kya hai, excel worksheet mein kaise kaam karte hain aur aapki marksheet ka example lekar humne aapko kaafi basic cheezein apply karna batayi.  <\/p>\n\n\n\n<p>Agar aap chahein toh ye raw data aur final excel data sheet download kar sakte hain aur check kar sakte hain apne answers.<br>Sheets ka link niche diya hua hai.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART1-RAW.xlsx\">CLICK HERE TO DOWNLOAD BEGINNER PART 1 RAW DATA SHEET <\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART1-RAW.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART1-FINAL.xlsx\">CLICK HERE TO DOWNLOAD BEGINNER PART 1 FINAL DATA SHEET <\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART1-FINAL.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<p><em><strong>I hope iss article ko padkar aapko excel ke basics ka idea hogaya hoga. Aur agar aapko iss article ya Excel se related koi bhi query ya doubt hai to aap niche comments section mein comment zarur kare.<\/strong><\/em><strong><br><\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<p><strong>Yeh tutorial Hindi MS Excel full course in Hindi ka pehla part tha. Isko complete karne ke baad aap baki 3 kar sakte hain. <\/strong>Niche diye gaye links par click karke aap uss tutorial par ja sakte hain. <\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-part-2-sort-filter-find-replace\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">MS Excel in Hindi full tutorial <\/a><strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-part-2-sort-filter-find-replace\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">Beginner course part 2<\/a><\/strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-part-2-sort-filter-find-replace\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\"> &#8211;  MS Excel ko use karke data analysis kaise karte hai (Sort aur Filter kaise kare)<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-in-hindi-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Advance course part 1 - MS Excel formulas basic level wale Hindi Mein (opens in a new tab)\">MS Excel in Hindi full tutorial <\/a><strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-in-hindi-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Advance course part 1 - MS Excel formulas basic level wale Hindi Mein (opens in a new tab)\">Advance course part 1<\/a><\/strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-in-hindi-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Advance course part 1 - MS Excel formulas basic level wale Hindi Mein (opens in a new tab)\"> &#8211; MS Excel formulas basic level wale Hindi Mein<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">MS Excel in Hindi full tutorial <\/a><strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">Advance  course part 2<\/a><\/strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\"> &#8211; MS Excel advance formulas in Hindi<\/a> <\/p>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<h2><strong><strong><strong>Join Josh Skills Basic Computer Skills Course<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img src=\"https:\/\/josh-skills.s3.ap-south-1.amazonaws.com\/files_from_node\/1596533210761Basic%20Computer%20Skills.jpg\" alt=\"\" width=\"517\" height=\"279\"\/><\/figure>\n\n\n\n<p>Aaj kal computer ka zamana hai. Har voh kaam jisme pehle bahut time,effort aur money waste hota tha abh asani se computer pe kiya ja sakta hai. Computer ka istamaal aaj kal har taraf kiya jata hai. Basic computer skills ana aaj ke waqt mai bahat hi zaruri hai. Basic computer skills sikhna isliye zaruri hai take aap apne worklife ko easy aur efficient bana sako. Aur is computer technology ka wisely istamaal kar sako. <\/p>\n\n\n\n<div class=\"wp-block-buttons\">\n<div class=\"wp-block-button is-style-outline\"><a class=\"wp-block-button__link\" href=\"https:\/\/joshskills.app.link\/9bX0aGyjkbb\" style=\"border-radius:50px\" target=\"_blank\" rel=\"noreferrer noopener\">Download Josh Skills App<\/a><\/div>\n<\/div>\n\n\n\n<p>Is course mai aap Computer ke Basics pe gaur denge jaise:<\/p>\n\n\n\n<ul><li>Basics of a Computer system and it\u2019s operation.<\/li><li>Internet Technology<\/li><li>Email and Communication<\/li><li>Use of Microsoft word, Microsoft Powerpoint and Microsoft Excel<\/li><li>Introduction to Advanced Computer skills and tools<\/li><li>Jobs that require computer skills<\/li><\/ul>\n\n\n\n<p>Toh aaj hi shuru kare apni learning journey Josh Skill ke courses ke sath.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn Excel For Free in Hindi ek Hafte Mein examples ke saath Naukri Chahiye to MS Excel Sikhni zaruri hai. Agar naukri mein tarakki chahiye to bhi aapko Excel master banna hoga. Chaliye sikhte hai MS Excel in Hindi is tutorial ke madhyam se. Yeh MS Excel tutorial baaki excel courses se behtar hai kyonki: [&hellip;]<\/p>\n","protected":false},"author":33,"featured_media":23218,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":""},"categories":[11004],"tags":[54],"yst_prominent_words":[493,496,263,3630,497,495,492,2707,2704,2883,498,501,502,148,135,494,499,2705,571,133],"_links":{"self":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/14820"}],"collection":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/users\/33"}],"replies":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/comments?post=14820"}],"version-history":[{"count":170,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/14820\/revisions"}],"predecessor-version":[{"id":40328,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/14820\/revisions\/40328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/media\/23218"}],"wp:attachment":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/media?parent=14820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/categories?post=14820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/tags?post=14820"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/yst_prominent_words?post=14820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}