{"id":402,"date":"2025-11-11T10:00:00","date_gmt":"2025-11-11T04:30:00","guid":{"rendered":"https:\/\/hackingworlds.in\/?p=402"},"modified":"2025-11-15T08:32:37","modified_gmt":"2025-11-15T03:02:37","slug":"10-excel-formulas-every-beginner-must-know-in-2025-2","status":"publish","type":"post","link":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/","title":{"rendered":"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula"},"content":{"rendered":"\n<p><strong>Introduction \u2013 Excel \u0938\u0940\u0916\u0928\u093e \u0915\u094d\u092f\u094b\u0902 \u091c\u093c\u0930\u0942\u0930\u0940 \u0939\u0948?<\/strong><\/p>\n\n\n\n<p>\u0905\u0917\u0930 \u0906\u092a Student, Job Seeker, Accountant \u092f\u093e Business Owner \u0939\u0948\u0902, \u0924\u094b Excel \u0906\u092a\u0915\u0947 \u0930\u094b\u091c\u093c\u092e\u0930\u094d\u0930\u093e \u0915\u0947 \u0915\u093e\u092e \u0915\u094b \u0906\u0938\u093e\u0928 \u092c\u0928\u093e\u0928\u0947 \u0935\u093e\u0932\u093e \u0938\u092c\u0938\u0947 \u092c\u0922\u093c\u093f\u092f\u093e \u091f\u0942\u0932 \u0939\u0948\u0964<br>\u0932\u0947\u0915\u093f\u0928 Excel \u092e\u0947\u0902 \u0924\u0947\u091c\u093c \u092c\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b <strong>Formulas<\/strong> \u0915\u093e basic knowledge \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f\u0964<\/p>\n\n\n\n<p>\u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u0939\u092e \u091c\u093e\u0928\u0947\u0902\u0917\u0947 \u2014<br>\ud83d\udc49 2025 \u092e\u0947\u0902 \u0939\u0930 Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formulas<br>\ud83d\udc49 \u0909\u0928\u0915\u0947 \u0906\u0938\u093e\u0928 examples<br>\ud83d\udc49 \u0914\u0930 real-life uses \u091c\u094b \u0906\u092a\u0915\u0947 \u0915\u093e\u092e \u0915\u094b 10x \u0906\u0938\u093e\u0928 \u092c\u0928\u093e \u0926\u0947\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. SUM Formula \u2013 \u091c\u094b\u0921\u093c\u0928\u093e \u0906\u0938\u093e\u0928 \u092c\u0928\u093e \u0926\u0947<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong><\/p>\n\n\n\n<p>=SUM(A1:A10)<\/p>\n\n\n\n<p><strong>Use:<\/strong> \u0915\u093f\u0938\u0940 \u092d\u0940 column \u092f\u093e range \u0915\u0947 \u0938\u092d\u0940 numbers \u0915\u094b \u091c\u094b\u0921\u093c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964<\/p>\n\n\n\n<p><strong>Example:<\/strong> \u0905\u0917\u0930 A1 \u0938\u0947 A10 \u0924\u0915 \u0938\u0947\u0932 \u092e\u0947\u0902 \u0906\u092a\u0915\u0947 sales data \u0939\u0948\u0902, \u0924\u094b \u092f\u0947 formula total sales \u0926\u093f\u0916\u093e\u090f\u0917\u093e\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. AVERAGE Formula \u2013 \u0914\u0938\u0924 \u0928\u093f\u0915\u093e\u0932\u0928\u093e Seconds \u092e\u0947\u0902<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong>   =AVERAGE(B1:B5)<\/p>\n\n\n\n<p><strong>Use:<\/strong> \u0915\u093f\u0938\u0940 \u092d\u0940 range \u0915\u093e average \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964<\/p>\n\n\n\n<p><strong>Example:<\/strong> Students \u0915\u0947 marks \u092f\u093e monthly expense \u0915\u093e average \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u092e\u0947\u0902 helpful\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. COUNT Formula \u2013 \u0915\u093f\u0924\u0928\u0947 \u0928\u0902\u092c\u0930 \u0939\u0948\u0902 \u092f\u0947 \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong>  =COUNT(A1:A10)<\/p>\n\n\n\n<p><strong>Use:<\/strong> \u0938\u093f\u0930\u094d\u092b number \u0935\u093e\u0932\u0947 cells \u0915\u0940 \u0917\u093f\u0928\u0924\u0940 \u0915\u0930\u0924\u093e \u0939\u0948\u0964<br><strong>Example:<\/strong> \u0905\u0917\u0930 \u0915\u0941\u091b cells \u092e\u0947\u0902 text \u0914\u0930 \u0915\u0941\u091b \u092e\u0947\u0902 number \u0939\u0948\u0902, \u0924\u094b \u092f\u0947 \u0938\u093f\u0930\u094d\u092b number \u0935\u093e\u0932\u0947 count \u0915\u0930\u0947\u0917\u093e\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. COUNTA Formula \u2013 \u0916\u093e\u0932\u0940 \u0928\u0939\u0940\u0902, \u0938\u092c \u0917\u093f\u0928\u094b<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong>   =COUNTA(A1:A10)<\/p>\n\n\n\n<p><strong>Use:<\/strong> Empty cells \u0915\u094b \u091b\u094b\u0921\u093c\u0915\u0930 total filled cells \u0917\u093f\u0928\u0924\u093e \u0939\u0948\u0964<br><strong>Example:<\/strong> Attendance sheet \u092e\u0947\u0902 \u0915\u093f\u0924\u0928\u0947 students present \u0939\u0948\u0902, \u092f\u0947 \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f perfect\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. IF Formula \u2013 Condition Based Result<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong>  =IF(A1>50,&#8221;Pass&#8221;,&#8221;Fail&#8221;)<\/p>\n\n\n\n<p><strong>Use:<\/strong> Condition check \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964<br><strong>Example:<\/strong> Marks 50 \u0938\u0947 \u091c\u093c\u094d\u092f\u093e\u0926\u093e \u0939\u0948\u0902 \u0924\u094b \u201cPass\u201d, \u0935\u0930\u0928\u093e \u201cFail\u201d \u0926\u093f\u0916\u093e\u090f\u0917\u093e\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>6. VLOOKUP Formula \u2013 Data Search \u0915\u0930\u0928\u0947 \u0915\u093e King<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong> =VLOOKUP(A2, B2:D10, 3, FALSE)<\/p>\n\n\n\n<p><strong>Use:<\/strong> \u0915\u093f\u0938\u0940 table \u092e\u0947\u0902 value \u0922\u0942\u0902\u0922\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964<br><strong>Example:<\/strong> Roll number \u0938\u0947 student \u0915\u093e \u0928\u093e\u092e \u092f\u093e salary \u0928\u093f\u0915\u093e\u0932\u0928\u093e\u0964<\/p>\n\n\n\n<p><strong>Tip:<\/strong> 2025 \u092e\u0947\u0902 \u0928\u092f\u093e formula <strong>XLOOKUP<\/strong> \u091c\u093c\u094d\u092f\u093e\u0926\u093e advanced \u0939\u0948 (\u0909\u0938 \u092a\u0930 \u0905\u0917\u0932\u093e \u092c\u094d\u0932\u0949\u0917 \u092c\u0928\u0947\u0917\u093e \ud83d\ude09)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>7. MAX \u0914\u0930 MIN \u2013 \u0938\u092c\u0938\u0947 \u092c\u0921\u093c\u093e \u092f\u093e \u091b\u094b\u091f\u093e \u0928\u0902\u092c\u0930 \u0922\u0942\u0902\u0922\u094b<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong> =MAX(A1:A10)<br>=MIN(A1:A10)<\/p>\n\n\n\n<p><strong>Use:<\/strong> Range \u092e\u0947\u0902 highest \u092f\u093e lowest value \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964<br><strong>Example:<\/strong> Highest salary \u092f\u093e lowest marks \u0922\u0942\u0902\u0922\u0928\u0947 \u092e\u0947\u0902 helpful\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>8. CONCATENATE \/ TEXTJOIN \u2013 \u0926\u094b \u092f\u093e \u091c\u093c\u094d\u092f\u093e\u0926\u093e Text \u091c\u094b\u0921\u093c\u0928\u093e<\/strong><\/h2>\n\n\n\n<p><strong>Formula (Old):<\/strong> =CONCATENATE(A1,&#8221; &#8220;,B1)<\/p>\n\n\n\n<p><strong>Formula (New): <\/strong> =TEXTJOIN(&#8221; &#8220;,TRUE,A1,B1)<\/p>\n\n\n\n<p><strong>Use:<\/strong> Name + Surname \u0915\u094b \u090f\u0915 cell \u092e\u0947\u0902 combine \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>9. ROUND Formula \u2013 Perfect Number Formatting<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong> =ROUND(A1,2)<\/p>\n\n\n\n<p><strong>Use:<\/strong> Decimal numbers \u0915\u094b fix digits \u0924\u0915 round \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964<br><strong>Example:<\/strong> 123.456 \u2192 123.46<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>10. TODAY &amp; NOW Formula \u2013 Date \u0914\u0930 Time Auto Show \u0915\u0930\u0947\u0902<\/strong><\/h2>\n\n\n\n<p><strong>Formula:<\/strong>  =TODAY()<br>=NOW()<\/p>\n\n\n\n<p><strong>Use:<\/strong> System \u0915\u0940 current date \u0914\u0930 time automatically \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964<br><strong>Example:<\/strong> Report \u092e\u0947\u0902 auto update \u0939\u094b\u0924\u0940 \u0924\u093e\u0930\u0940\u0916\u093c \u0921\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f perfect\u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u0907\u0928 formulas \u0915\u094b \u092f\u093e\u0926 \u0915\u0948\u0938\u0947 \u0930\u0916\u0947\u0902?<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0939\u0930 \u0926\u093f\u0928 2 formulas practice \u0915\u0930\u0947\u0902<\/li>\n\n\n\n<li>Real data (\u091c\u0948\u0938\u0947 attendance, expenses, marks) \u0938\u0947 example \u092c\u0928\u093e\u090f\u0902<\/li>\n\n\n\n<li>Keyboard shortcuts \u0915\u0947 \u0938\u093e\u0925 use \u0915\u0930\u0947\u0902<\/li>\n\n\n\n<li>Practice file \u092c\u0928\u093e\u0915\u0930 save \u0915\u0930\u0947\u0902 \u201cFormula Practice.xlsx\u201d \u0928\u093e\u092e \u0938\u0947<\/li>\n<\/ul>\n\n\n\n<p>\u0907\u0928 10 formulas \u0915\u094b \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u0940\u0916\u0915\u0930 \u0906\u092a 70% Excel tasks easily \u0915\u0930 \u092a\u093e\u090f\u0902\u0917\u0947 \u2014<br>\u091a\u093e\u0939\u0947 \u0935\u094b data entry \u0939\u094b, reporting, accounting \u092f\u093e analysis\u0964<\/p>\n\n\n\n<p>\ud83d\udc49 Practice \u0915\u0930\u0947\u0902 + Real examples \u092a\u0930 apply \u0915\u0930\u0947\u0902<br>\u0924\u092d\u0940 \u0906\u092a Excel \u092e\u0947\u0902 \u201cBeginner \u0938\u0947 Pro\u201d \u092c\u0928 \u092a\u093e\u090f\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction \u2013 Excel \u0938\u0940\u0916\u0928\u093e \u0915\u094d\u092f\u094b\u0902 \u091c\u093c\u0930\u0942\u0930\u0940 \u0939\u0948? \u0905\u0917\u0930 \u0906\u092a Student, Job Seeker, Accountant \u092f\u093e Business Owner \u0939\u0948\u0902, \u0924\u094b Excel \u0906\u092a\u0915\u0947 \u0930\u094b\u091c\u093c\u092e\u0930\u094d\u0930\u093e \u0915\u0947 \u0915\u093e\u092e \u0915\u094b \u0906\u0938\u093e\u0928 \u092c\u0928\u093e\u0928\u0947 \u0935\u093e\u0932\u093e \u0938\u092c\u0938\u0947 \u092c\u0922\u093c\u093f\u092f\u093e \u091f\u0942\u0932 \u0939\u0948\u0964\u0932\u0947\u0915\u093f\u0928 Excel \u092e\u0947\u0902 \u0924\u0947\u091c\u093c \u092c\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b Formulas \u0915\u093e basic knowledge \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f\u0964 \u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u0939\u092e \u091c\u093e\u0928\u0947\u0902\u0917\u0947 \u2014\ud83d\udc49 2025 \u092e\u0947\u0902 \u0939\u0930 Beginner \u0915\u094b&hellip;&nbsp;<a href=\"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[93],"tags":[176,117,179,178,177],"class_list":["post-402","post","type-post","status-publish","format-standard","hentry","category-excel","tag-basic-excel","tag-excel","tag-excel-for-beginners","tag-excel-formulas-in-hindi","tag-excel-tips-2025"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula - HackingWorlds<\/title>\n<meta name=\"description\" content=\"\u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u091c\u093e\u0928\u093f\u090f 2025 \u0915\u0947 \u0938\u092c\u0938\u0947 \u091c\u0930\u0942\u0930\u0940 Excel formulas \u091c\u0948\u0938\u0947 SUM, AVERAGE, IF \u0914\u0930 VLOOKUP \u2014 \u091c\u094b \u0939\u0930 beginner \u0915\u094b \u0938\u0940\u0916\u0928\u0947 \u091a\u093e\u0939\u093f\u090f\u0964 \u0906\u0938\u093e\u0928 examples \u0915\u0947 \u0938\u093e\u0925 step-by-step \u0938\u092e\u091d\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0964\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula - HackingWorlds\" \/>\n<meta property=\"og:description\" content=\"\u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u091c\u093e\u0928\u093f\u090f 2025 \u0915\u0947 \u0938\u092c\u0938\u0947 \u091c\u0930\u0942\u0930\u0940 Excel formulas \u091c\u0948\u0938\u0947 SUM, AVERAGE, IF \u0914\u0930 VLOOKUP \u2014 \u091c\u094b \u0939\u0930 beginner \u0915\u094b \u0938\u0940\u0916\u0928\u0947 \u091a\u093e\u0939\u093f\u090f\u0964 \u0906\u0938\u093e\u0928 examples \u0915\u0947 \u0938\u093e\u0925 step-by-step \u0938\u092e\u091d\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0964\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/\" \/>\n<meta property=\"og:site_name\" content=\"HackingWorlds\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-11T04:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-15T03:02:37+00:00\" \/>\n<meta name=\"author\" content=\"Ajeet singh Kushwah\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ajeet singh Kushwah\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/\"},\"author\":{\"name\":\"Ajeet singh Kushwah\",\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/#\\\/schema\\\/person\\\/1ea6f3387da252c305a9ef37339e1000\"},\"headline\":\"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula\",\"datePublished\":\"2025-11-11T04:30:00+00:00\",\"dateModified\":\"2025-11-15T03:02:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/\"},\"wordCount\":242,\"commentCount\":0,\"keywords\":[\"Basic Excel\",\"excel\",\"Excel for Beginners\",\"Excel Formulas in Hindi\",\"Excel Tips 2025\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/\",\"url\":\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/\",\"name\":\"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula - HackingWorlds\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/#website\"},\"datePublished\":\"2025-11-11T04:30:00+00:00\",\"dateModified\":\"2025-11-15T03:02:37+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/#\\\/schema\\\/person\\\/1ea6f3387da252c305a9ef37339e1000\"},\"description\":\"\u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u091c\u093e\u0928\u093f\u090f 2025 \u0915\u0947 \u0938\u092c\u0938\u0947 \u091c\u0930\u0942\u0930\u0940 Excel formulas \u091c\u0948\u0938\u0947 SUM, AVERAGE, IF \u0914\u0930 VLOOKUP \u2014 \u091c\u094b \u0939\u0930 beginner \u0915\u094b \u0938\u0940\u0916\u0928\u0947 \u091a\u093e\u0939\u093f\u090f\u0964 \u0906\u0938\u093e\u0928 examples \u0915\u0947 \u0938\u093e\u0925 step-by-step \u0938\u092e\u091d\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0964\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/2025\\\/11\\\/11\\\/10-excel-formulas-every-beginner-must-know-in-2025-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/hackingworlds.in\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/#website\",\"url\":\"https:\\\/\\\/hackingworlds.in\\\/\",\"name\":\"HackingWorlds\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hackingworlds.in\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hackingworlds.in\\\/#\\\/schema\\\/person\\\/1ea6f3387da252c305a9ef37339e1000\",\"name\":\"Ajeet singh Kushwah\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0c457cb6c2ba3aa4eca21fbac6e1d5b9e853b651f74fc6db49e6c8e1d5b488a2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0c457cb6c2ba3aa4eca21fbac6e1d5b9e853b651f74fc6db49e6c8e1d5b488a2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0c457cb6c2ba3aa4eca21fbac6e1d5b9e853b651f74fc6db49e6c8e1d5b488a2?s=96&d=mm&r=g\",\"caption\":\"Ajeet singh Kushwah\"},\"description\":\"Profession: Cybersecurity Expert, Purple Teamer, and Coder Certifications: CEH (Certified Ethical Hacker) CCNA (Cisco Certified Network Associate) RHCSA (Red Hat Certified System Administrator) RHCE (Red Hat Certified Engineer) MCSA (Microsoft Certified Solutions Associate) MCSE (Microsoft Certified Solutions Expert) Cloud Computing cybersecurity with a focus on Purple Team operations, coding, and advanced IT solutions. With extensive certifications and hands-on experience, you specialize in bridging the gap between offensive (Red Team) and defensive (Blue Team) cybersecurity strategies, while also excelling in network administration, system engineering, and cloud technologies.\",\"sameAs\":[\"https:\\\/\\\/hackingworlds.in\"],\"url\":\"https:\\\/\\\/hackingworlds.in\\\/index.php\\\/author\\\/kushwahajeetsingh2gmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula - HackingWorlds","description":"\u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u091c\u093e\u0928\u093f\u090f 2025 \u0915\u0947 \u0938\u092c\u0938\u0947 \u091c\u0930\u0942\u0930\u0940 Excel formulas \u091c\u0948\u0938\u0947 SUM, AVERAGE, IF \u0914\u0930 VLOOKUP \u2014 \u091c\u094b \u0939\u0930 beginner \u0915\u094b \u0938\u0940\u0916\u0928\u0947 \u091a\u093e\u0939\u093f\u090f\u0964 \u0906\u0938\u093e\u0928 examples \u0915\u0947 \u0938\u093e\u0925 step-by-step \u0938\u092e\u091d\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0964","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/","og_locale":"en_US","og_type":"article","og_title":"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula - HackingWorlds","og_description":"\u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u091c\u093e\u0928\u093f\u090f 2025 \u0915\u0947 \u0938\u092c\u0938\u0947 \u091c\u0930\u0942\u0930\u0940 Excel formulas \u091c\u0948\u0938\u0947 SUM, AVERAGE, IF \u0914\u0930 VLOOKUP \u2014 \u091c\u094b \u0939\u0930 beginner \u0915\u094b \u0938\u0940\u0916\u0928\u0947 \u091a\u093e\u0939\u093f\u090f\u0964 \u0906\u0938\u093e\u0928 examples \u0915\u0947 \u0938\u093e\u0925 step-by-step \u0938\u092e\u091d\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0964","og_url":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/","og_site_name":"HackingWorlds","article_published_time":"2025-11-11T04:30:00+00:00","article_modified_time":"2025-11-15T03:02:37+00:00","author":"Ajeet singh Kushwah","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ajeet singh Kushwah","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/#article","isPartOf":{"@id":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/"},"author":{"name":"Ajeet singh Kushwah","@id":"https:\/\/hackingworlds.in\/#\/schema\/person\/1ea6f3387da252c305a9ef37339e1000"},"headline":"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula","datePublished":"2025-11-11T04:30:00+00:00","dateModified":"2025-11-15T03:02:37+00:00","mainEntityOfPage":{"@id":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/"},"wordCount":242,"commentCount":0,"keywords":["Basic Excel","excel","Excel for Beginners","Excel Formulas in Hindi","Excel Tips 2025"],"articleSection":["Microsoft Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/","url":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/","name":"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula - HackingWorlds","isPartOf":{"@id":"https:\/\/hackingworlds.in\/#website"},"datePublished":"2025-11-11T04:30:00+00:00","dateModified":"2025-11-15T03:02:37+00:00","author":{"@id":"https:\/\/hackingworlds.in\/#\/schema\/person\/1ea6f3387da252c305a9ef37339e1000"},"description":"\u0907\u0938 \u092c\u094d\u0932\u0949\u0917 \u092e\u0947\u0902 \u091c\u093e\u0928\u093f\u090f 2025 \u0915\u0947 \u0938\u092c\u0938\u0947 \u091c\u0930\u0942\u0930\u0940 Excel formulas \u091c\u0948\u0938\u0947 SUM, AVERAGE, IF \u0914\u0930 VLOOKUP \u2014 \u091c\u094b \u0939\u0930 beginner \u0915\u094b \u0938\u0940\u0916\u0928\u0947 \u091a\u093e\u0939\u093f\u090f\u0964 \u0906\u0938\u093e\u0928 examples \u0915\u0947 \u0938\u093e\u0925 step-by-step \u0938\u092e\u091d\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0964","breadcrumb":{"@id":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/hackingworlds.in\/index.php\/2025\/11\/11\/10-excel-formulas-every-beginner-must-know-in-2025-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hackingworlds.in\/"},{"@type":"ListItem","position":2,"name":"2025 \u092e\u0947\u0902 \u0939\u0930 Excel Beginner \u0915\u094b \u0906\u0928\u0947 \u091a\u093e\u0939\u093f\u090f \u092f\u0947 10 \u091c\u0930\u0942\u0930\u0940 Excel Formula"}]},{"@type":"WebSite","@id":"https:\/\/hackingworlds.in\/#website","url":"https:\/\/hackingworlds.in\/","name":"HackingWorlds","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hackingworlds.in\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/hackingworlds.in\/#\/schema\/person\/1ea6f3387da252c305a9ef37339e1000","name":"Ajeet singh Kushwah","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0c457cb6c2ba3aa4eca21fbac6e1d5b9e853b651f74fc6db49e6c8e1d5b488a2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0c457cb6c2ba3aa4eca21fbac6e1d5b9e853b651f74fc6db49e6c8e1d5b488a2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c457cb6c2ba3aa4eca21fbac6e1d5b9e853b651f74fc6db49e6c8e1d5b488a2?s=96&d=mm&r=g","caption":"Ajeet singh Kushwah"},"description":"Profession: Cybersecurity Expert, Purple Teamer, and Coder Certifications: CEH (Certified Ethical Hacker) CCNA (Cisco Certified Network Associate) RHCSA (Red Hat Certified System Administrator) RHCE (Red Hat Certified Engineer) MCSA (Microsoft Certified Solutions Associate) MCSE (Microsoft Certified Solutions Expert) Cloud Computing cybersecurity with a focus on Purple Team operations, coding, and advanced IT solutions. With extensive certifications and hands-on experience, you specialize in bridging the gap between offensive (Red Team) and defensive (Blue Team) cybersecurity strategies, while also excelling in network administration, system engineering, and cloud technologies.","sameAs":["https:\/\/hackingworlds.in"],"url":"https:\/\/hackingworlds.in\/index.php\/author\/kushwahajeetsingh2gmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/posts\/402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/comments?post=402"}],"version-history":[{"count":2,"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/posts\/402\/revisions"}],"predecessor-version":[{"id":404,"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/posts\/402\/revisions\/404"}],"wp:attachment":[{"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/media?parent=402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/categories?post=402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hackingworlds.in\/index.php\/wp-json\/wp\/v2\/tags?post=402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}