{"id":16570,"date":"2019-07-15T14:48:50","date_gmt":"2019-07-15T09:18:50","guid":{"rendered":"https:\/\/www.joshtalks.com\/joshkosh\/?p=16570"},"modified":"2020-11-12T05:41:56","modified_gmt":"2020-11-12T00:11:56","slug":"ms-excel-in-hindi-full-tutorial-part-2-sort-filter-find-replace","status":"publish","type":"post","link":"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/computer-skills\/ms-excel-in-hindi-full-tutorial-part-2-sort-filter-find-replace\/","title":{"rendered":"MS Excel Tutorial Beginners Course Part 2 &#8211; Sort, Filter, Find, Replace"},"content":{"rendered":"\n<h2>Sort and Filter in Hindi + Find and Replace Kya Hai Sikhe with examples<\/h2>\n\n\n\n<p class=\"has-regular-font-size\">Yeh article humare free Excel course in Hindi ka 2nd part hai. <\/p>\n\n\n\n<p>Iss tutorial mein hum aapko sort and filter in Hindi, Excel mein filter kaise lagate hai aur find and replace kya hai sikhayenge ek example ke sath. Example ki sheet aap FREE mein download kar sakte hai aur apne computer mein saath saath practice kar sakte hai. <\/p>\n\n\n\n<p>Chaliye sikhte hai MS Excel in Hindi iss 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 2 ki zarurat hai agar<\/strong>:<\/p>\n\n\n\n<ul><li>Aapko <strong>MS excel ke basics thoda bahut aate hai<\/strong>n aur aap data ko analyse karna excel ke madhyam se Hindi mein sikhna chahtein hain<\/li><li><strong>Aap fresher hai<\/strong> aur excel ke baare mein zyada pata na hone se aapki naukri nahi lag rahi hai ya naukri ke liye aap excel sikhna chahte 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 second part hai. Isko complete karne ke baad aap baki 3 tutorial 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 href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-beginner-course-free-part-1\/\" 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-beginner-course-free-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">Beginner course part 1<\/a><\/strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-beginner-course-free-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\"> &#8211; Agar excel bilkul nahi aati<\/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=\" (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=\" (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=\" (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 2 mein kya sikhenge. <\/p>\n\n\n\n<h3><strong>Beginner Part 2 MS Excel tutorial in Hindi mein hum sikhenge<\/strong><\/h3>\n\n\n\n<p><a href=\"#sort-kaise-karte-hain\">Sort kaise karte hain in Hindi<\/a><\/p>\n\n\n\n<p><a href=\"#excel_mein_filter_kaise_lagate_hain\">Excel mein filter kaise lagate hain<\/a><\/p>\n\n\n\n<p><a href=\"#find-aur-replace-ka-kya-use-hai\">Find and Replace kya hai<\/a><\/p>\n\n\n\n<p>Inke baare me hum ek <strong>example<\/strong> ke through samjhenge.<\/p>\n\n\n\n<p>Pehle hum dekhte hain ki excel mein <strong>Sort, Filter, Find <\/strong>aur<strong> Replace<\/strong> option hote kya hain.<\/p>\n\n\n\n<h3><strong>SORT AND FILTER<\/strong> <strong>IN HINDI<\/strong><\/h3>\n\n\n\n<h4><strong>Sort<\/strong><\/h4>\n\n\n\n<p class=\"sort\">Sort data ka option <strong>Home tab<\/strong> mein sabse right side hota hai, ye humne aapko apne last article mein bataya that. Sort ke feature se aap apne data ko text, numbers, ya colors ke basis par sort kar sakte hain. Excel mein data ko sort karke aap apne according jaankari pata 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\/Excel-Home-tab-Sort-and-Filter-icon.jpg\" alt=\"\" class=\"wp-image-16708\" width=\"1042\" height=\"987\"><\/figure><\/div>\n\n\n\n<h4 class=\"filter\" style=\"    margin-top: 0%;\"><strong>Filter<\/strong><\/h4>\n\n\n\n<p>Excel mein kisi database mein se apne use ke according data ko extract ya nikalne ke liye <strong>Filter<\/strong> ka use kar sakte hain. Ye option bahut powerful option hai.<\/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\/Excel-Home-tab-Filter.jpg\" alt=\"\" class=\"wp-image-16702\" width=\"1059\" height=\"1003\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Home-tab-Filter.jpg 505w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Home-tab-Filter-300x285.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Home-tab-Filter-443x420.jpg 443w\" sizes=\"(max-width: 1059px) 100vw, 1059px\" \/><\/figure><\/div>\n\n\n\n<h3><br><strong>FIND AND REPLACE<\/strong> <strong>KYA HAI<\/strong><\/h3>\n\n\n\n<h4><strong>Find<\/strong><\/h4>\n\n\n\n<p>Excel mein Home tab mein <strong>Find and\nSelect<\/strong> command ka use text ya number ko search karke select karne ke liye\nkiya ja sakta hai, ise directly aap <strong>Ctrl+F<\/strong> press karke bhi directly open\nkar sakte hain. Excel mein <strong>Find and Select<\/strong> bahut useful command hai.<\/p>\n\n\n\n<h4><strong>Replace<\/strong><\/h4>\n\n\n\n<p>Ye option aapko <strong>Home tab<\/strong> mein <strong>Find and\nSelect<\/strong> ke under miljayega ya agar aap <strong>Ctrl+H<\/strong> press karenge toh bhi\nye option screen par appear hojayega. Iss option ka use kisi bhi already\npresent text ko replace karne ke liye kiya jata hai.<\/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\/Example-Replace-option.jpg\" alt=\"\" class=\"wp-image-16708\" width=\"1042\" height=\"987\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option.jpg 485w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-300x284.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-444x420.jpg 444w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/div>\n\n\n\n<p><br><strong><em>Chaliye ab ye sab cheezein detail mein ek example lekar samjhein kyonki example se sabse acchi tarah aapko saare features samajh aayenge.<\/em><\/strong><\/p>\n\n\n\n<h3>Excel mein sort aur filter example se sikhe <\/h3>\n\n\n\n<p>Main example le rahi hun 10<sup>th<\/sup> class ke students ka marks record jise humne kuch aise enter kiya hai. <\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART-2-Raw.xlsx\"> CLICK HERE TO DOWNLOAD BEGINNER PART 2 RAW DATA SHEET <\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART-2-Raw.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\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\/Excel-Example-of-teachers-record-1.jpg\" alt=\"\" class=\"wp-image-16755\" width=\"1043\" height=\"840\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Example-of-teachers-record-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Example-of-teachers-record-1-300x242.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Excel-Example-of-teachers-record-1-521x420.jpg 521w\" sizes=\"(max-width: 1043px) 100vw, 1043px\" \/><\/figure><\/div>\n\n\n\n<h4><br><strong>Iss data se hum kayi cheezein apply karenge jaise-<\/strong><\/h4>\n\n\n\n<ul><li><strong>Merge and Center kaise kare \u2013 Merge and Center option<\/strong><br><\/li><li><strong>Alphabetically apne data ko kaise arrange kare- Sort option<\/strong><br><\/li><li><strong>Total kaise nikalein -SUM fn<\/strong><br><\/li><li><strong>Percentage kaise nikalein- Multiplication operator<\/strong><br><\/li><li><strong>Grading aur pass\/fail kaise pata kare \u2013 IF and IFS function use<\/strong><br><\/li><li><strong>Kaise sirf males ya females ka data nikalein -Filter option<\/strong><br><\/li><li><strong>Kaise kisi bhi student ka data find kare \u2013 Find option<\/strong><br><\/li><li><strong>Kaise kisi student ke wrongly entered data ko correct kare &#8211; Replace option<\/strong><\/li><\/ul>\n\n\n\n<p>Chaliye dekhein pehli jaankari-<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Merge and Center kaise kare \u2013 Merge and Center option<\/strong><\/p>\n\n\n\n<p>Hum ismein <strong>Merge\nand Center<\/strong> ka use karke kuch cells ko merge kar sakte hai jaise ki maine\nkiya <strong><em>Subject Marks<\/em><\/strong> ko, kyonki saare subjects marks <strong><em>Subject\nMarks<\/em><\/strong> ke under hi aayenge. Dekhiye aise \u2013<\/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\/Example-Merge-and-center-before-1.jpg\" alt=\"\" class=\"wp-image-16761\" width=\"1054\" height=\"824\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-before-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-before-1-300x235.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-before-1-537x420.jpg 537w\" sizes=\"(max-width: 1054px) 100vw, 1054px\" \/><\/figure><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<p>Aise hi aap\nye <strong><em>S.no.<\/em><\/strong> aur <strong><em>Name<\/em><\/strong> ke liye bhi kar sakte hain.<\/p>\n\n\n\n<p>Ye phir kuch\naisa lagega-<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-Final-1.jpg\" alt=\"\" class=\"wp-image-16773\" width=\"1036\" height=\"860\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-Final-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-Final-1-300x249.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Merge-and-center-Final-1-506x420.jpg 506w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><br><strong><em>Chaliye ab dekhein kaise hum apne data cleaning kar sakte hain<\/em><\/strong>.<\/p>\n\n\n\n<h3> <a name=\"sort-kaise-karte-hain\">Sort kaise karte hain<\/a><\/h3>\n\n\n\n<p>Agar aapko pata nahi hai ki SORT kya hota hai to yaha click kare<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Alphabetically apne data ko kaise arrange kare -Sort option<\/strong><\/p>\n\n\n\n<p>Agar aap sab\nstudents ka data unke name ke according alphabetically arrange karna chahte\nhain toh iske liye aap pehle jiss data ko sort kana chahte hai vo select kare,\nye selection aapko dhyan se karna hoga. Maine students ke names (excluding the\nheading <em>Name<\/em>) aur unke corresponding marks ke cells (excluding names of\nsubject) ko select kiya hai kuch aise-<\/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\/Example-Sort-and-Filetr-Sort-1-1.jpg\" alt=\"\" class=\"wp-image-16779\" width=\"1036\" height=\"770\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-300x224.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-80x60.jpg 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-160x120.jpg 160w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-265x198.jpg 265w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-485x360.jpg 485w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-1-1-564x420.jpg 564w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/figure><\/div>\n\n\n\n<p>Ab selection karne ke baad jayein Home tab &gt; Sort and Filter &gt; Sort A to Z.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-2-1.jpg\" alt=\"\" class=\"wp-image-16785\" width=\"1052\" height=\"505\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-2-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-2-1-300x144.jpg 300w\" sizes=\"(max-width: 1052px) 100vw, 1052px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Ye finally kuch aisa dikhne lagega-<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\/Example-Sort-and-Filetr-Sort-3.jpg\" alt=\"\" class=\"wp-image-16791\" width=\"1042\" height=\"953\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-3-300x275.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sort-and-Filetr-Sort-3-459x420.jpg 459w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/div>\n\n\n\n<p style=\"font-size:18px\"><strong>Total kaise nikalein -SUM function<\/strong><\/p>\n\n\n\n<p>Aap in saare marks ka total nikal sakte hai SUM function ka use\nkarke. <\/p>\n\n\n\n<p>SUM function apply karne ke liye aapko jiss cell mein TOTAL MARKS\nchahiye uss cell mein ye type karna hoga \u2013<\/p>\n\n\n\n<p><strong>&nbsp;=SUM(C10:G10)&nbsp; <\/strong><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\/Example-SUM-function.jpg\" alt=\"\" class=\"wp-image-16797\" width=\"1030\" height=\"792\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-SUM-function.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-SUM-function-300x231.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-SUM-function-545x420.jpg 545w\" sizes=\"(max-width: 1030px) 100vw, 1030px\" \/><\/figure><\/div>\n\n\n\n<p><strong>NOTE:<\/strong> Mere cells\njinmein subject marks hain unki range C10 to G10 hai isliye upar mere function\nmein C10:G10 hain. Aapke cells ki range alag bhi ho sakti hai. Iskeliye sabse\nbest hai ki aap <strong>=SUM(&nbsp;&nbsp; <\/strong>likhar\njiss range ka sum karna chahte hai usse select karlein, isse aapki required\nrange apne aap function mein appear hojayegi jaise meri hui-<\/p>\n\n\n\n<p>&nbsp;<strong>=SUM(C10:G10<\/strong><\/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\/Example-Sum-fn-1.jpg\" alt=\"\" class=\"wp-image-16803\" width=\"1008\" height=\"573\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-1-300x170.jpg 300w\" sizes=\"(max-width: 1008px) 100vw, 1008px\" \/><\/figure><\/div>\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\/Example-Sum-fn-2.jpg\" alt=\"\" class=\"wp-image-16809\" width=\"1001\" height=\"937\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-2-300x281.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-2-449x420.jpg 449w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/figure><\/div>\n\n\n\n<p><br>Ismein bracket close kijiye aise\u2013<\/p>\n\n\n\n<p><strong>=SUM(C10:G10)<\/strong><\/p>\n\n\n\n<p>Ab <strong>Enter<\/strong> press kariye. Aapko apna total miljayega.<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\/Example-Sum-fn-3.jpg\" alt=\"\" class=\"wp-image-16816\" width=\"1002\" height=\"797\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-3-300x239.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Sum-fn-3-528x420.jpg 528w\" sizes=\"(max-width: 1002px) 100vw, 1002px\" \/><\/figure><\/div>\n\n\n\n<p>Ye function saare students ke liye apply karne ke liye, pehle aap\napne total kiye hue cell ko select kare aur fir use niche jahan tak same\nformula apply karna hai drag kare, ye cheez <strong>Fill<\/strong> feature ki wajah se\nhoti hai. Aap niche jahan tak drag karenge vaha tak automatically ye formula\nfill feature se baaki cells mein apply hojayega.<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Percentage\nkaise nikalein- Multiplication operator<\/strong><\/p>\n\n\n\n<p>Percentage nikalne se pehle main\nek column max. marks ka add kar rahi hun aise-<\/p>\n\n\n\n<p>Percentage nikalne ke liye aapko\nye formula use karna hoga &#8211;<\/p>\n\n\n\n<p class=\"has-text-align-left\"><strong>% of total marks scored = (Total marks scored\/MAx. Marks)&nbsp;* 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;       &nbsp;&nbsp;             <\/strong><\/p>\n\n\n\n<p>Isse excel mein apply karne ke\nliye aap pehle jiss cell mein aapko percentage nikalni hai usmein operators ka\nuse karke formula likhein jaise maine kiya-<\/p>\n\n\n\n<p><strong>=(H10\/I10)*100<\/strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;    <br> &nbsp;<\/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\/Example-Percentage-using-operators-1.jpg\" alt=\"\" class=\"wp-image-16822\" width=\"987\" height=\"830\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-1-300x253.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-1-498x420.jpg 498w\" sizes=\"(max-width: 987px) 100vw, 987px\" \/><\/figure><\/div>\n\n\n\n<p><br> Iske baad press <strong>Enter<\/strong> aur aapko apni percentage miljayegi. <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\/Example-Percentage-using-operators-2.jpg\" alt=\"\" class=\"wp-image-16830\" width=\"977\" height=\"912\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-2-300x281.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-2-449x420.jpg 449w\" sizes=\"(max-width: 977px) 100vw, 977px\" \/><\/figure><\/div>\n\n\n\n<p><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\/Example-Percentage-using-operators-3.jpg\" alt=\"\" class=\"wp-image-16836\" width=\"999\" height=\"974\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-3-300x293.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-3-430x420.jpg 430w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/figure><\/div>\n\n\n\n<p><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\/Example-Percentage-using-operators-4.jpg\" alt=\"\" class=\"wp-image-16843\" width=\"1042\" height=\"1026\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-4.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-4-300x296.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Percentage-using-operators-4-426x420.jpg 426w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/div>\n\n\n\n<p>Ise sab students ke liye apply karne ke liye jiss cell mein abhi aapne percentage ka formula apply kara usse niche drag karde jahan tak aapko ye formula similarly apply karna hai.<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Grading aur\npass\/fail kaise pata kare \u2013 IF and IFS function ka use<\/strong><\/p>\n\n\n\n<p><strong>GRADING<\/strong><\/p>\n\n\n\n<p>Grading karne ke liye aapko IFS ka formula use karna hoga.<\/p>\n\n\n\n<p>Humne yahan apna grading system ye liya hai-<\/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\/Example-Grading-criteria.jpg\" alt=\"\" class=\"wp-image-16879\" width=\"1064\" height=\"101\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Grading-criteria.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Grading-criteria-300x29.jpg 300w\" sizes=\"(max-width: 1064px) 100vw, 1064px\" \/><\/figure><\/div>\n\n\n\n<p>Ab chaliye dekhein ki kaise IFS\nfunction grading ke liye apply kare.<\/p>\n\n\n\n<p>Iss function ko lagaane ke liye\naapko jiss column mein grades chahiye usmein above criteria ke according ye\nstatement likhni hogi-<\/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\/Example-Ifs-function-1-1.jpg\" alt=\"\" class=\"wp-image-16885\" width=\"1064\" height=\"535\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-1-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-1-1-300x151.jpg 300w\" sizes=\"(max-width: 1064px) 100vw, 1064px\" \/><\/figure><\/div>\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\/Example-Ifs-function-3-1.jpg\" alt=\"\" class=\"wp-image-16891\" width=\"1047\" height=\"54\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-3-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-3-1-300x16.jpg 300w\" sizes=\"(max-width: 1047px) 100vw, 1047px\" \/><\/figure><\/div>\n\n\n\n<p><strong>NOTE:<\/strong> Ye function excel ke latest version mein hi hai. Aap apni columns ke according ye function lagayein jaise meri percentage J10 mein thi jiske according maine IFS function mein har jagah J10 cell ka use kara hai.<\/p>\n\n\n\n<p>Ye function lagane par aapko ye\nmilega-<\/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\/Example-Ifs-function-4-1.jpg\" alt=\"\" class=\"wp-image-16898\" width=\"1047\" height=\"894\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-4-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-4-1-300x256.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-4-1-492x420.jpg 492w\" sizes=\"(max-width: 1047px) 100vw, 1047px\" \/><\/figure><\/div>\n\n\n\n<p>Ye sab mein apply karne ke liye\naap iss cell ko niche drag kar sakte hain dekhiye aise-<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-5-1.jpg\" alt=\"\" class=\"wp-image-16910\" width=\"1075\" height=\"990\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-5-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-5-1-300x277.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Ifs-function-5-1-456x420.jpg 456w\" sizes=\"(max-width: 1075px) 100vw, 1075px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><strong><br>PASS\/FAIL<\/strong><\/p>\n\n\n\n<p>Grading ke baad aapke liye\npass\/fail nikalna bahut easy hoga. Ye aap IF function ka use karke bahut easily\nkar sakte hain.<\/p>\n\n\n\n<p><strong>NOTE:<\/strong> Maine yahan apne data ko thoda manipulate kiya hai taaki aapko\nPASS\/FAIL zyaada acchi tarah se pata chale kyonki humare pehle ke data ke\naccording sab pass hain.<\/p>\n\n\n\n<p>Maine pass\/fail criteria ye liya\nhai-<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-crieteria-1.jpg\" alt=\"\" class=\"wp-image-16922\" width=\"1048\" height=\"686\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-crieteria-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-crieteria-1-300x197.jpg 300w\" sizes=\"(max-width: 1048px) 100vw, 1048px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><br>Isko apply karne ke liye pehle aap uss cell par jayiye jahan aapko ye nikalna hai aur wahan ye formula likh dijiye-<br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function.jpg\" alt=\"\" class=\"wp-image-16928\" width=\"1080\" height=\"242\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-300x67.jpg 300w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/><\/figure><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-1.1.jpg\" alt=\"\" class=\"wp-image-16934\" width=\"1058\" height=\"211\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-1.1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-1.1-300x60.jpg 300w\" sizes=\"(max-width: 1058px) 100vw, 1058px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Press <strong>Enter<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4.jpg\" alt=\"\" class=\"wp-image-16956\" width=\"1042\" height=\"787\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4-300x227.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4-80x60.jpg 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4-160x120.jpg 160w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PassFail-4-556x420.jpg 556w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Isko aap niche drag karke saare students ke liye bhi nikal sakte hain.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-2.jpg\" alt=\"\" class=\"wp-image-16940\" width=\"1043\" height=\"826\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-2-300x238.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-PASS-FAIL-function-2-531x420.jpg 531w\" sizes=\"(max-width: 1043px) 100vw, 1043px\" \/><\/figure><\/figure><\/div>\n\n\n\n<h3 id=\"-excel_mein_filter_kaise_lagate_hain\"><br><strong><a name=\"filter-kaise-lagate-hain\">Filter kaise lagate hain<\/a><\/strong><\/h3>\n\n\n\n<p style=\"font-size:18px\"><strong>Kaise sirf\nmales ya females ka data nikalein &#8211; Filter option<\/strong><\/p>\n\n\n\n<p>Iske liye pehle aap ismein ek blank\ncolumn <strong>Insert<\/strong> karlein GENDER ke liye aise-<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row.jpg\" alt=\"\" class=\"wp-image-16971\" width=\"1024\" height=\"1074\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row-286x300.jpg 286w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row-401x420.jpg 401w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row2.jpg\" alt=\"\" class=\"wp-image-16978\" width=\"1028\" height=\"1215\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row2-254x300.jpg 254w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Insert-a-row2-355x420.jpg 355w\" sizes=\"(max-width: 1028px) 100vw, 1028px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><strong> <\/strong>Ab Insert karne ke baad aap ismein gender related data type karde.<br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column.jpg\" alt=\"\" class=\"wp-image-16984\" width=\"1013\" height=\"1034\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column-294x300.jpg 294w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column-356x364.jpg 356w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Gender-column-412x420.jpg 412w\" sizes=\"(max-width: 1013px) 100vw, 1013px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Males\/Females\/Other ka data <strong>Filter<\/strong>\nkarne ke liye aap apne data ko sahi se select kare aise \u2013<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-1-Select.jpg\" alt=\"\" class=\"wp-image-16990\" width=\"1061\" height=\"446\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-1-Select.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-1-Select-300x127.jpg 300w\" sizes=\"(max-width: 1061px) 100vw, 1061px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Iske baad aap ye kare- <strong>Home tab &gt; Sort and Filter &gt; Filter<\/strong>. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-2.jpg\" alt=\"\" class=\"wp-image-16996\" width=\"1070\" height=\"545\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-2-300x153.jpg 300w\" sizes=\"(max-width: 1070px) 100vw, 1070px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Iske baad aap dekhenge ki aapki\nscreen par headings ke paas small scroll buttons appear ho rahein honge aise-<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-3.jpg\" alt=\"\" class=\"wp-image-17002\" width=\"1066\" height=\"487\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-3-300x137.jpg 300w\" sizes=\"(max-width: 1066px) 100vw, 1066px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Ye scroll buttons filter options\nhain. Ab jaise mujhe sirf females ka data chayiye ya females data filter karna\nhai toh aap GENDER ke side ke scroll par click karke sirf \u2018Female\u2019 par tick karde\naur isse aapko sirf females ka data miljayega aise-<br>\n<br>\n<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4.jpg\" alt=\"\" class=\"wp-image-17008\" width=\"952\" height=\"952\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4-150x150.jpg 150w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4-300x300.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-4-420x420.jpg 420w\" sizes=\"(max-width: 952px) 100vw, 952px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-5.jpg\" alt=\"\" class=\"wp-image-17015\" width=\"955\" height=\"930\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-5.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-5-300x292.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-5-432x420.jpg 432w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Female ka filter lagane ke baad aapko screen par bas females ka\ndata dikhayi dega &#8211;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-6.jpg\" alt=\"\" class=\"wp-image-17030\" width=\"1043\" height=\"353\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-6.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-6-300x102.jpg 300w\" sizes=\"(max-width: 1043px) 100vw, 1043px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Aise hi aap failed students ke liye filter laga sakte hain, ye aap\n\u2018PASS\/FAIL\u2019 ke scroll mein jakar select kar sakte hain aise-<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-7.jpg\" alt=\"\" class=\"wp-image-17037\" width=\"1072\" height=\"258\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-7.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Filter-7-300x73.jpg 300w\" sizes=\"(max-width: 1072px) 100vw, 1072px\" \/><\/figure><\/figure><\/div>\n\n\n\n<h3><strong><a name=\"find-aur-replace-ka-kya-use-hai\">Find aur\nReplace ka kya use hai<\/a><\/strong><a name=\"find-aur-replace-ka-kya-use-hai\"><strong><\/strong><\/a><\/h3>\n\n\n\n<p style=\"font-size:19px\"><strong>Kaise kisi\nstudent ka data find kare \u2013 Find option<\/strong><\/p>\n\n\n\n<p>Chaliye ab jaane ki kaise hum kisi\nbhi student ka data uske name ke through find kare. Yeh feature sabse zyada\nuseful hota hai jab aapke paas bahut sara data ho aur aap khud saare data mein\nse aise hi dekhakar kisi specific cheez usko find na kar sake.<\/p>\n\n\n\n<p>Iske liye pehle aap jayein <strong>Home\ntab &gt; Find and Select &gt; Find<\/strong>. Ya agar aap iskeliye <strong>Ctrl+F<\/strong>\nshortcut key ka use karenge toh bhi <strong>Find<\/strong> option ki window screen par\nappear hojayegi.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-1.jpg\" alt=\"\" class=\"wp-image-17045\" width=\"1038\" height=\"1092\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-1-285x300.jpg 285w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-1-399x420.jpg 399w\" sizes=\"(max-width: 1038px) 100vw, 1038px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p><br>Find option par click karne se aapke screen par yeh window appear hogi &#8211;<br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-2.jpg\" alt=\"\" class=\"wp-image-17051\" width=\"1080\" height=\"404\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-2-300x112.jpg 300w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>\u2018Find what\u2019 ke corresponding aap\nvo text type kariye jiske baare mein aapko janana hai. Maine yahan \u201cKrish\u201d type\nkiya hai. \u201cKrish\u201d type karte hi aap observe karenge ki aapki cell select\ndirectly uss cell par jismein \u201cKrish\u201d likha hai uss par chala jayegega aise-<br>\n<br>\n<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-3-Krish.jpg\" alt=\"\" class=\"wp-image-17057\" width=\"1055\" height=\"538\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-3-Krish.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Find-option-3-Krish-300x153.jpg 300w\" sizes=\"(max-width: 1055px) 100vw, 1055px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Ab jab aapko \u201cKrish\u201d ke cell ki\nposition milgayi hai toh usse related information easily dekh sakte hain.<\/p>\n\n\n\n<p>Iss option se agar aapne kisi ka\ndata wrong enter kiya hai toh uske name ko find karke aur fir uski details edit\nkar sakte hain.<\/p>\n\n\n\n<p style=\"font-size:18px\"><strong>Kaise kisi\nstudent ke wrongly entered data ko correct kare &#8211; Replace option<\/strong><\/p>\n\n\n\n<p>Chaliye ab dekhte hai iss article ka last topic.<\/p>\n\n\n\n<p>Imagine kare ki aapne galti se kisi student ka name galat likh\ndiya hai aur aapko usee replace karna hai, toh iskeliye aap <strong>Replace<\/strong> option\nuse kar sakte hain.<\/p>\n\n\n\n<p>For example, maine \u201cKrishna\u201d ka naam galti se Krish enter kardiya,\ntoh main ise replace karne ke liye jaungi &#8211; <strong>Home tab &gt; Find and Select\n&gt; Replace<\/strong> . Ya aap iss option ke liye <strong>Ctrl+H<\/strong> shortcut key ka bhi\nuse kar sakte hain.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-1.jpg\" alt=\"\" class=\"wp-image-17065\" width=\"1030\" height=\"974\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-1-300x284.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-1-444x420.jpg 444w\" sizes=\"(max-width: 1030px) 100vw, 1030px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Replace option par click karne ke baad ek small window appear\nhogi-<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img width=\"600\" height=\"222\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option2.jpg\" alt=\"\" class=\"wp-image-17071\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option2.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option2-300x111.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p>Ab ismein \u2018<strong>Find what<\/strong>\u2019 ke corresponding vo type karein jise\naap replace karna chahte hai. \u2018<strong>Replace with<\/strong>\u2019 mein vo type kare jo\ncorrected text hai ya jiss text se aap pehle wale ko replace karna chahte hain.\nYahan main \u201cKrish\u201d ki jagah \u201cKrishna\u201d replace karna chahti hun. Ye option sabse\nzyada useful hota hai jab humne same spelling mistake kayi jagah ki ho, usse \u2018<strong>Replace\nall\u2019 <\/strong>karke aap ek saath change kar sakte hain.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><figure><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-4-Krishna.jpg\" alt=\"\" class=\"wp-image-17077\" width=\"1087\" height=\"570\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-4-Krishna.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-4-Krishna-300x158.jpg 300w\" sizes=\"(max-width: 1087px) 100vw, 1087px\" \/><\/figure><\/figure><\/div>\n\n\n\n<p>Click <strong>Replace.<\/strong><\/p>\n\n\n\n<p>Iske baad aap dekhenge ki \u201cKrish\u201d change hojayega \u201cKrishna\u201d mein.<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\/Example-Replace-option-5-changed-Krishna.jpg\" alt=\"\" class=\"wp-image-17083\" width=\"1059\" height=\"611\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-5-changed-Krishna.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/Example-Replace-option-5-changed-Krishna-300x173.jpg 300w\" sizes=\"(max-width: 1059px) 100vw, 1059px\" \/><\/figure><\/div>\n\n\n\n<p>Aise hi aap aur bhi examples lekar apne data ko Sort aur Filter kar sakte hain, aur data ko clean aur useful way mein store kar sakte hain.<\/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-PART-2-Raw.xlsx\"> CLICK HERE TO DOWNLOAD BEGINNER PART 2 RAW DATA SHEET <\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/BEG-PART-2-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\/06\/BEG-PART-2-Final.xlsx\">CLICK HERE TO DOWNLOAD BEGINNER PART 2 FINAL DATA SHEET  <\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/06\/BEG-PART-2-Final.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<p class=\"has-regular-font-size\"><em><strong>Isse hum apna article finish karte hai, I hope ye article aapko helpful laga hoga aur ise padkar aapko excel ke kuch advance basics samajh aagaye honge. Aur agar aapko iss article ya Excel se related koi bhi query ya doubt hai to aap niche comments section mein comment zarur kare.<br><\/strong><\/em> <\/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 seconda 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-beginner-course-free-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Beginner course part 1 - Agar excel bilkul nahi aati (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-beginner-course-free-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Beginner course part 1 - Agar excel bilkul nahi aati (opens in a new tab)\">Beginner course part 1<\/a><\/strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-in-hindi-full-tutorial-beginner-course-free-part-1\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Beginner course part 1 - Agar excel bilkul nahi aati (opens in a new tab)\"> &#8211; Agar excel bilkul nahi aati<\/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=\"MS Excel in Hindi full tutorial Advance  course part 2 - MS Excel advance formulas in Hindi (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=\"MS Excel in Hindi full tutorial Advance  course part 2 - MS Excel advance formulas in Hindi (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=\"MS Excel in Hindi full tutorial Advance  course part 2 - MS Excel advance formulas in Hindi (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>Sort and Filter in Hindi + Find and Replace Kya Hai Sikhe with examples Yeh article humare free Excel course in Hindi ka 2nd part hai. Iss tutorial mein hum aapko sort and filter in Hindi, Excel mein filter kaise lagate hai aur find and replace kya hai sikhayenge ek example ke sath. Example ki [&hellip;]<\/p>\n","protected":false},"author":33,"featured_media":23230,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":""},"categories":[11004],"tags":[54],"yst_prominent_words":[263,264,261,262,2707,2704,2927,2886,191,2747,2885,2883,148,135,260,259,131,2708,2705,133],"_links":{"self":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/16570"}],"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=16570"}],"version-history":[{"count":95,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/16570\/revisions"}],"predecessor-version":[{"id":40327,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/16570\/revisions\/40327"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/media\/23230"}],"wp:attachment":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/media?parent=16570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/categories?post=16570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/tags?post=16570"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/yst_prominent_words?post=16570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}