{"id":18394,"date":"2019-07-15T13:19:12","date_gmt":"2019-07-15T07:49:12","guid":{"rendered":"https:\/\/www.joshtalks.com\/joshkosh\/?p=18394"},"modified":"2020-11-12T05:44:22","modified_gmt":"2020-11-12T00:14:22","slug":"ms-excel-formulas-advanced-tutorial-in-hindi-part-1","status":"publish","type":"post","link":"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/computer-skills\/ms-excel-formulas-advanced-tutorial-in-hindi-part-1\/","title":{"rendered":"MS Excel Formulas In Hindi &#8211; Advance Excel Tutorial Part 1"},"content":{"rendered":"\n<h2>Excel formulas with examples in Hindi sikhe <\/h2>\n\n\n\n<p>Iss advance MS Excel tutorial in Hindi mein hum aapko Excel formulas ke baare mein examples ke saath batayenge jisse aap MS Excel mein expert ban jaoge. <\/p>\n\n\n\n<p><strong>Yeh Advance 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><\/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 third part hai. Isko complete karne ke baad aap baaki 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-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-part-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MS Excel in Hindi full tutorial Advance course part 2 - MS Excel ke advance formulas (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 ke advance formulas (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 ke advance formulas (opens in a new tab)\"> &#8211; MS Excel ke advance formulas<\/a>  <\/p>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<p>Yeh ms excel formulas in Hindi ko humne aapke liye level wise divide kar diye hain-<\/p>\n\n\n\n<p class=\"has-regular-font-size\"><strong>Beginner level formulas aur functions<\/strong><\/p>\n\n\n\n<p class=\"has-regular-font-size\"><strong>Intermediate level formulas aur functions<\/strong><\/p>\n\n\n\n<p class=\"has-regular-font-size\"><strong>Advanced level formulas aur functions<\/strong><\/p>\n\n\n\n<p>Ye sab level ke formulas aur functions hum examples ke through samjhenge kyonki maine pehle bhi kaha hai ki bina examples aur practice ke aap excel efficiently nahi sikh sakte.<\/p>\n\n\n\n<p> <strong><a rel=\"noreferrer noopener\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.joshtalks.joshskills&amp;hl=en&amp;_branch_match_id=688826483773283510&amp;utm_medium=marketing\" target=\"_blank\">Josh talks ke courses harazo logo ko help kar rahe hai career mai aage badne ke liye. Iss link par click karke App download kare aur janiye courses ke baare mein<\/a><\/strong>  <\/p>\n\n\n\n<p>Ye saare formulas aapko <strong>Formula Tab<\/strong> mein bhi miljayenge ya phir aap manually bhi ye formulas laga sakte hain jaise maine iss article mein kiya 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\/07\/Formulas-tab-1.jpg\" alt=\"\" width=\"1079\" height=\"134\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:20px\"><strong>SYNTAX<\/strong><\/p>\n\n\n\n<p>Sabse pehle mein bata chahungi ki har formula ya function ka ek\nunique syntax hota hai &#8211; ye excel mein ek function ka layout hota hai. Isse ek\nfunction ke arguments ka order pata chalta hai. Kisi bhi function mein syntax\nfollow karna bahut important hota hai aur humein apni arguments ko isi order\nmein likhna hota 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\/07\/Syntax.jpg\" alt=\"\" width=\"1080\" height=\"322\"\/><\/figure><\/div>\n\n\n\n<p>Chaliye ab start kare pehle beginner level formulas aur functions\nse.<\/p>\n\n\n\n<h3><strong>Beginner level formulas aur functions<\/strong><\/h3>\n\n\n\n<p>Beginner level mein hum niche diye gaye formulas aur functions apply karna sikhenge \u2013<\/p>\n\n\n\n<p style=\"font-size:30px\"><strong>Text functions:<\/strong><\/p>\n\n\n\n<p><strong>TRIM- removes leading spaces, extra spaces and trailing spaces<\/strong><br><\/p>\n\n\n\n<p style=\"font-size:30px\"><strong>Date and time functions:<\/strong><\/p>\n\n\n\n<p><strong>DATE- <\/strong><strong>for entering date in date format<\/strong><\/p>\n\n\n\n<p><strong>TIME- <\/strong><strong>for entering time with hours to am\/pm format<\/strong><\/p>\n\n\n\n<p><strong>TODAY- for entering today\u2019s date<\/strong><\/p>\n\n\n\n<p><strong>NOW- for entering both current date and current time in a single cell<\/strong><br><\/p>\n\n\n\n<p style=\"font-size:30px\"><strong>Autosum functions:<\/strong><\/p>\n\n\n\n<p><strong>SUM \u2013 <\/strong><strong>for summing up selected cells<\/strong><\/p>\n\n\n\n<p><strong>SUMIF- <\/strong><strong>for summing cells with a criteria<\/strong><\/p>\n\n\n\n<p><strong>SUMIFS- <\/strong><strong>for summing cells with more than one criteria<\/strong><\/p>\n\n\n\n<p><strong>COUNT- <\/strong><strong>for counting the number of cells that contain numbers<\/strong><\/p>\n\n\n\n<p><strong>COUNTA- <\/strong><strong>for counting cells that contain numbers, text, logical values,\nerror values, and empty text (&#8220;&#8221;).<\/strong><\/p>\n\n\n\n<p><strong>COUNTIF-<\/strong><strong>for counting cells based on one criteria<\/strong><\/p>\n\n\n\n<p><strong>COUNTIFS- <\/strong><strong>for counting cells with more than one criteria<\/strong><\/p>\n\n\n\n<p><strong>AVERAGE-<\/strong><strong> for finding average of selected cells<\/strong><\/p>\n\n\n\n<p><strong>AVERAGEIF-<\/strong><strong> for finding average of cells with a criteria<\/strong><\/p>\n\n\n\n<p><strong>AVERAGEIFS-<\/strong><strong> for finding average of cells with more than one criteria<\/strong><\/p>\n\n\n\n<p><strong>MAX- <\/strong><strong>for finding maximum no. amongst selected cells<\/strong><\/p>\n\n\n\n<p><strong>MIN- <\/strong><strong>for finding minimum no. amongst selected cells<\/strong><\/p>\n\n\n\n<p>Chaliye ab ye saare formulas aur functions hum examples ke sath\ndekhte hai.<\/p>\n\n\n\n<p>Main yahan teachers ke class record ki report ka ek simple example\nliya hai.<\/p>\n\n\n\n<p>Ye mera raw data 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\/07\/EXAMLE-Trim-2-2.jpg\" alt=\"\" width=\"1081\" height=\"470\"\/><\/figure><\/div>\n\n\n\n<h3><strong>1.TEXT FUNCTIONS<\/strong><\/h3>\n\n\n\n<p class=\"has-text-align-left\"><strong> TRIM function<\/strong><\/p>\n\n\n\n<p>Aap dekh saktein hai humare data mein bahut saari <strong>unnecessary extra spaces<\/strong> 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\/07\/EXAMLE-Trim-2-3.jpg\" alt=\"\" width=\"1082\" height=\"470\"\/><\/figure><\/div>\n\n\n\n<p>Aap <strong>TRIM<\/strong> function use karke apne data mein ye <strong>extra\nspaces remove<\/strong> karsakte hain. Isse use karne ke liye pehle aap kisi random\ncell me jakar likhein-<\/p>\n\n\n\n<p><strong>=TRIM(<\/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\/07\/EXAMLE-Trim-3-2.jpg\" alt=\"\" width=\"1086\" height=\"555\"\/><\/figure><\/div>\n\n\n\n<p>Ab ismein vo cell no. likhein jiske aap extra spaces remove karna\nchahtein hain jaise mein pehle \u201cS.no.\u201d&nbsp;\nwaale cell ko select kiya hai &#8211;<\/p>\n\n\n\n<p><strong>=TRIM(C4<\/strong><\/p>\n\n\n\n<p>Phir bracket close karde-<\/p>\n\n\n\n<p><strong>=TRIM(C4)<\/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\/07\/EXAMLE-Trim-4-1.jpg\" alt=\"\" width=\"1086\" height=\"537\"\/><\/figure><\/div>\n\n\n\n<p>Press<strong> ENTER.<\/strong> Ab aap dekhein ki aapke cell mein koi extra\nspaces nahi 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\/07\/EXAMLE-Trim-5-1.jpg\" alt=\"\" width=\"1083\" height=\"718\"\/><\/figure><\/div>\n\n\n\n<p>Ab issi cell ko left mein drag karde. Isse vahan tak drag kare\njahan tak aap apne raw data ke spaces ko remove karna chahte hain jaise meri\ntotal seven columns thi isliye maine iss cell ko seven columns tak drag kiya\naise-<br>\n<br>\n<\/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\/07\/EXAMLE-Trim-6-1.jpg\" alt=\"\" width=\"1085\" height=\"312\"\/><\/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\/07\/EXAMLE-Trim-7-1.jpg\" alt=\"\" width=\"1083\" height=\"505\"\/><\/figure><\/div>\n\n\n\n<p>Ab aap dekhenge ki TRIM function automatically inn cell mein bhi\napply hojayega aur extra spaces remove hojayegi.<br>\n<strong><\/strong><\/p>\n\n\n\n<p>Ab inn saari trimmed cells ko select karke niche drag karde.\nKyonki mujhe twelve rows tak ke data ko TRIM karna tha isliye maine isse twelve\ncells tak drag kardiya.<\/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\/07\/EXAMLE-Trim-8-1.jpg\" alt=\"\" width=\"1081\" height=\"687\"\/><\/figure><\/div>\n\n\n\n<p><strong>Ab aap apne old data ko new cleaned data se compare karke dekh\nsakte hain TRIM function ka awesome use. <\/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\/07\/EXAMLE-Trim-9.jpg\" alt=\"\" width=\"1080\" height=\"702\"\/><\/figure><\/div>\n\n\n\n<p>Aur ab apne purane data ko select karke DELETE kar sakte aur apne\nnew clean data ko CUT karke upar ke cells mein PASTE kar saktein hain. Ismein\naap wordart (here \u201cTeacher\u2019s Class Report\u201d) karne ke liye ye kare-<\/p>\n\n\n\n<p><strong>INSERT&gt;WORDART&gt;SELECT THE WORDART YOU WANT<\/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\/07\/Example-Marks-record-1.jpg\" alt=\"\" width=\"1077\" height=\"535\"\/><\/figure><\/div>\n\n\n\n<h3><strong>2. DATE,TIME AND AUTOSUM FUNCTIONS<\/strong><\/h3>\n\n\n\n<p>Ab hum dekhenge autosum function ka use upar wale new cleaned data\nuse karke.<br>\n<strong><br>\nAur isme humara aim hai<\/strong> \u2013<\/p>\n\n\n\n<figure class=\"wp-block-table amp-flexy\"><table><tbody><tr><td><br><p><strong>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total marks<\/strong><\/p> <\/td><td>\n<p>SUM function<\/p>\n<\/td><\/tr><tr><td> <p><strong>b.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Average marks<\/strong><\/p> <\/td><td>\n<p>AVERAGE function<\/p>\n<\/td><\/tr><tr><td> <p><strong>c.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Grand Total<\/strong><\/p><strong> <\/strong><\/td><td>\n<p>SUM function<\/p>\n<\/td><\/tr><tr><td><p><strong>d.       Enter date and time of writing report<\/strong><\/p> <\/td><td>\n<p>DATE, TODAY, TIME and DATE function<\/p>\n<\/td><\/tr><tr><td> <p><strong>e.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No. of students<\/strong><\/p> <\/td><td>\n<p>COUNT\/ COUNTA function<\/p>\n<\/td><\/tr><tr><td><strong> <\/strong><p><strong>&nbsp;f.   &nbsp;&nbsp;&nbsp; No. of subjects<\/strong><\/p> <\/td><td>\n<p>COUNTA function<\/p>\n<\/td><\/tr><tr><td> <p><strong>&nbsp;g.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Maximum Marks<\/strong><\/p><strong> <\/strong><\/td><td>\n<p>MAX function<\/p>\n<\/td><\/tr><tr><td> <p><strong>h.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Minimum Marks<\/strong><\/p> <\/td><td>\n<p>MIN function<\/p>\n<\/td><\/tr><tr><td> <p><strong>&nbsp;i. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No. of students &gt; 50 marks in English<\/strong><\/p> <\/td><td>\n<p>COUNTIF function<\/p>\n<\/td><\/tr><tr><td>&nbsp;<strong>j.<\/strong>       <strong style=\"font-size: inherit\">No. of students &gt; 50 marks<\/strong> <\/td><td>\n<p>COUNTIF function<\/p>\n<\/td><\/tr><tr><td> <p><strong>k. &nbsp;     No. of students failed<\/strong><\/p> <\/td><td>\n<p>COUNTIF function<\/p>\n<\/td><\/tr><tr><td> <p><strong>l.&nbsp;&nbsp;      Total marks of students &gt; 50 in English<\/strong><\/p> <\/td><td>\n<p>SUMIF function<\/p>\n<\/td><\/tr><tr><td><strong>m.&nbsp; &nbsp; <\/strong><strong style=\"font-size: inherit\">  Avg. marks of students &gt; 50 in English<\/strong> <\/td><td>\n<p>AVERAGEIF function<\/p>\n<\/td><\/tr><tr><td> <p><strong>n.&nbsp;&nbsp;     No. of students &gt; 50 marks in all subjects<\/strong><\/p> <\/td><td>\n<p>COUNTIFS function<\/p>\n<\/td><\/tr><tr><td> <p><strong>o.&nbsp;&nbsp;     Total marks of students &gt; 50 in all subjects<\/strong><\/p> <\/td><td>\n<p>SUMIFS function<\/p>\n<\/td><\/tr><tr><td> <p><strong>p.&nbsp;    &nbsp; Avg. marks of students &gt; 50 in all subjects<\/strong><\/p> <\/td><td>\n<p>AVERAGEIFS function<\/p>\n<\/td><\/tr><\/tbody><\/table><\/figure>\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\/07\/Example-Marks-record-with-aims.jpg\" alt=\"\" class=\"wp-image-18944\" width=\"1074\" height=\"279\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Marks-record-with-aims.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Marks-record-with-aims-300x78.jpg 300w\" sizes=\"(max-width: 1074px) 100vw, 1074px\" \/><\/figure><\/div>\n\n\n\n<p><strong>NOTE:<\/strong> Koi bhi function lagaane se pehle aap apni cell range dhyan se\ncheck karle aur accordingly lagaye kyonki meri aur aapki cell range different\nho sakti hain.<\/p>\n\n\n\n<p style=\"font-size:28px\"><strong>a.Total marks<\/strong><\/p>\n\n\n\n<p><strong>SUM function<\/strong><\/p>\n\n\n\n<p>Total marks nikalne ke liye aap jiss cell mein total marks nikalna chahte hain uss cell mein ye function lagaye \u2013<\/p>\n\n\n\n<p><strong>=SUM(<\/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\/07\/Example-Total-SUM-fn-1.jpg\" alt=\"\" width=\"1077\" height=\"511\"\/><\/figure><\/div>\n\n\n\n<p>Ab select kare cell range jiska sum aapko nikalna hai, jaise yahan\nsab subjects ke marks. Aap apni cell range type bhi kar sakte hain. Cell range\nenter karne ke baad aap apne SUM function ka bracket close karde.<\/p>\n\n\n\n<p><strong>=SUM(D10:H10)<\/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\/07\/Example-Total-SUM-fn-2.jpg\" alt=\"\" width=\"1082\" height=\"309\"\/><\/figure><\/div>\n\n\n\n<p>Press <strong>ENTER <\/strong>aur aapko apna sum miljayega. <\/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\/07\/Example-Total-SUM-fn-3.jpg\" alt=\"\" width=\"1086\" height=\"343\"\/><\/figure><\/div>\n\n\n\n<p>Aap isi cell ko niche drag karke ye function baaki students ke\nliye bhi kar sakte hain aise-<br>\n<br>\n<\/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\/07\/Example-Total-SUM-fn-4.jpg\" alt=\"\" width=\"1077\" height=\"674\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><strong>b. Average marks<\/strong><\/p>\n\n\n\n<p><strong>AVERAGE function<\/strong><\/p>\n\n\n\n<p>Average marks nikalne ke liye aap ye function lagaye-<\/p>\n\n\n\n<p><strong>=AVERAGE(<\/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\/07\/Example-Simple-Average-function1.jpg\" alt=\"\" width=\"1083\" height=\"395\"\/><\/figure><\/div>\n\n\n\n<p>Enter range D10 to H10.<\/p>\n\n\n\n<p><strong>=AVERAGE(D10:H10)<\/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\/07\/Example-Simple-Average-function2.jpg\" alt=\"\" width=\"1079\" height=\"296\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Simple-Average-function3.jpg\" alt=\"\" width=\"1082\" height=\"184\"\/><\/figure><\/div>\n\n\n\n<p>Ab ise niche drag karke baaki cells ke liye bhi yahi functions apply kare. <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\/07\/Example-Simple-Average-function4.jpg\" alt=\"\" class=\"wp-image-19038\" width=\"1081\" height=\"738\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Simple-Average-function4.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Simple-Average-function4-300x205.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Simple-Average-function4-218x150.jpg 218w\" sizes=\"(max-width: 1081px) 100vw, 1081px\" \/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><strong>c. Grand Total<\/strong><\/p>\n\n\n\n<p><strong>SUM function<\/strong><\/p>\n\n\n\n<p>Grand total ke liye bhi hum SUM function use karenge bas yahan\nhumari range change hojayegi aise &#8211;<\/p>\n\n\n\n<p><strong>=SUM(D10:D20) <\/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\/07\/Example-GRAND-Total-SUM-fn-1-1.jpg\" alt=\"\" width=\"1087\" height=\"1150\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-GRAND-Total-SUM-fn-2.jpg\" alt=\"\" width=\"1078\" height=\"1067\"\/><\/figure><\/div>\n\n\n\n<p>Ab ise right side drag karke aap ye function baaki cells mein bhi apply 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\/07\/Example-GRAND-Total-SUM-fn-3.jpg\" alt=\"\" width=\"1083\" height=\"240\"\/><\/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\/07\/Example-GRAND-Total-SUM-fn-4.jpg\" alt=\"\" width=\"1082\" height=\"319\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><strong>c.<\/strong> <strong>Enter date and time of writing report<\/strong><\/p>\n\n\n\n<p>Agar aap apne report mein date and time enter karna chahte hai toh aap <strong>Date and Time functions<\/strong> ka use kare.  <\/p>\n\n\n\n<p><strong>DATE function<\/strong><\/p>\n\n\n\n<p>Pehle cell mein ye likhein-<\/p>\n\n\n\n<p><strong>=DATE(<\/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\/07\/Example-DATE-1.jpg\" alt=\"\" width=\"1088\" height=\"306\"\/><\/figure><\/div>\n\n\n\n<p>Phir ismein jo date aapko date format mein enter karni hai vo aap DATE function mein iss order enter kare<\/p>\n\n\n\n<p>Year, month, day<\/p>\n\n\n\n<p><strong>=DATE(2019, 06, 20)<\/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\/07\/Example-DATE-2.jpg\" alt=\"\" width=\"1087\" height=\"311\"\/><\/figure><\/div>\n\n\n\n<p>Aur phir bracket close karke <strong>ENTER<\/strong> press kare aur aapko apni date 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\/07\/Example-DATE-3.jpg\" alt=\"\" width=\"1080\" height=\"304\"\/><\/figure><\/div>\n\n\n\n<p><strong>TIME function<\/strong><\/p>\n\n\n\n<p>Agar aapko time <strong>hrs, mins, secs <\/strong>ki form mein pata hai toh\naap usse cell me 12 hr cycle format mein enter kar sakte hain aise-<\/p>\n\n\n\n<p><strong>=TIME(<\/strong><\/p>\n\n\n\n<p>Ismein pehle hours phir minutes aur phir seconds enter kare aur\nbracket close karke <strong>Enter<\/strong> press karde.<\/p>\n\n\n\n<p><strong>=TIME(16,36,5)<br> <\/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\/07\/Example-Time-function1.jpg\" alt=\"\" width=\"1077\" height=\"194\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-Time-function2.jpg\" alt=\"\" width=\"1082\" height=\"258\"\/><\/figure><\/div>\n\n\n\n<p><strong>TODAY function<\/strong><\/p>\n\n\n\n<p>Today function hum current date enter karne ke liye karte hain aise-<\/p>\n\n\n\n<p><strong>=TODAY()<\/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\/07\/Example-Today-function.jpg\" alt=\"\" width=\"1083\" height=\"331\"\/><\/figure><\/div>\n\n\n\n<p>And press <strong>ENTER<\/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\/07\/Example-Today-function-2.jpg\" alt=\"\" width=\"1080\" height=\"357\"\/><\/figure><\/div>\n\n\n\n<p><strong>NOW function<\/strong><\/p>\n\n\n\n<p>Now function ka use hum current date aur time enter karne ke liye karte hain.<\/p>\n\n\n\n<p>Ise aise lagate hain-<\/p>\n\n\n\n<p><strong>=NOW()<\/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\/07\/Example-NOW-function-1.jpg\" alt=\"\" width=\"1077\" height=\"357\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-NOW-function-2.jpg\" alt=\"\" width=\"1081\" height=\"409\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>d.<\/strong> <strong>No. of students<\/strong><\/p>\n\n\n\n<p><strong>COUNTA function<\/strong><\/p>\n\n\n\n<p>Agar aap cells jinme sirf <strong>text<\/strong> hai unhe count karna chahte\nhain toh hai aap iss function ko use kar sakte hain.<\/p>\n\n\n\n<p>Isse aise use karte hai-<\/p>\n\n\n\n<p><strong>=COUNTA(<\/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\/07\/Example-students-COUNTA-function1.1-1.jpg\" alt=\"\" width=\"1077\" height=\"214\"\/><\/figure><\/div>\n\n\n\n<p>Select students names range (excluding Name).<\/p>\n\n\n\n<p><strong>=COUNTA(C10:C20)<\/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\/07\/Example-students-COUNTA-function2.jpg\" alt=\"\" width=\"1081\" height=\"324\"\/><\/figure><\/div>\n\n\n\n<p>Press <strong>ENTER <\/strong>aur phir aapko ye milega &#8211;<\/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\/07\/Example-students-COUNTA-function3.jpg\" alt=\"\" width=\"1078\" height=\"298\"\/><\/figure><\/div>\n\n\n\n<p><strong>COUNT function<\/strong><\/p>\n\n\n\n<p>No. of students ke liye aap <strong>COUNT <\/strong>function bhi use kar\nsakte hain aise-<\/p>\n\n\n\n<p><strong>=COUNT(<\/strong><\/p>\n\n\n\n<p>Ab select kare range jismein sirf numbers ho maine yahan sabke\nEnglish ke marks leliye hain kyonki jitne no. of marks utne students.<\/p>\n\n\n\n<p><strong>=COUNT(D10:D20)<\/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\/07\/Example-students-COUNT-function.jpg\" alt=\"\" width=\"1083\" height=\"264\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-students-COUNT-function2-1.jpg\" alt=\"\" width=\"1080\" height=\"374\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><strong>e. No. of subjects<\/strong><\/p>\n\n\n\n<p><strong>COUNTA function<\/strong><\/p>\n\n\n\n<p>Agar aap cells jinme sirf <strong>text<\/strong> hai unhe count karna chahte\nhain toh hai aap iss function ko use kar sakte hain.<\/p>\n\n\n\n<p>Isse aise use karte hai-<\/p>\n\n\n\n<p><strong>=COUNTA(<\/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\/07\/Example-subjects-COUNTA-function1-1.jpg\" alt=\"\" width=\"1080\" height=\"267\"\/><\/figure><\/div>\n\n\n\n<p>Select students names range.<\/p>\n\n\n\n<p><strong>=COUNTA(D9:J9)<\/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\/07\/Example-subjects-COUNTA-function1.1.jpg\" alt=\"\" width=\"1077\" height=\"167\"\/><\/figure><\/div>\n\n\n\n<p><br> Aur phir aapko ye milega &#8211;<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\/07\/Example-subjects-COUNTA-function2.jpg\" alt=\"\" width=\"1077\" height=\"285\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><strong>f. Maximum Marks<\/strong><\/p>\n\n\n\n<p><strong>MAX function<br> <\/strong><br> MAX function ka use hum yahan subject ke maximum marks nikalne ke liye use karenge.<br> Pehle hum nikalte hain English mein max. marks.<br> <br> Apne desired cell par ye function lagayein-<\/p>\n\n\n\n<p><strong>=MAX(<br> <\/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\/07\/Example-MAX-func-1-1.jpg\" alt=\"\" width=\"1081\" height=\"677\"\/><\/figure><\/div>\n\n\n\n<p>Select kare vo range jismein sabke English ke marks hain aise-<\/p>\n\n\n\n<p><strong>=MAX(D10:D20)<\/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\/07\/Example-MAX-func-2-1.jpg\" alt=\"\" class=\"wp-image-22179\" width=\"1078\" height=\"1188\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-MAX-func-2-1.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-MAX-func-2-1-272x300.jpg 272w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-MAX-func-2-1-381x420.jpg 381w\" sizes=\"(max-width: 1078px) 100vw, 1078px\" \/><\/figure><\/div>\n\n\n\n<p><br>Press <strong>ENTER<\/strong>.<br><\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img width=\"600\" height=\"496\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-MAX-func-3.jpg\" alt=\"\" data-id=\"19434\" data-link=\"https:\/\/www.joshtalks.com\/joshkosh\/?attachment_id=19434\" class=\"wp-image-19434\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-MAX-func-3.jpg 600w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-MAX-func-3-300x248.jpg 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-MAX-func-3-508x420.jpg 508w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p><br>Ab isse right side drag karke baaki subjects ke liye bhi apply kare.<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\/07\/Example-MAX-func-4.jpg\" alt=\"\" width=\"1035\" height=\"679\"\/><\/figure><\/div>\n\n\n\n<p>Ye aisa lagega-<\/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\/07\/Example-MAX-func-5.jpg\" alt=\"\" width=\"1051\" height=\"225\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>g. Minimum Marks<\/strong><\/p>\n\n\n\n<p>MIN function ka use hum yahan ek subject ke minimum marks nikalne ke liye use karenge.<br>Pehle hum nikalte hain English mein min. marks.<br> <br>Apne desired cell par ye function&nbsp; lagayein-<\/p>\n\n\n\n<p><strong>=MIN(<\/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\/07\/Example-MIN-func-1.jpg\" alt=\"\" width=\"1058\" height=\"510\"\/><\/figure><\/div>\n\n\n\n<p>Select kare vo range jismein sabke English ke marks hain aise-<\/p>\n\n\n\n<p><strong>=MIN(D10:D20)<\/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\/07\/Example-MIN-func-2.jpg\" alt=\"\" width=\"600\" height=\"634\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-MIN-func-3-2.jpg\" alt=\"\" width=\"1007\" height=\"910\"\/><\/figure><\/div>\n\n\n\n<p><strong><br> <\/strong>Ab isse right side drag karke baaki subjects ke liye bhi apply kare-<\/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\/07\/Example-MIN-func-4-.jpg\" alt=\"\" width=\"1022\" height=\"296\"\/><\/figure><\/div>\n\n\n\n<p>Ye aisa lagega-<\/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\/07\/Example-MIN-func-5-1-2.jpg\" alt=\"\" width=\"1064\" height=\"296\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>h. No. of students &gt; 50 marks in English<\/strong><\/p>\n\n\n\n<p><strong> COUNTIF function<\/strong><\/p>\n\n\n\n<p>COUNTIF function hum cells ko count karne ke liye use karte hai but ek condition ya criteria par.<\/p>\n\n\n\n<p>Isse use\nkarne ke liye pehle hum pehle likhte hain-<\/p>\n\n\n\n<p><strong>=COUNTIF(<\/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\/07\/Example-English-COUNTIF-func-1.jpg\" alt=\"\" width=\"1071\" height=\"298\"\/><\/figure><\/div>\n\n\n\n<p>Ab pehle\nismein hum <strong>range<\/strong> insert karenge. Yahan humari range English ke marks\nhain.<\/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\/07\/Example-English-COUNTIF-func-2.jpg\" alt=\"\" width=\"1043\" height=\"292\"\/><\/figure><\/div>\n\n\n\n<p><strong>NOTE:<\/strong> Apni range dhyan se apne aim ke according add kare.<\/p>\n\n\n\n<p>Ab ismein aap\n<strong>comma<\/strong> insert kare.<br>\nIske baad aap apna <strong>criteria<\/strong> likhe in inverted commas and bracket close\nkare.<\/p>\n\n\n\n<p><strong>=COUNTIF(D10:D20,\u201d&gt;50\u201d)<\/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\/07\/Example-English-COUNTIF-func-3.jpg\" alt=\"\" width=\"1075\" height=\"367\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-English-COUNTIF-func-4.jpg\" alt=\"\" width=\"1038\" height=\"235\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>j. No. of students &gt; 50 marks<\/strong><\/p>\n\n\n\n<p><strong>COUNTIF function<\/strong><\/p>\n\n\n\n<p>Isse use karne ke liye pehle hum COUNTIF function jaise humne upar lagaya hai lagayenge 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\/07\/Example-50-COUNTIF-fumc1-2.jpg\" alt=\"\" width=\"1052\" height=\"401\"\/><\/figure><\/div>\n\n\n\n<p>Ab likhein range aur criteria.<\/p>\n\n\n\n<p><strong>=COUNTIF(D10:D20,&#8221;&gt;50&#8243;)<\/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\/07\/Example-50-COUNTIF-fumc-2-1.jpg\" alt=\"\" width=\"1055\" height=\"977\"\/><\/figure><\/div>\n\n\n\n<p><strong> <\/strong>Press <strong>ENTER<\/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\/07\/Example-50-COUNTIF-fumc-3-2.jpg\" alt=\"\" width=\"1064\" height=\"535\"\/><\/figure><\/div>\n\n\n\n<p>Ab iss cell ko right side drag kare aur baaki subjects ke liye bhi aapka function apply hojayega.<\/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\/07\/Example-50-COUNTIF-fumc-4-1.jpg\" alt=\"\" width=\"1035\" height=\"374\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>k. No. of students failed<\/strong><\/p>\n\n\n\n<p><strong>COUNTIF function<\/strong><\/p>\n\n\n\n<p>No. of failed students nikalne ke liye humari condition ya criteria <strong>&lt;34<\/strong> hai. Isse nikalne ke liye hum COUNTIF function ka use kar sakte hain aise- <\/p>\n\n\n\n<p><strong>=COUNTIF(D10:D20,<\/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\/07\/Example-failed-count-func-1-1.jpg\" alt=\"\" width=\"1013\" height=\"882\"\/><\/figure><\/div>\n\n\n\n<p>Iske baad insert criteria-<\/p>\n\n\n\n<p><strong>=COUNTIF(D10:D20,\u201d&lt;34\u201d)<\/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\/07\/Example-failed-count-func-2.jpg\" alt=\"\" width=\"1059\" height=\"475\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-failed-count-func-3.jpg\" alt=\"\" width=\"1048\" height=\"526\"\/><\/figure><\/div>\n\n\n\n<p>Baaki subjects mein bhi yahi apply karne ke liye apne cell ko select kare jismein aapne function lagaya hai aur usse right side drag karde 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\/07\/Example-failed-count-func-4.jpg\" alt=\"\" width=\"1055\" height=\"269\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>l.<\/strong> <strong>Total marks of students &gt; 50 in English<\/strong><\/p>\n\n\n\n<p><strong>SUMIF function<\/strong><\/p>\n\n\n\n<p>SUMIF function hum cells ko sum karne ke liye use karte hai but ek\ncondition ya criteria par.<\/p>\n\n\n\n<p>Isse use karne ke liye pehle hum likhte hain-<\/p>\n\n\n\n<p><strong>=SUMIF(<\/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\/07\/Example-eng-sumif.jpg\" alt=\"\" width=\"1043\" height=\"240\"\/><\/figure><\/div>\n\n\n\n<p>Ab pehle ismein hum <strong>range<\/strong> insert karenge. Yahan humari\nrange English ke marks 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\/07\/Example-eng-sumif2.jpg\" alt=\"\" width=\"1043\" height=\"285\"\/><\/figure><\/div>\n\n\n\n<p>Ab ismein aap <strong>comma<\/strong> insert kare.<br>\nIske baad aap apna <strong>criteria<\/strong> likhe inverted commas mein aur bracket close\nkarde.<\/p>\n\n\n\n<p><strong>=SUMIF(D10:D20,\u201d&gt;50\u201d)<\/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\/07\/Example-eng-sumif3.jpg\" alt=\"\" width=\"1069\" height=\"276\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-eng-sumif4.jpg\" alt=\"\" width=\"1054\" height=\"379\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>m. Avg. marks of students &gt; 50 in English<\/strong><\/p>\n\n\n\n<p><strong>AVERAGEIF function<br> <br><\/strong>AVERAGEIF function hum cells ka average nikalne ke liye use karte hai but ek condition ya criteria par.<\/p>\n\n\n\n<p>Isse use karne ke liye pehle hum likhte hain-<\/p>\n\n\n\n<p><strong>=AVERAGEIF(<\/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\/07\/Example-eng-Averageif1.jpg\" alt=\"\" width=\"1058\" height=\"258\"\/><\/figure><\/div>\n\n\n\n<p>Ab pehle ismein hum <strong>range<\/strong> insert karenge. Yahan humari range English ke marks hain.<\/p>\n\n\n\n<p><strong>=AVERAGEIF(D10:D20<\/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\/07\/Example-eng-Averageif2.jpg\" alt=\"\" width=\"1074\" height=\"263\"\/><\/figure><\/div>\n\n\n\n<p>Ab ismein aap <strong>comma<\/strong> lagayein. Iske baad aap apna <strong>criteria<\/strong>\nlikhe inverted commas mein aur bracket close karde.<\/p>\n\n\n\n<p><strong>=AVERAGEIF(D10:D20,\u201d&gt;50\u201d)<\/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\/07\/Example-eng-Averageif3.jpg\" alt=\"\" width=\"1047\" height=\"251\"\/><\/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\"><img src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/Example-eng-Averageif4.jpg\" alt=\"\" width=\"1049\" height=\"257\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>n. No. of students &gt; 50 marks in all subjects<\/strong><\/p>\n\n\n\n<p><strong>COUNTIFS function<\/strong><\/p>\n\n\n\n<p>COUNTIFS function hum cells ko count karne ke liye karte jab\nhumein <strong>ek se jyada condition\/ criteria <\/strong>add karni hoti hain.<\/p>\n\n\n\n<p>Isse use karne ke liye pehle hum likhte hain-<\/p>\n\n\n\n<p><strong>=COUNTIFS(<\/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\/07\/Example-all-countifs1.jpg\" alt=\"\" width=\"1057\" height=\"184\"\/><\/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\/07\/Example-all-countifs2.jpg\" alt=\"\" width=\"1042\" height=\"724\"\/><\/figure><\/div>\n\n\n\n<p>Iske baad aap first criteria ke liye range select karke ek comma lagayein aur phir inverted commas mein apna criteria likhdein aise-<\/p>\n\n\n\n<p><strong>=COUNTIFS(D10:D20, &#8220;&gt;50&#8221;,<\/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\/07\/Example-all-countifs3.jpg\" alt=\"\" width=\"1053\" height=\"242\"\/><\/figure><\/div>\n\n\n\n<p>Ab vaapis <strong>comma<\/strong> lagayein aur phir apni second criteria ki range select kare. Phir se <strong>comma<\/strong> lagayein aur apna second criteria likhdein aise-<\/p>\n\n\n\n<p><strong>=COUNTIFS(D10:D20, &#8220;&gt;50&#8243;,E10:E20,&#8221;&gt;50&#8243;,<\/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\/07\/Example-all-countifs4.jpg\" alt=\"\" width=\"1041\" height=\"234\"\/><\/figure><\/div>\n\n\n\n<p>Aise hi baaki criterias add karte rahein-<\/p>\n\n\n\n<p><strong>=COUNTIFS(D10:D20, &#8220;&gt;50&#8243;,E10:E20,&#8221;&gt;50&#8243;,F10:F20,&#8221;&gt;50&#8243;,<\/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\/07\/Example-all-countifs5.jpg\" alt=\"\" width=\"1043\" height=\"219\"\/><\/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\/07\/Example-all-countifs6.jpg\" alt=\"\" width=\"1060\" height=\"219\"\/><\/figure><\/div>\n\n\n\n<p>Aapka complete function kuch aise hoga &#8211;<\/p>\n\n\n\n<p><strong>=COUNTIFS(D10:D20, &#8220;&gt;50&#8243;,E10:E20,&#8221;&gt;50&#8243;,F10:F20,&#8221;&gt;50&#8243;,G10:G20,&#8221;&gt;50&#8243;,H10:H20,&#8221;&gt;50&#8243;)<\/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\/07\/Example-all-countifs7.jpg\" alt=\"\" width=\"1054\" height=\"65\"\/><\/figure><\/div>\n\n\n\n<p>Press <strong>ENTER <\/strong>aur aapka apna count function with conditions\/criterias jo apne insert kiye hain miljayega. <\/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\/07\/Example-all-countifs8.jpg\" alt=\"\" width=\"1063\" height=\"246\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><br><strong>o. Total marks of students &gt; 50 in all subjects<\/strong><\/p>\n\n\n\n<p><strong>SUMIFS function<\/strong><\/p>\n\n\n\n<p>SUMIFS function hum cells ka sum nikalne ke liye karte jab humein <strong>ek\nse jyada condition or criteria <\/strong>add karni hoti hain.<\/p>\n\n\n\n<p>Isse use karne ke liye pehle hum likhte hain-<\/p>\n\n\n\n<p><strong>=SUMIFS(<\/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\/07\/Example-all-sumifs1.jpg\" alt=\"\" width=\"1057\" height=\"251\"\/><\/figure><\/div>\n\n\n\n<p>SUMIFS function mein humein sabse pehle apni vo range select\nkarni&nbsp; hoti hai jismein humara marks ka\nTOTAL hai.<\/p>\n\n\n\n<p><strong>=SUMIFS(J10:I20,<\/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\/07\/Example-all-sumifs2.jpg\" alt=\"\" width=\"1020\" height=\"345\"\/><\/figure><\/div>\n\n\n\n<p>Iske baad aap comma lagyein aur phir apne first criteria ke liye range select karke phir se ek comma lagayein aur phir inverted commas mein apna criteria likhdein aise-<\/p>\n\n\n\n<p><strong>=SUMIFS(I10:I20,D10:D20,&#8221;&gt;50&#8243;<\/strong>,<\/p>\n\n\n\n<p>Aise hi aap iske baad comma lagakar second criteria ki range select kare aur phir ek comma lagakar uska criteria inverted commas mein likhdein. Aise hi apni saari criteria range and criteria add karde 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\/07\/Example-all-sumifs3.jpg\" alt=\"\" width=\"1053\" height=\"221\"\/><\/figure><\/div>\n\n\n\n<p><strong>=SUMIFS(I10:I20,D10:D20,&#8221;&gt;50&#8243;,E10:E20,&#8221;&gt;50&#8243;,F10:F20,&#8221;&gt;50&#8243;<\/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\/07\/Example-all-sumifs4.jpg\" alt=\"\" width=\"1070\" height=\"237\"\/><\/figure><\/div>\n\n\n\n<p>Aapka function kuch finally kuch aisa hoga-<\/p>\n\n\n\n<p><strong>=SUMIFS(I10:I20,D10:D20,&#8221;&gt;50&#8243;,E10:E20,&#8221;&gt;50&#8243;,F10:F20,&#8221;&gt;50&#8243;,G10:G20,&#8221;&gt;50&#8243;,H10:H20,&#8221;&gt;50&#8243;)<\/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\/07\/Example-all-sumifs5.2.jpg\" alt=\"\" width=\"1059\" height=\"91\"\/><\/figure><\/div>\n\n\n\n<p>Press<strong> ENTER <\/strong>aur aapko apna sum with inserted criterias\nmiljayega.<\/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\/07\/Example-all-sumifs6.jpg\" alt=\"\" width=\"1045\" height=\"214\"\/><\/figure><\/div>\n\n\n\n<p style=\"font-size:28px\"><strong>p. Avg. marks of students &gt; 50 in all subjects<\/strong><\/p>\n\n\n\n<p><strong>AVERAGEIFS function<br> <br><\/strong>AVERAGEIFS function hum cells ka average nikalne ke liye karte jab humein <strong>ek se jyada condition or criteria <\/strong>add karni hoti hain.<\/p>\n\n\n\n<p>Ise use karne ke liye pehle hum likhte hain-<\/p>\n\n\n\n<p><strong>=AVERAGEIFS(<\/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\/07\/Example-all-Averageifs1.jpg\" alt=\"\" width=\"1049\" height=\"222\"\/><\/figure><\/div>\n\n\n\n<p>AVERAGEIFS function mein humein sabse pehle apni vo range select karni&nbsp; hoti hai jismein humare marks ka AVERAGE hai aise-<\/p>\n\n\n\n<p><strong>=AVERAGEIFS(J10:J20,<\/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\/07\/Example-all-Averageifs-2.jpg\" alt=\"\" width=\"1058\" height=\"341\"\/><\/figure><\/div>\n\n\n\n<p>Iske baad aap comma lagyein aur phir apne first criteria ke liye range select karke phir se ek comma lagayein aur phir inverted commas mein apna criteria likhdein aise-<\/p>\n\n\n\n<p><strong>=AVERAGEIFS(J10:J20,D10:D20,&#8221;&gt;50&#8243;,<\/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\/07\/Example-all-Averageifs-3.jpg\" alt=\"\" width=\"1048\" height=\"246\"\/><\/figure><\/div>\n\n\n\n<p>Aise hi aap iske baad comma lagakar second criteria ki range select kare aur phir ek comma lagakar uska criteria inverted commas mein likhdein.. Aise hi apni saari criteria range and criteria add karde aise-<\/p>\n\n\n\n<p><strong>=AVERAGEIFS(J10:J20,D10:D20,&#8221;&gt;50&#8243;,E10:E20,&#8221;&gt;50&#8243;,F10:F20,&#8221;&gt;50&#8243;,G10:G20,&#8221;&gt;50&#8243;,H10:H20,&#8221;&gt;50&#8243;<\/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\/07\/Example-all-Averageifs-4-1.jpg\" alt=\"\" width=\"1077\" height=\"226\"\/><\/figure><\/div>\n\n\n\n<p>Aapka function kuch finally kuch aisa hoga-<\/p>\n\n\n\n<p><strong>=AVERAGEIFS(J10:J20,D10:D20,&#8221;&gt;50&#8243;,E10:E20,&#8221;&gt;50&#8243;,F10:F20,&#8221;&gt;50&#8243;,G10:G20,&#8221;&gt;50&#8243;,H10:H20,&#8221;&gt;50&#8243;)<\/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\/07\/Example-all-Averageifs-5.jpg\" alt=\"\" width=\"1036\" height=\"69\"\/><\/figure><\/div>\n\n\n\n<p>Press<strong> ENTER <\/strong>aur aapko apna sum with inserted criterias miljayega.<\/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\/07\/Example-all-Averageifs-6-1.jpg\" alt=\"\" width=\"1065\" height=\"316\"\/><\/figure><\/div>\n\n\n\n<p>Isse humare Excel ke beginner level formulas aur functions khatm hote hain. Intermediate aur advanced level formulas ke liye aap jaye <strong>ADVANCE COURSE PART 2<\/strong> par jaye- <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 ke advance formulas<\/a> <\/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\/ADVANCE-PART-1-RAW.xlsx\">  CLICK HERE TO DOWNLOAD ADVANCE PART 1 RAW DATA SHEET  <\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/ADVANCE-PART-1-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\/ADVANCE-PART-1-FINAL.xlsx\">  CLICK HERE TO DOWNLOAD ADVANCE PART 1 FINAL DATA SHEET   <\/a><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2019\/07\/ADVANCE-PART-1-FINAL.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<p><em><strong>I hope yeh beginner level functions aapko samajh aaye honge. Aur agar aapki koi query ya feedback ho toh aap niche comments sections mein zarur reply kare, hum aapki poori tarah se help karenge.<\/strong><\/em><\/p>\n\n\n\n<p> <strong><a rel=\"noreferrer noopener\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.joshtalks.joshskills&amp;hl=en&amp;_branch_match_id=688826483773283510&amp;utm_medium=marketing\" target=\"_blank\">Josh talks ke courses harazo logo ko help kar rahe hai career mai aage badne ke liye. Iss link par click karke App download kare aur janiye courses ke baare mein<\/a><\/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 third part tha. Isko complete karne ke baad aap baaki 3 bhi 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=\" (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-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 rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\" href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\">MS Excel in Hindi full tutorial <\/a><strong><a rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\" href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\">Advance course part 2<\/a><\/strong><a rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\" href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-develop-karein\/ms-excel-formulas-in-hindi-advance-excel-tutorial-part-2\/\" target=\"_blank\"> &#8211; MS Excel ke advance formulas<\/a>  <\/p>\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>Excel formulas with examples in Hindi sikhe Iss advance MS Excel tutorial in Hindi mein hum aapko Excel formulas ke baare mein examples ke saath batayenge jisse aap MS Excel mein expert ban jaoge. Yeh Advance MS Excel tutorial baaki excel courses se behtar hai kyonki: Yeh hindi excel tutorial 100% FREE hai Iss course [&hellip;]<\/p>\n","protected":false},"author":33,"featured_media":23248,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":""},"categories":[11004],"tags":[54],"yst_prominent_words":[2899,2707,2704,1214,1211,2884,135,260,259,1213,1212,131,1218,2891,1217,2892,2893,2705,1950,1219],"_links":{"self":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/18394"}],"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=18394"}],"version-history":[{"count":96,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/18394\/revisions"}],"predecessor-version":[{"id":40330,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/posts\/18394\/revisions\/40330"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/media\/23248"}],"wp:attachment":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/media?parent=18394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/categories?post=18394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/tags?post=18394"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/wp-json\/wp\/v2\/yst_prominent_words?post=18394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}