How to Create a Pivot Table in Excel: A Step-by-Step Guide

<!DOCTYPE html>    <html lang="en-US" prefix="og: http://ogp.me/ns#" >  <head> <meta charset="UTF-8" /> <meta name="keywords" content="how to create a Pivot Table in Excel,Pivot Table Excel example,using Pivot Tables in Excel,build Pivot Table in Excel,Excel Pivot Table tutorial,Excel data analysis,Pivot Table from multiple sheets,Pivot Table chart in Excel,how to use Pivot Tables in Google Sheets,advanced Pivot Table features,pivot table excel,excel pivot sheet,excel pivottable,excel pivot table from pivot table,table pivot in excel,doing pivot tables in excel" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=0.5, maximum-scale=3.0"> <link rel="shortcut icon" href="https://media.geeksforgeeks.org/wp-content/cdn-uploads/gfg_favicon.png" type="image/x-icon" /> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <meta name="theme-color" content="#308D46" /> <meta name='robots' content='index, follow, max-image-preview:large, max-snippet:-1' /> <meta name="image" property="og:image" content="https://media.geeksforgeeks.org/wp-content/cdn-uploads/gfg_200x200-min.png"> <meta property="og:image:type" content="image/png"> <meta property="og:image:width" content="200"> <meta property="og:image:height" content="200"> <meta name="facebook-domain-verification" content="xo7t4ve2wn3ywfkjdvwbrk01pvdond" /> <script src="https://cdnads.geeksforgeeks.org/synchronously_gfg_ads.min.js"></script> <script defer src="https://apis.google.com/js/platform.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/require.js/2.1.14/require.min.js"></script>     <script> var IHPWT={}; //Initialize Namespace var pbjs = pbjs || {}; pbjs.que = pbjs.que || []; var googletag = googletag || {}; googletag.cmd = googletag.cmd || []; var gptRan = false; </script> <script defer src="https://ads.pubmatic.com/AdServer/js/pwt/162080/12331/pwt.js"></script> <script defer src="https://securepubads.g.doubleclick.net/tag/js/gpt.js"></script> <script defer src="https://cdnads.geeksforgeeks.org/prebid.js?ver=0.1"></script> <script defer src="https://cdnads.geeksforgeeks.org/gfg_ads.min.js?ver=0.1"></script>  <title>How to Create a Pivot Table in Excel: A Step-by-Step Guide</title> <link rel="profile" href="http://gmpg.org/xfn/11" /> <link rel="pingback" href="" />     <script type="application/ld+json"> { "@context": "https://schema.org", "@type": "Article", "mainEntityOfPage": { "@type": "WebPage", "id": "https://www.geeksforgeeks.org/pivot-tables-in-excel/" }, "headline": "How to Create a Pivot Table in Excel: Complete Excel Pivot Table Tutorial", "datePublished": "2021-05-20 12:00:15", "dateModified": "2024-11-21 04:17:14", "image": { "@type": "ImageObject", "url": "https://media.geeksforgeeks.org/wp-content/uploads/20240625101632/how-to-create-a-pivot-table-in-excel-(1).webp", "width": "1000", "height": "470" }, "author": { "@type": "Organization", "name": "GeeksforGeeks", "url": "https://www.geeksforgeeks.org/", "logo": { "@type": "ImageObject", "url": "https://media.geeksforgeeks.org/wp-content/cdn-uploads/logo-new-2.svg", "width": "301", "height": "40" } }, "publisher": { "@type": "Organization", "name": "GeeksforGeeks", "url": "https://www.geeksforgeeks.org/", "logo": { "@type": "ImageObject", "url": "https://media.geeksforgeeks.org/wp-content/cdn-uploads/logo-new-2.svg", "width": "301", "height": "40" } }, "description": "How to do Pivot Tables in Excel - Quick StepsTo quickly create a Pivot Table in Excel, follow these steps:Select your DataGo to the Insert Tab&gt;&gt; Select Pivot TableDrag and drop fields into the Rows, Columns, Values, and Filters areas within the PivotTable Fields pane.Adjust and Format Creating a Pivot", "about": [ { "@type": "Thing", "name": "Picked" }, { "@type": "Thing", "name": "Excel" }, { "@type": "Thing", "name": "MicrosoftOffice" }, { "@type": "Thing", "name": "Msexcel" }, { "@type": "Thing", "name": "ExcelHowTo" }, { "@type": "Thing", "name": "Excel" }, { "@type": "Thing", "name": "News" } ] }</script> <script type="application/ld+json"> { "@context": "https://schema.org", "@type": "WebSite", "url": "https://www.geeksforgeeks.org/", "potentialAction": { "@type": "SearchAction", "target": "https://www.geeksforgeeks.org/search/{search_term_string}/", "query-input": "required name=search_term_string" } }</script> <script type="application/ld+json"> { "@context": "https://schema.org", "@type": "Organization", "name": "GeeksforGeeks", "url": "https://www.geeksforgeeks.org/", "logo": "https://media.geeksforgeeks.org/wp-content/cdn-uploads/20200817185016/gfg_complete_logo_2x-min.png", "description": "A computer science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.", "founder": [ { "@type": "Person", "name": "Sandeep Jain", "url": "https://in.linkedin.com/in/sandeep-jain-b3940815" } ], "sameAs": [ "https://www.facebook.com/geeksforgeeks.org/", "https://twitter.com/geeksforgeeks", "https://www.linkedin.com/company/1299009", "https://www.youtube.com/geeksforgeeksvideos/" ] }</script> <script type="application/ld+json">{ "@context": "https://schema.org", "@type": "FAQPage", "mainEntity": [ { "@type": "Question", "name": "What is a Pivot Table in Excel?", "acceptedAnswer": { "@type": "Answer", "text": "A Pivot Table in Excel is a powerful tool that helps you summarize, analyze, and organize large data sets. By dragging and dropping fields, you can quickly view data in different ways, making it easier to generate insights and reports" } }, { "@type": "Question", "name": "How do I make a Pivot Table in Excel?", "acceptedAnswer": { "@type": "Answer", "text": "To make a Pivot Table in Excel, select your data, go to Insert > PivotTable, choose the location, and then drag fields to the Rows, Columns, Values, and Filters sections to create your custom table" } }, { "@type": "Question", "name": "How do I create a PivotTable with rows and columns?", "acceptedAnswer": { "@type": "Answer", "text": "To create Pivot Table with rows and columns follow the steps given below:Select Your DataGo to the Insert tabDrag the rows Drag the Columns" } }, { "@type": "Question", "name": "What is a PivotTable in Excel used for?", "acceptedAnswer": { "@type": "Answer", "text": "A PivotTable in Excel is used for:Summarizing DataAnalyzing DataData ExplorationCreating ReportsFiltering Data" } }, { "@type": "Question", "name": "What is a Pivot Table XLS file?", "acceptedAnswer": { "@type": "Answer", "text": "An Excel Pivot Table saved in .xls format refers to an older version of Excel files. You can create and work with Pivot Tables in both .xls and newer .xlsx formats." } }, { "@type": "Question", "name": "How do I create a pivot chart from Excel data?", "acceptedAnswer": { "@type": "Answer", "text": "Here are the steps to create a pivot table from the Excel data:Go to the Insert tabClick on PivotTableCustomize the PivotChart" } }, { "@type": "Question", "name": "Can I use Pivot Tables in Excel to create summaries?", "acceptedAnswer": { "@type": "Answer", "text": "Yes, doing Pivot Tables in Excel allows you to create summaries, aggregate data, and easily view key metric" } }, { "@type": "Question", "name": "How do I use Pivot Tables in Excel for data analysis?", "acceptedAnswer": { "@type": "Answer", "text": "To analyze data with Pivot Tables, you can group, filter, and sort data, perform calculations, and create custom views. Excel with Pivot Tables simplifies complex data analysis tasks." } }, { "@type": "Question", "name": "Can I create a Pivot Table from another Pivot Table?", "acceptedAnswer": { "@type": "Answer", "text": "Yes, you can create an Excel Pivot Table from a Pivot Table. Simply select the existing Pivot Table, then copy and paste it to a new location, and modify it as needed." } } ] }</script> <script> var arrPostCat = new Array(); var arrPostCatName="News"; arrPostCat.push('5037'); arrPostCat.push('7809'); arrPostCat.push('6669'); var tIds = "5037,7809,6669,5686,6308,7700,2963"; var termsNames = "Excel,MicrosoftOffice,News,excel,ExcelHowTo,MSExcel,Picked"; var tIdsInclusiveParents = "5037,7809,6669,5686,6308,7700,2963" var domain = 1; var arrPost = new Array(); var post_id = "606965"; var post_type = "post"; var post_slug = window.location.href; var ip = "64.252.71.161"; var post_title = `How to Create a Pivot Table in Excel: Complete Excel Pivot Table Tutorial`; var post_status = "publish"; var practiceAPIURL="https://practiceapi.geeksforgeeks.org/"; var practiceURL="https://practice.geeksforgeeks.org/"; var post_date = "2021-05-20 00:00:15"; var commentSysUrl = "https://discuss.geeksforgeeks.org/commentEmbedV2.js"; //var postAdApiUrlString = ""; var link_on_code_run = ''; var link_search_modal_top = ''; var country_code_cf = "US"; var postAdApiUrlString = '7809/5037/7809/6669/5686/6308/7700/2963/'; </script>  <meta name="description" content="Master Pivot Tables in Excel with this guide on creating, analyzing, and summarizing data. Learn grouping, building reports, and enhancing data insights easily."/> <link rel="canonical" href="https://www.geeksforgeeks.org/pivot-tables-in-excel/" /> <meta property="og:locale" content="en_US" /> <meta property="og:type" content="article" /> <meta property="og:title" content="How to Create a Pivot Table in Excel: A Step-by-Step Guide" /> <meta property="og:description" content="Master Pivot Tables in Excel with this guide on creating, analyzing, and summarizing data. Learn grouping, building reports, and enhancing data insights easily." /> <meta property="og:url" content="https://www.geeksforgeeks.org/pivot-tables-in-excel/" /> <meta property="og:site_name" content="GeeksforGeeks" /> <meta property="article:tag" content="excel" /> <meta property="article:tag" content="Excel-How To" /> <meta property="article:tag" content="MSExcel" /> <meta property="article:tag" content="Picked" /> <meta property="article:section" content="Excel" /> <meta property="article:published_time" content="2021-05-20T00:00:15+00:00" /> <meta property="article:modified_time" content="2024-11-21T16:17:10+00:00" /> <meta property="og:updated_time" content="2024-11-21T16:17:10+00:00" /> <script type='application/ld+json'>{"@context":"https:\/\/schema.org","@type":"Organization","url":"https:\/\/www.geeksforgeeks.org\/","sameAs":[],"@id":"https:\/\/www.geeksforgeeks.org\/#organization","name":"GeeksforGeeks","logo":"http:\/\/www.geeksforgeeks.org\/wp-content\/uploads\/gfg_200X200-1.png"}</script>  <link rel='dns-prefetch' href='//www.geeksforgeeks.org' /> <link rel='dns-prefetch' href='//s.w.org' /> <script type="text/javascript"> window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/11\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/11\/svg\/","svgExt":".svg","source":{"concatemoji":"https:\/\/www.geeksforgeeks.org\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.9.8"}}; !function(a,b,c){function d(a,b){var c=String.fromCharCode;l.clearRect(0,0,k.width,k.height),l.fillText(c.apply(this,a),0,0);var d=k.toDataURL();l.clearRect(0,0,k.width,k.height),l.fillText(c.apply(this,b),0,0);var e=k.toDataURL();return d===e}function e(a){var b;if(!l||!l.fillText)return!1;switch(l.textBaseline="top",l.font="600 32px Arial",a){case"flag":return!(b=d([55356,56826,55356,56819],[55356,56826,8203,55356,56819]))&&(b=d([55356,57332,56128,56423,56128,56418,56128,56421,56128,56430,56128,56423,56128,56447],[55356,57332,8203,56128,56423,8203,56128,56418,8203,56128,56421,8203,56128,56430,8203,56128,56423,8203,56128,56447]),!b);case"emoji":return b=d([55358,56760,9792,65039],[55358,56760,8203,9792,65039]),!b}return!1}function f(a){var c=b.createElement("script");c.src=a,c.defer=c.type="text/javascript",b.getElementsByTagName("head")[0].appendChild(c)}var g,h,i,j,k=b.createElement("canvas"),l=k.getContext&&k.getContext("2d");for(j=Array("flag","emoji"),c.supports={everything:!0,everythingExceptFlag:!0},i=0;i<j.length;i++)c.supports[j[i]]=e(j[i]),c.supports.everything=c.supports.everything&&c.supports[j[i]],"flag"!==j[i]&&(c.supports.everythingExceptFlag=c.supports.everythingExceptFlag&&c.supports[j[i]]);c.supports.everythingExceptFlag=c.supports.everythingExceptFlag&&!c.supports.flag,c.DOMReady=!1,c.readyCallback=function(){c.DOMReady=!0},c.supports.everything||(h=function(){c.readyCallback()},b.addEventListener?(b.addEventListener("DOMContentLoaded",h,!1),a.addEventListener("load",h,!1)):(a.attachEvent("onload",h),b.attachEvent("onreadystatechange",function(){"complete"===b.readyState&&c.readyCallback()})),g=c.source||{},g.concatemoji?f(g.concatemoji):g.wpemoji&&g.twemoji&&(f(g.twemoji),f(g.wpemoji)))}(window,document,window._wpemojiSettings); </script> <style type="text/css"> img.wp-smiley, img.emoji { display: inline !important; border: none !important; box-shadow: none !important; height: 1em !important; width: 1em !important; margin: 0 .07em !important; vertical-align: -0.1em !important; background: none !important; padding: 0 !important; } </style> <link rel='stylesheet' id='custom-style-css' href='https://www.geeksforgeeks.org/wp-content/themes/iconic-one/css/gfg.min.css?ver=11.71' type='text/css' media='all' /> <script type='text/javascript' src='https://code.jquery.com/jquery-3.7.1.min.js?ver=3.7.1'></script> <script type='text/javascript' src='https://code.jquery.com/jquery-migrate-3.5.2.min.js?ver=3.5.2'></script> <script type='text/javascript'> /* <![CDATA[ */ var gfgObject = {"authUrl":"https:\/\/auth.geeksforgeeks.org\/","writeApiUrl":"https:\/\/apiwrite.geeksforgeeks.org\/","writeUrl":"https:\/\/write.geeksforgeeks.org\/","utilUrl":"https:\/\/util.geeksforgeeks.org\/","apiUrl":"https:\/\/api.geeksforgeeks.org\/","cfApiUrl":"https:\/\/gfgapi.geeksforgeeks.org\/","baseCompilerURL":"https:\/\/codejudge.geeksforgeeks.org\/","idePageBaseUrl":"https:\/\/ide.geeksforgeeks.org\/","gfgApiScriptUrl":"https:\/\/apiscript.geeksforgeeks.org\/","gfgSiteUrl":"https:\/\/www.geeksforgeeks.org\/","curatedListId":"1","curatedListTitle":"SDE Sheet Problems","utilDjangoCfUrl":"https:\/\/utilapi.geeksforgeeks.org\/","premiumCheckoutSlug":"premium-plans-payment\/","premiumLandingSlug":"premium-plans\/","premiumCssUrl":"https:\/\/www.geeksforgeeks.org\/wp-content\/themes\/iconic-one\/css\/gfgpremium.min.css?ver=1.6","premiumJsUrl":"https:\/\/www.geeksforgeeks.org\/wp-content\/themes\/iconic-one\/js\/gfgpremium.min.js?ver=1.5","utilGoogleUrl":"https:\/\/ugprod.geeksforgeeks.org\/","communityApiUrl":"https:\/\/communityapi.geeksforgeeks.org\/","utilDjangoUrl":"https:\/\/gfgutil.geeksforgeeks.org\/","gfgPracticeUrl":"https:\/\/practiceapi.geeksforgeeks.org\/","gfgMediaUrl":"https:\/\/media.geeksforgeeks.org\/","authDjangoApiUrl":"https:\/\/authapi.geeksforgeeks.org\/","gfgMlApiUrl":"https:\/\/recommendations.geeksforgeeks.org\/","is_home":"","is_category":"","userlevelPremiumPlus":"2","practiceUrl":"https:\/\/practice.geeksforgeeks.org\/","gfgNotificationsApiUrl":"https:\/\/notificationsapi.geeksforgeeks.org\/"}; /* ]]> */ </script> <script type='text/javascript' async="async" src='https://www.geeksforgeeks.org/wp-content/themes/iconic-one/js/gfg.min.js?ver=13.36'></script> <link rel='shortlink' href='https://www.geeksforgeeks.org/?p=606965' /> <style> #wpadminbar{ background: #ff0000 !important; } </style> <style type="text/css" id="custom-background-css"> body.custom-background { background-color: #ffffff; } </style> <link rel="icon" href="https://www.geeksforgeeks.org/wp-content/uploads/gfg_200X200-100x100.png" sizes="32x32" /> <link rel="icon" href="https://www.geeksforgeeks.org/wp-content/uploads/gfg_200X200.png" sizes="192x192" /> <link rel="apple-touch-icon-precomposed" href="https://www.geeksforgeeks.org/wp-content/uploads/gfg_200X200.png" /> <meta name="msapplication-TileImage" content="https://www.geeksforgeeks.org/wp-content/uploads/gfg_200X200.png" />  <style> #internal-promo-section{ display: none !important; } @media screen and (max-width:1500px) and (min-width:1280px){ body.single .article-page_flex .leftBar { flex-basis: calc(100% - 605px); max-width: calc(100% - 605px); min-width: calc(100% - 605px); } .sidebar_wrapper{ max-width: 300px; min-width: 300px; } div#secondary { min-width: 300px; max-width: 300px; } .widget-area{ padding: 0px; } .article-page_flex .rightBar{ padding: 20px 0px 0px 0px; } .article--viewer_content .a-wrapper .content { padding: 0px 10px 55px 20px; } .oinLeftbar { height: calc(100vh - 350px) !important; } } .autoLeftBar_oin_child{ height: 100% !important; } .autoLeftBar_oin_non_sticky{ height: unset !important; } .sideBar--wrap.newLeftbar > div[id^='GFG_AD_Leftsidebar_']:nth-of-type(1){ padding-top: 20px; } .sideBar--wrap.newLeftbar > div[id^='GFG_AD_Leftsidebar_']{ padding: 5px 0; } @media (max-width:1043px) and (min-width:992px) { .hide-1043992 { display: none!important; } } .mobile-header-list-item{ padding-left:30px; padding-right:10px; margin-top:5px; } .mobile-header-list{ border-bottom: 1px solid rgba(158, 158, 158, 0.3) !important; } .mobile-header-list .dropdown-title{ border-bottom: none !important; font-size: 16px!important; padding: 0px!important; padding-left: 45px!important; font-weight: normal; } .mobile-header-list .upside::after{ transform: rotate(180deg); } </style>    </head> <body class="post-template-default single single-post postid-606965 single-format-standard custom-background custom-background-white"> <script> // Dark mode script const gfgThemeList = Object.freeze({ LIGHT: "gfgThemeLight", DARK: "gfgThemeDark" }) const getThemeFromCookie = () => { let gfg_def_theme = ""; let cookies = document.cookie; let cooks = cookies.split(";"); for (let i = 0; i < cooks.length; i++) { let icook = cooks[i].split("="); if (icook[0].trim() == "gfg_theme") { gfg_def_theme = icook[1].trim(); } } return gfg_def_theme } if(!(post_slug.includes('premium-plans-payment/') || post_slug.includes('premium-plans/'))){ var isDarkMode = getThemeFromCookie() == gfgThemeList.DARK ? true : false; document.querySelector("body").setAttribute("data-dark-mode", isDarkMode); } function setSearchBarFocus() { const myTimeout = setTimeout(searchBarFocus, 0); function searchBarFocus() { document.getElementById("gcse-search-input").focus(); } } </script>  <nav> <div class="header-main__wrapper"> <a class="gfg-stc" style="top:0" href="#main">Skip to content</a> <a href="https://www.geeksforgeeks.org/" aria-label="Logo" class="header-main__logo"> <div class="_logo">  <img class="gfg_logo_img" style="height: 30px; width: 80px; max-width: fit-content;" src="https://media.geeksforgeeks.org/gfg-gg-logo.svg" alt="geeksforgeeks"> </div> </a> <div class="header-main__container">   <ul class="header-main__list"><li class="header-main__list-item Header_1" data-parent="false" aria-expanded="true" data-expandable="true"><span>Courses</span><i class="gfg-icon gfg-icon_arrow-down gfg-icon_header"></i><ul class="mega-dropdown Screen_1"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/dsa-to-development-coding-guide?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">DSA to Development</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/data-science-live?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">Machine Learning & Data Science</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/mastering-generative-ai-and-chat-gpt?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">Generative AI & ChatGPT</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/search?query=AWS&itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">Become AWS Certified</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>DSA Courses</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/dsa-self-paced?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">Data Structure & Algorithm(C++/JAVA)</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/Data-Structures-With-Python?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">Data Structure & Algorithm(Python)</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/data-structures-and-algorithms-in-javascript?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">Data Structure & Algorithm(JavaScript)</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Programming Languages</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/cpp-programming-basic-to-advanced?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">CPP</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/Java-Programming-basic-to-advanced?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">Java</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/Python-Foundation?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">Python</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/javascript?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">JavaScript</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses/c-Programming-basic-to-advanced?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">C</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/courses?itm_source=geeksforgeeks&itm_medium=main_header&itm_campaign=courses" target="_self">All Courses</a></li></ul></li><li class="header-main__list-item Header_2" data-parent="false" aria-expanded="true" data-expandable="true"><span>Tutorials</span><i class="gfg-icon gfg-icon_arrow-down gfg-icon_header"></i><ul class="mega-dropdown Screen_1"><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Python Tutorial</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/taking-input-in-python/?ref=outind" target="_self">Taking Input in Python</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-operators/?ref=outind" target="_self">Python Operators</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-data-types/?ref=outind" target="_self">Python Data Types</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Python Loops and Control Flow</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python3-if-if-else-nested-if-if-elif-statements/?ref=outind" target="_self">Python Conditional Statements</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/loops-in-python/?ref=outind" target="_self">Python Loops</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-functions/?ref=outind" target="_self">Python Functions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-oops-concepts/?ref=outind" target="_self">Python OOPS Concept</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-data-structures-and-algorithms/?ref=outind" target="_self">Python Data Structures</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-exception-handling/?ref=outind" target="_self">Python Exception Handling</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/file-handling-python/?ref=outind" target="_self">Python File Handling</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-exercises-practice-questions-and-solutions/?ref=outind" target="_self">Python Exercises</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Java</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/java/?ref=outind" target="_self">Learn Java Programming Language</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/collections-in-java-2/?ref=outind" target="_self">Java Collections</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/java-8-features/?ref=outind" target="_self">Java 8 Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/java-programming-examples/?ref=outind" target="_self">Java Programs</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Java Interview Questions</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/java-interview-questions/?ref=outind" target="_self">Java Interview Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/core-java-interview-questions-for-freshers/?ref=outind" target="_self">Core Java Interview Questions-Freshers</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/top-20-java-multithreading-interview-questions-answers/?ref=outind" target="_self">Java Multithreading Interview Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/oops-interview-questions/?ref=outind" target="_self">OOPs Interview Questions and Answers</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/java-exercises/?ref=outind" target="_self">Java Exercises</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Java Quiz</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/quizzes/50-java-language-mcqs-with-answers-2/?ref=outind" target="_self">Java Quiz</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/java-multiple-choice-questions/?ref=outind" target="_self">Core Java MCQ</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/java-projects/?ref=outind" target="_self">Java Projects</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Advance Java</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/spring/?ref=outind" target="_self">Spring Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/spring-boot/?ref=outind" target="_self">Spring Boot Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/spring-boot-interview-questions/?ref=outind" target="_self">Spring Boot Interview Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/spring-mvc/?ref=outind" target="_self">Spring MVC Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/spring-mvc-interview-questions/?ref=outind" target="_self">Spring MVC Interview Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/hibernate-tutorial/?ref=outind" target="_self">Hibernate Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/hibernate-interview-questions/?ref=outind" target="_self">Hibernate Interview Questions</a></li></ul></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Programming Languages</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/javascript/?ref=outind" target="_self">JavaScript</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/c-plus-plus/?ref=outind" target="_self">C++</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/r-tutorial/?ref=outind" target="_self">R Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/sql-tutorial/?ref=outind" target="_self">SQL</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/php-tutorial/?ref=outind" target="_self">PHP</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/csharp-programming-language/?ref=outind" target="_self">C#</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/c-programming-language/?ref=outind" target="_self">C</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/scala-programming-language/?ref=outind" target="_self">Scala</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/perl-programming-language/?ref=outind" target="_self">Perl</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/golang/?ref=outind" target="_self">Go Language</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/kotlin-programming-language/?ref=outind" target="_self">Kotlin</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>System Design</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/system-design-tutorial/?ref=ghm" target="_self">System Design Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/software-design-patterns/?ref=outind" target="_self">Software Design Patterns</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/complete-roadmap-to-learn-system-design/?ref=outind" target="_self">System Design Roadmap</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/top-10-system-design-interview-questions-and-answers/?ref=outind" target="_self">Top 10 System Design Interview Questions and Answers</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Interview Corner</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/company-preparation/?ref=outind" target="_self">Company Preparation</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/interview-preparation-for-software-developer/?ref=outind" target="_self">Top Topics</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://practice.geeksforgeeks.org/company-tags/?ref=outind" target="_self">Practice Company Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/company-interview-corner/?ref=outind" target="_self">Interview Experiences</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/experienced-interview-experiences-company-wise/?ref=outind" target="_self">Experienced Interviews</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/internship-interview-experiences-company-wise/?ref=outind" target="_self">Internship Interviews</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/competitive-programming-a-complete-guide/?ref=outind" target="_self">Competitive Programming</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/quiz-corner-gq/?ref=outind" target="_self">Multiple Choice Quizzes</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/aptitude-questions-and-answers/?ref=outind" target="_self">Aptitude for Placements</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Computer Science Subjects</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/operating-systems/?ref=outind" target="_self">Operating System</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/dbms/?ref=outind" target="_self">DBMS</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/computer-network-tutorials/?ref=outind" target="_self">Computer Networks</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/engineering-mathematics-tutorials/?ref=outind" target="_self">Engineering Mathematics</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/computer-organization-and-architecture-tutorials/?ref=outind" target="_self">Computer Organization and Architecture</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/theory-of-computation-automata-tutorials/?ref=outind" target="_self">Theory of Computation</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/compiler-design-tutorials/?ref=outind" target="_self">Compiler Design</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/digital-electronics-logic-design-tutorials/#blg/?ref=outind" target="_self">Digital Logic</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/software-engineering/?ref=outind" target="_self">Software Engineering</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>DevOps</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/git-tutorial/?ref=outind" target="_self">GIT</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/aws-tutorial/?ref=outind" target="_self">AWS</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/docker-tutorial/?ref=outind" target="_self">Docker</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/kubernetes-tutorial/?ref=outind" target="_self">Kubernetes</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/microsoft-azure/?ref=outind" target="_self">Microsoft Azure Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/google-cloud-platform-tutorial/?ref=outind" target="_self">Google Cloud Platform</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Linux</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/linux-tutorial/?ref=outind" target="_self">Linux Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/linux-commands/?ref=outind" target="_self">Linux Commands A-Z</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/linux-commands-cheat-sheet/?ref=outind" target="_self">Linux Commands Cheatsheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/permissions-in-linux/?ref=outind" target="_self">File Permission Commands</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/beginners-guide-to-linux-system-administration/?ref=outind" target="_self">Linux System Administration</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/linux-file-system/?ref=outind" target="_self">Linux File System</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-linux-shell-shell-scripting/?ref=outind" target="_self">Linux Shell Scripting</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/network-configuration-trouble-shooting-commands-linux/?ref=outind" target="_self">Linux Networking</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/linux-interview-questions/?ref=outind" target="_self">Linux Interview Questions</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Software Testing</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/software-testing-tutorial/?ref=outind" target="_self">Software Testing Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/software-engineering/?ref=outind" target="_self">Software Engineering Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/software-testing-interview-questions/?ref=outind" target="_self">Testing Interview Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/jira-tutorial/?ref=outind" target="_self">Jira</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Databases</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/dbms/?ref=outind" target="_self">DBMS Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/sql-tutorial/?ref=outind" target="_self">SQL Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/postgresql-tutorial/?ref=outind" target="_self">PostgreSQL Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/mongodb-tutorial/?ref=outind" target="_self">MongoDB Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/sql-interview-questions/?ref=outind" target="_self">SQL Interview Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/mysql-interview-questions/?ref=outind" target="_self">MySQL Interview Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/pl-sql-interview-questions/?ref=outind" target="_self">PL/SQL Interview Questions</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Android</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/android-tutorial/?ref=outind" target="_self">Android Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/android-studio-tutorial/?ref=outind" target="_self">Android Studio Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/kotlin-android-tutorial/?ref=outind" target="_self">Kotlin For Android</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/android-projects-from-basic-to-advanced-level/?ref=outind" target="_self">Android Projects</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/top-50-android-interview-questions-answers-sde-i-to-sde-iii/?ref=outind" target="_self">Android Interview Questions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/6-weeks-of-android-app-development-free-project-based-learning/?ref=outind" target="_self">6 Weeks of Android App Development</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Excel</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/excel-tutorial/?ref=outind" target="_self">MS Excel Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-ms-excel/?ref=outind" target="_self">Introduction to MS Excel</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/data-analysis-in-excel/?ref=outind" target="_self">Data Analysis in Excel</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/basic-excel-formulas-and-functions/?ref=outind" target="_self">Basic Excel Formulas & Functions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/instant-data-analysis-in-advanced-excel/?ref=outind" target="_self">Data Analysis in Advanced Excel</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/workbooks-in-microsoft-excel/?ref=outind" target="_self">Workbooks</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/statistical-functions-in-excel-with-examples/?ref=outind" target="_self">Statistical Functions</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/data-visualization-in-excel/?ref=outind" target="_self">Data Visualization in Excel</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/pivot-tables-in-excel/?ref=outind" target="_self">Pivot Tables in Excel</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/working-with-excel-spreadsheets-in-python/?ref=outind" target="_self">Excel Spreadsheets in Python</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/basic-excel-shortcuts/?ref=outind" target="_self">Basic Excel Shortcuts</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Mathematics</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/number-theory/?ref=outind" target="_self">Number System</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/algebra/?ref=outind" target="_self">Algebra</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/linear-algebra/?ref=outind" target="_self">Linear Algebra</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/math-trigonometry/?ref=outind" target="_self">Trigonometry</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/set-theory/?ref=outind" target="_self">Set Theory</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/statistics/?ref=outind" target="_self">Statistics</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/probability-in-maths/?ref=outind" target="_self">Probability</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/geometry/?ref=outind" target="_self">Geometry</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/mensuration/?ref=outind" target="_self">Mensuration</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/logarithms/?ref=outind" target="_self">Logarithms</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/math-calculus/?ref=outind" target="_self">Calculus</a></li></ul></li></ul></li><li class="header-main__list-item Header_3" data-parent="false" aria-expanded="true" data-expandable="true"><span>DSA</span><i class="gfg-icon gfg-icon_arrow-down gfg-icon_header"></i><ul class="mega-dropdown Screen_1"><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Data Structures</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/array-data-structure-guide/?ref=outind" target="_self">Arrays</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/matrix/?ref=outind" target="_self">Matrix</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/string-data-structure/?ref=outind" target="_self">Strings</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-linked-list-data-structure/?ref=ghm" target="_self">Linked List</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/stack-data-structure/?ref=outind" target="_self">Stack</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/queue-data-structure/?ref=outind" target="_self">Queue</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-tree-data-structure-and-algorithm-tutorials/?ref=outind" target="_self">Tree</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/heap-data-structure/?ref=outind" target="_self">Heap</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/hashing-data-structure/?ref=outind" target="_self">Hashing</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/graph-data-structure-and-algorithms/?ref=outind" target="_self">Graph</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-set-data-structure-and-algorithm-tutorials/?ref=outind" target="_self">Set Data Structure</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-map-data-structure-and-algorithm-tutorials/?ref=outind" target="_self">Map Data Structure</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/advanced-data-structures/?ref=outind" target="_self">Advanced Data Structure</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-data-structures/?ref=outind" target="_self">Data Structures Tutorial</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Algorithms</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Analysis of Algorithms</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/design-and-analysis-of-algorithms/?ref=outind" target="_self">Design and Analysis of Algorithms</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/asymptotic-notation-and-analysis-based-on-input-size-of-algorithms/?ref=outind" target="_self">Asymptotic Analysis</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/types-of-asymptotic-notations-in-complexity-analysis-of-algorithms/?ref=outind" target="_self">Asymptotic Notations</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/worst-average-and-best-case-analysis-of-algorithms/?ref=outind" target="_self">Worst, Average and Best Cases</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Searching Algorithms</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/linear-search/?ref=outind" target="_self">Linear Search</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/binary-search/?ref=outind" target="_self">Binary Search</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/searching-algorithms/?ref=outind" target="_self">Searching Algorithms Tutorial</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Sorting Algorithms</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/selection-sort/?ref=outind" target="_self">Selection Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/bubble-sort/?ref=outind" target="_self">Bubble Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/insertion-sort/?ref=outind" target="_self">Insertion Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/merge-sort/?ref=outind" target="_self">Merge Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/quick-sort/?ref=outind" target="_self">Quick Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/heap-sort/?ref=outind" target="_self">Heap Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/counting-sort/?ref=outind" target="_self">Counting Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/radix-sort/?ref=outind" target="_self">Radix Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/bucket-sort-2/?ref=outind" target="_self">Bucket Sort</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-sorting-algorithm/?ref=outind" target="_self">Sorting Algorithms Tutorial</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-greedy-algorithm-data-structures-and-algorithm-tutorials/?ref=outind" target="_self">Greedy Algorithms</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-dynamic-programming-data-structures-and-algorithm-tutorials/?ref=outind" target="_self">Dynamic Programming</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-graphs-data-structure-and-algorithm-tutorials/?ref=outind" target="_self">Graph Algorithms</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-pattern-searching-data-structure-and-algorithm-tutorial/?ref=outind" target="_self">Pattern Searching</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-recursion-data-structure-and-algorithm-tutorials/?ref=outind" target="_self">Recursion</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-backtracking-data-structure-and-algorithm-tutorials/?ref=outind" target="_self">Backtracking</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-divide-and-conquer-algorithm-data-structure-and-algorithm-tutorials/?ref=outind" target="_self">Divide and Conquer</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/mathematical-algorithms/?ref=outind" target="_self">Mathematical Algorithms</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/geometric-algorithms/?ref=outind" target="_self">Geometric Algorithms</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-bitwise-algorithms-data-structures-and-algorithms-tutorial/?ref=outind" target="_self">Bitwise Algorithms</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/randomized-algorithms/?ref=outind" target="_self">Randomized Algorithms</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-branch-and-bound-data-structures-and-algorithms-tutorial/?ref=outind" target="_self">Branch and Bound</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-algorithms/?ref=outind" target="_self">Algorithms Tutorial</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/learn-data-structures-and-algorithms-dsa-tutorial/?ref=outind" target="_self">DSA Tutorial</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Practice</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&sortBy=submissions&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">All DSA Problems</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/problem-of-the-day?itm_source=geeksforgeeksitm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Problem of the Day</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Company Wise Coding Practice</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&company=Amazon&sortBy=submissions&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Amazon</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&company=Microsoft&sortBy=submissions&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Microsoft</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&company=Flipkart&sortBy=submissions&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Flipkart</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&sortBy=submissions&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Explore All</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&curated[]=1&sortBy=submissions&curated_names[]=SDE Sheet?itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">GfG SDE Sheet</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Practice Problems Difficulty Wise</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&difficulty=School&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">School</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&difficulty=Basic&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Basic</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&difficulty=Easy&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Easy</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&difficulty=Medium&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Medium</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&difficulty=Hard&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Hard</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Language Wise Coding Practice</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&category=CPP&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">CPP</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&category=Java&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Java</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?category=python&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Python</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Curated DSA Lists</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&sprint=ca8ae412173dbd8346c26a0295d098fd&sortBy=submissions&sprint_name=Beginner's DSA Sheet&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Beginner's DSA Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&sprint=50746f92a895c22a50504ac0c1fb9c84&sortBy=submissions&sprint_name=Top 50 Array Problems&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Top 50 Array Problems</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&sprint=57184072610b884e5df3584cc534115d&sortBy=submissions&sprint_name=Top 50 String Problems&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Top 50 String Problems</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&sprint=93d672753b74440c7427214c8ebf866d&sortBy=submissions&sprint_name=Top 50 DP Problems&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Top 50 DP Problems</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&sprint=405e9db0f353691ad3b2d546b19145e9&sortBy=submissions&sprint_name=Top 50 Graph Problems&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Top 50 Graph Problems</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/explore?page=1&sprint=5f24de84b65bf7c4f4399c8111e26b81&sortBy=submissions&sprint_name=Top 50 Tree Problems&itm_source=geeksforgeeks&itm_medium=main_header_outIndia&itm_campaign=DSA_Header" target="_self">Top 50 Tree Problems</a></li></ul></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/competitive-programming-a-complete-guide/?ref=outind" target="_self">Competitive Programming</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Company Wise SDE Sheets</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/facebookmeta-sde-sheet-interview-questions-and-answers/?ref=outind" target="_self">Facebook SDE Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/amazon-sde-sheet-interview-questions-and-answers/?ref=outind" target="_self">Amazon SDE Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/apple-sde-sheet-interview-questions-and-answers/?ref=outind" target="_self">Apple SDE Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/netflix-sde-sheet-interview-questions-and-answers/?ref=outind" target="_self">Netflix SDE Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/google-sde-sheet-interview-questions-and-answers/?ref=outind" target="_self">Google SDE Sheet</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>DSA Cheat Sheets</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/sde-sheet-a-complete-guide-for-sde-preparation/?ref=outind" target="_self">SDE Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/most-asked-dsa-interview-problems-for-beginners/?ref=outind" target="_self">DSA Sheet for Beginners</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/must-do-coding-questions-for-companies-like-amazon-microsoft-adobe/?ref=outind" target="_self">FAANG Coding Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/must-do-coding-questions-for-product-based-companies/?ref=outind" target="_self">Product-Based Coding Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/must-coding-questions-company-wise/?ref=outind" target="_self">Company-Wise Preparation Sheet</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/top-100-data-structure-and-algorithms-dsa-interview-questions-topic-wise/?ref=outind" target="_self">Top Interview Questions</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Puzzles</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/puzzles/?ref=outind" target="_self">All Puzzles</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/top-100-puzzles-asked-in-interviews/?ref=outind" target="_self">Top 100 Puzzles Asked In Interviews</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/top-20-puzzles-commonly-asked-during-sde-interviews/?ref=outind" target="_self">Top 20 Puzzles Commonly Asked During SDE Interviews</a></li></ul></li></ul></li><li class="header-main__list-item Header_4" data-parent="false" aria-expanded="true" data-expandable="true"><span>Data Science</span><i class="gfg-icon gfg-icon_arrow-down gfg-icon_header"></i><ul class="mega-dropdown Screen_1"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-programming-language/?ref=outind" target="_self">Python Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/r-tutorial/?ref=outind" target="_self">R Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/machine-learning/?ref=outind" target="_self">Machine Learning</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/data-science-with-python-tutorial/?ref=outind" target="_self">Data Science using Python</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/r-programming-for-data-science/?ref=outind" target="_self">Data Science using R</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Data Science Packages</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/pandas-tutorial/?ref=outind" target="_self">Pandas Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/numpy-tutorial/?ref=outind" target="_self">NumPy Tutorial</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Data Visualization</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/python-data-visualization-tutorial/?ref=outind" target="_self">Python Data Visualization Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/data-visualization-in-r/?ref=outind" target="_self">Data Visualization with R</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Data Analysis</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/data-analysis-with-python/?ref=outind" target="_self">Data Analysis with Python</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/data-analysis-using-r/?ref=outind" target="_self">Data Analysis with R</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/deep-learning-tutorial/?ref=outind" target="_self">Deep Learning</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/natural-language-processing-nlp-tutorial/?ref=outind" target="_self">NLP Tutorial</a></li></ul></li><li class="header-main__list-item Header_5" data-parent="false" aria-expanded="true" data-expandable="true"><span>Web Tech</span><i class="gfg-icon gfg-icon_arrow-down gfg-icon_header"></i><ul class="mega-dropdown Screen_1"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/html-tutorial/?ref=outind" target="_self">HTML Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/css-tutorial/?ref=outind" target="_self">CSS Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/javascript/?ref=outind" target="_self">JavaScript Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/php-tutorial/?ref=outind" target="_self">PHP Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/react-tutorial/?ref=outind" target="_self">ReactJS Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/nodejs/?ref=outind" target="_self">NodeJS Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/bootstrap/?ref=outind" target="_self">Bootstrap Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/typescript/?ref=outind" target="_self">Typescript</a></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Web Development Using Python</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Django</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/django-tutorial/?ref=outind" target="_self">Django Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/top-django-projects-for-beginners/?ref=outind" target="_self">Django Projects</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/django-interview-questions/?ref=outind" target="_self">Django Interview Questions</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Flask</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_3"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/flask-tutorial/?ref=outind" target="_self">Flask Tutorial</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/flask-projects/?ref=outind" target="_self">Flask Projects</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/flask-interview-questions-and-answers/?ref=outind" target="_self">Flask Interview Questions</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/postman-tutorial/?ref=outind" target="_self">Postman</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/introduction-to-github/?ref=outind" target="_self">Github</a></li></ul></li><li class="mega-dropdown__list-item" data-parent="false" aria-expanded="true" data-expandable="true"><span>Cheat Sheets</span><i class="gfg-icon gfg-icon_arrow-right"></i><ul class="mega-dropdown Screen_2"><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/html-cheat-sheet-a-basic-guide-to-html/?ref=outind" target="_self">HTML Cheat Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/css-cheat-sheet-a-basic-guide-to-css/?ref=outind" target="_self">CSS Cheat Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/javascript-cheat-sheet-a-basic-guide-to-javascript/?ref=outind" target="_self">JavaScript Cheat Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/react-cheat-sheet/?ref=outind" target="_self">React Cheat Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/angular-cheat-sheet-a-basic-guide-to-angular/?ref=outind" target="_self">Angular Cheat Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/jquery-cheat-sheet-a-basic-guide-to-jquery/?ref=outind" target="_self">jQuery Cheat Sheet</a></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/bootstrap-cheatsheet-a-basic-guide-to-bootstrap/?ref=outind" target="_self">Bootstrap Cheat Sheet</a></li></ul></li><li class="mega-dropdown__list-item" data-child="true" aria-expanded="false" data-expandable="false"><a href="https://www.geeksforgeeks.org/web-development/?ref=outind" target="_self">Learn Complete Web Development</a></li></ul></li></ul>  <ul class="header-main__left-list" data-nl="false"> <li class="header-main__left-list-item gcse-search_li p-relative" aria-expanded="false" data-expandable="false"> <div class="gcse-form-search-suggestion_wrapper"> <form id="gcse-form" class="gcse-form_class p-relative closeChatScreen" data-sm="false"> <span class="front-search-icon"><i class="gfg-icon gfg-icon_search gfg-icon_white gcse-search__icon gcse-search-icon_grey"></i> </span> <input class="gcse-search-input__wrapper" id="gcse-search-input" aria-expanded="false" placeholder="Search..." autocomplete="off" /> <i class="gfg-icon gfg-icon_times gfg-icon_white hide-search"></i> <button aria-label="search" type="submit" class="gcse-search__btn not-expanded"> <i class="gfg-icon gfg-icon_search gfg-icon_white gcse-search__icon"></i> </button> </form> <div class="gfg-search-suggestion_wrapper" style="display:none"></div> <div> </li> <li> <div class="darkMode-wrap" data-mode="Switch to Dark Mode"> <button aria-label="toggle theme" data-gfg-action="toggleGFGTheme"> <div id="darkMode-wrap-red-dot" style="height:12px;width:12px;background-color:#EB2222;border-radius:999999px;position:absolute;top:4px;right:0;display:none;"></div> <i class="gfg-icon gfg-icon_dark-mode"></i> </button> <span id="darkModeTooltipText"></span> </div> </li> <li class="header-main__left-list-item google-translate-parent-element" aria-expanded="false" data-expanded="true"> <div class="translate" id="g_translater"> <div id="google_translate_element" data-show="false"></div> </div> <i class ="gfg-icon gfg-icon_translate googleTranslateToggle" data-gfg-action="google_translate_element"></i>   </li> <li id="userProfileId" class="header-main__left-list-item p-relative" aria-expanded="false" data-expandable="false">  </li> </ul> </div>   </div> </nav> <div class="header-main__slider"> <button aria-label="sub header slider previous" class="header-main__slider-arrow previous hideIt"> <i class="gfg-icon gfg-icon_arrow-left gicon-centered"></i> </button>  <ul id="hslider"> <li><a href="https://www.geeksforgeeks.org/excel-tutorial/?ref=shm">Excel Tutorial</a></li><li><a href="https://www.geeksforgeeks.org/basic-excel-formulas/?ref=shm">Excel Formulas</a></li><li><a href="https://www.geeksforgeeks.org/basic-excel-shortcuts/?ref=shm">Excel Shortcut Keys</a></li><li><a href="https://www.geeksforgeeks.org/data-analysis-in-excel/?ref=shm">Data Analysis in Excel</a></li><li><a href="https://www.geeksforgeeks.org/data-formatting-in-excel/?ref=shm">Formatting in Excel</a></li><li><a href="https://www.geeksforgeeks.org/workbooks-in-microsoft-excel/?ref=shm">Excel Workbooks</a></li><li><a href="https://www.geeksforgeeks.org/statistical-functions-in-excel-with-examples/?ref=shm">Statistical Functions</a></li><li><a href="https://www.geeksforgeeks.org/data-visualization-in-excel/?ref=shm">Data Visualization in Excel</a></li><li><a href="https://www.geeksforgeeks.org/pivot-tables-in-excel/?ref=shm">Pivot Tables in Excel</a></li><li><a href="https://www.geeksforgeeks.org/ms-excel-quiz-questions-and-answers/?ref=shm">MS Excel Quiz</a></li><li><a href="https://www.geeksforgeeks.org/excel-interview-questions-and-answers/?ref=shm">Excel Interview Questions</a></li><li><a href="https://www.geeksforgeeks.org/tag/excel-advanced/?ref=shm">Advance Excel</a></li> </ul> <button aria-label="sub header slider next" class="header-main__slider-arrow next hideIt"> <i class="gfg-icon gfg-icon_arrow-right gicon-centered"></i> </button> </div> <button id="scrollTopBtn" title="Scroll to Top" type="button" class="btn btn-success">▲</button>  <div id="main" class="wrapper single-page"> <script> if(post_slug.includes('premium-plans-payment/') || post_slug.includes('premium-plans/')){ $(".header-main__slider").remove(); } //getting tags for the page type data let mobileView = false; let pageTags = JSON.parse('null'); let allTags = JSON.parse('{"0":"Excel","1":"MicrosoftOffice","3":"News","4":"excel","5":"ExcelHowTo","6":"MSExcel","7":"Picked"}'); </script> <script> window.have_dsa_term = false; // var practiceTab = ; </script> <style> .wrapper { flex-direction: column !important; } /* spinner css */ @keyframes spinner { to {transform: rotate(360deg);} } .spinner:before { content: ''; box-sizing: border-box; position: absolute; top: 50%; left: 50%; width: 20px; height: 20px; margin-top: -10px; margin-left: -10px; border-radius: 50%; border: 2px solid #ccc; border-top-color: #000; animation: spinner .6s linear infinite; } .report-loader{ position: relative; } .report-loader.spinner{ margin-left: 16px; } .badges{ display: flex; align-items: center; position: relative; } .badges .gfg-badge-icon.md::after{ transform: scale(0.25); position:relative; top: 2px; left: -2px; } .sep{ margin: 0px 5px; font-size: 20px; color: var(--badge-name-color); } .pub-count{ font-size: 14px; font-family: var(--font-secondary); } .badge-details{ display:none; } .badges{ cursor: pointer; position: relative; /* width: 0px; height: 20px; top: -32px; */ } .badge-icon{ display: flex; align-items: center; } .badge-content{ margin-left: 9px; } .badge-name{ color: var(--badge-nam-color); font-weight: 600; font-size: 16px; text-transform: capitalize; } .badge-data{ color: #A5A4A4; font-size: 10px; } .badges:hover .badge-details{ display: block; background: var(--badge-bg); padding: 10px 18px 10px 18px; position: absolute; width: 175px; top: -10px; z-index: 10; left: 112%; box-shadow: rgb(100 100 111 / 20%) 0px 7px 29px 0px; border-radius: 5px; /* transform-origin: top right; */ } .badge-details::before { content: ""; position: absolute; transform: rotate(90deg); /* transform-origin: right; */ left: -6px; top: 50%; margin-left: -17px; border-width: 12px; border-style: solid; border-color: var(--badge-bg) transparent transparent transparent; margin-top: -12px; } .badge-icon .icon{ border: 1px solid var(--icon-border-color); padding: 4px 3px; border-radius: 4px; width: 22px; height: 24px; position: relative; } .b-icon-pos{ position: relative; top: -34px; left: -34px; } /* article viewer */ .article--viewer .a-wrapper{ margin-top: 0px !important; } .content{ padding-top: 10px !important; } .u-name{ font-size: 14px; } .article--viewer_content .a-wrapper .content{ padding-bottom: 10px !important; } .likeTooltipBottom{ font-size: 14px; } @media (max-width: 434px) { .article-buttons.show-bg{ margin-top: 56px !important; } } @media (max-width: 730px), ((min-width: 992px) and (max-width:1100px)) { .article--viewer .media{ position: relative; } .article--viewer .media{ margin-bottom: 0px !important; } .badges:hover .badge-details{ top: -56px; left: 62px; } .badge-details::before{ transform: rotate(0deg); left: 10%; top: 117%; } .article-buttons.show-bg{ margin-top: 22px; top: 0px !important; } } @media ((min-width:731px) and (max-width:1223px)) { .article-buttons.show-bg{ top: 18px; } } @media ((min-width:993px) and (max-width:1190px)) { .article--viewer .media{ position: relative; } .article--viewer .media{ margin-bottom: 25px !important; } } </style>  <script> function getCookie(name) { function escape(s) { return s.replace(/([.*+?\^$(){}|\[\]\/\\])/g, '\\$1'); } var match = document.cookie.match(RegExp('(?:^|;\\s*)' + escape(name) + '=([^;]*)')); return match ? match[1] : null; } </script>    <div id='openInApp-modal' class='openInApp'> <a href = 'https://geeksforgeeksapp.page.link/?link=https://www.geeksforgeeks.org/pivot-tables-in-excel/?type%3Darticle%26id%3D606965&apn=free.programming.programming&isi=1641848816&ibi=org.geeksforgeeks.GeeksforGeeksDev&efr=1' class='openInAppLink'> <span style='color: #fff;'>Open In App</span> </a> </div> <script> var consentValue = localStorage.getItem("gfg_cc"); var isIOS = !!navigator.platform && /iPad|iPhone|iPod|MacIntel/.test(navigator.platform) && navigator.maxTouchPoints > 0; const isSafari = navigator.userAgent.indexOf("Safari") > -1; const isMozilla = navigator.userAgent.indexOf("Mozilla") > -1; if(consentValue){ if(window.innerHeight > window.innerWidth && navigator.maxTouchPoints > 1 && (isSafari || isMozilla || navigator.userAgentData.mobile)){ $('.openInApp').css({ display: "block" }); $('#scrollTopBtn').css({ bottom: "44px" }); //adding a new class to check stats for clicks on iOS and Android isIOS ? jQuery('.openInAppLink').addClass("oia-iOS") : $('.openInAppLink').addClass("oia-android"); //for openInApp Link } } </script> <style> .openInApp{ display: none; bottom: 0px; width: 100%; position: fixed; z-index: 1025; opacity: 0.93; } .openInAppLink{ height: 44px; background: var(--color-gfg); font-weight: bold; display: block; text-align: center; padding: 12px; font-size: large; } .openInAppLink, .openInAppLink:hover, .openInAppLink:active, .openInAppLink:visited, .openInAppLink:focus { text-decoration:none; } </style>  <div class="container-fluid bg-light" id="home-page" style="position: relative; max-width:100%;"> <div class="article-page_flex"> <div class="sidebar_wrapper auto_leftbar "> <div class="sideBar autoLeftBar_oin_non_sticky" style="height: unset !important">  <div class="sideBar--wrap newLeftbar autoLeftBar_oin_child"> <div id="GFG_AD_Leftsidebar_300x250_chained_1"></div> <div id="GFG_AD_Leftsidebar_300x250_chained_2"></div> <div id="GFG_AD_Leftsidebar_300x250_chained_3"></div> <div id="GFG_AD_Leftsidebar_300x600_chained_1"></div> </div> </div> <div id="GFG_AD_Desktop_LeftSideBar_Docked_160x600" style="max-width:160px; max-height:600px"></div> </div>  <link rel="stylesheet" href="https://www.geeksforgeeks.org/wp-content/themes/iconic-one/css/article-page.min.css?ver=1.02"/> <style> @media screen and (max-width: 1500px) and (min-width: 1280px){ .article_outer_section{ flex-basis: calc(80.5% - 390px); max-width: calc(80.5% - 390px); min-width: calc(80.5% - 390px); } } </style> <div id="article_container" class="article_outer_section" style="position: relative;"> <div style="z-index:9999 !important;position: absolute;right: 0;"> </div>  <div id="article_section_1" class="article_section post-606965 post type-post status-publish format-standard hentry category-excel category-microsoft-office category-news tag-excel tag-excel-how-to tag-msexcel tag-picked" id="post-606965"> <div class="article_details_wrapper"> <div class="article_title"> <h1>How to Create a Pivot Table in Excel: Complete Excel Pivot Table Tutorial</h1> </div> <div class="last_updated">Last Updated: 21 Nov, 2024</div> <div id="main_author" class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B5EAEA; ">R</p> <i class="author_badge proficient"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/riyaaggarwaldtu/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">riya aggarwal</a> </div> <div class="author_follow follow_icon" value= "riyaaggarwaldtu" onclick=followUnfollow(event);><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> <div class="article_action_btns"> <div class="top-summary-icon-div"> <i class= "summary_button" style="position: relative;"></i> <span class="gfg_tooltip">Summarize</span> </div> <div class="comment_top_icon_wrapper top-comment-icon-div"> <i class= "discuss_button" style="position: relative;"></i> <span class="gfg_tooltip">Comments</span> </div> <div class='improve_top_icon_wrapper'> <i class="gfg_icon gfg_icon_pencil" onclick= improveArticleCall(); ></i> <span class="gfg_tooltip">Improve</span> </div> <div id="threeDotsIcon" class="article_three_dots closeChatScreen"> <div></div> <div></div> <div></div> </div> <div id="myDropdown" class="three_dot_dropdown_content"> <div class="article-buttons drop" onmouseleave="closeKebabMenu()"> <div pid="606965" ptitle="How to Create a Pivot Table in Excel: Complete Excel Pivot Table Tutorial" class="improve_article--viewer tooltip"> <div class="three_dot_dropdown_div three_dot_dropdown_improve" onclick="suggestionArticleCall()" style="margin-top: 1px;"> <div class="three_dot_dropdown_inner_div improve_dot_dropdown_inner_div"> <i class="gfg-icon gfg-icon_suggest_changes gfg-icon_edit"></i> <span>Suggest changes</span> </div> </div> </div> <div pid="606965" class="article--viewer_like tooltip"> <span class="tooltiptext likeTooltip">Like Article</span> <div class="three_dot_dropdown_div three_dot_dropdown_likearticle"> <div class="three_dot_dropdown_inner_div" data-gfg-action="like-article" data-bookmark-value="0"> <i class="gfg-icon gfg-icon_thumbs"></i> <span>Like</span> </div> </div> </div> <div pid="606965" class="article--viewer_bookmark tooltip"> <div class="three_dot_dropdown_div three_dot_dropdown_save"> <div class="three_dot_dropdown_inner_div" data-gfg-action="bookmark-article" data-bookmark-value="0"> <i class="gfg-icon gfg-icon_bookmark"></i> <span>Save</span> </div> </div> </div> <div pid="606965" class="article--viewer_share tooltip"> <div class="three_dot_dropdown_div three_dot_dropdown_share" onmouseleave="closeShareModal()" onmouseenter="openShareModal()"> <div style="display: flex;align-items: center;" class="three_dot_dropdown_inner_div" data-gfg-action="share-article" data-bookmark-value="0"> <i class="gfg-share-icon"></i> <span>Share</span> </div> </div> </div> <div class="article--viewer_report tooltip"> <div class="three_dot_dropdown_div three_dot_dropdown_reportarticle"> <div class="three_dot_dropdown_inner_div" data-gfg-action="report-article" onclick="report_article();"> <i class="gfg-icon gfg-icon_report"></i> <span>Report</span> </div> </div> </div> <div class="article--viewer_Gnews tooltip"> <a class="three_dot_dropdown_inner_div Gnews_wrapper" href ='https://news.google.com/publications/CAAqBwgKMLTrzwsw44bnAw?hl=en-IN&gl=IN&ceid=IN%3Aen' target="_blank"> <img class="gfg-icon_Gnews no-zoom-in-cursor" src=https://media.geeksforgeeks.org/auth-dashboard-uploads/Google-news.svg loading="lazy" alt="News"></img> <span class='kebab_menu_news_text'>Follow</span> </a> </div> </div> </div> </div> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <blockquote> <h2><span>How to do Pivot Tables in Excel – Quick Steps</span></h2> <p dir="ltr"><span>To quickly create a Pivot Table in Excel, follow these steps:</span></p> <ul> <li value="1"><span>Select your </span><b><strong>Data</strong></b></li> <li value="2"><span>Go to the </span><b><strong>Insert Tab</strong></b><span>>> Select </span><b><strong>Pivot Table</strong></b></li> <li value="3"><span>Drag and drop fields into the </span><b><strong>Rows</strong></b><span>, </span><b><strong>Columns</strong></b><span>, </span><b><strong>Values</strong></b><span>, and </span><b><strong>Filters areas</strong></b><span> within the PivotTable Fields pane.</span></li> <li value="4"><span>Adjust and Format </span></li> </ul> </blockquote> <p dir="ltr" style="text-align: justify;"><span>Creating a Pivot Table in Excel can significantly simplify data analysis by allowing you to summarize, filter, and organize large datasets with ease. This article will guide you through the step-by-step process of building a Pivot Table to transform complex data into actionable insights. </span></p> <p dir="ltr" style="text-align: justify;"><span>Whether you are managing sales data, analyzing trends, or tracking performance metrics, a Pivot Table empowers users to customize their views and make informed decisions efficiently. This guide is especially useful for individuals who frequently handle large datasets and want a faster way to analyze and visualize data in Excel.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625101632/how-to-create-a-pivot-table-in-excel-(1).webp" alt="how-to-create-a-pivot-table-in-excel-(1)" width="1000" height="470" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625101632/how-to-create-a-pivot-table-in-excel-(1).webp 1000w,https://media.geeksforgeeks.org/wp-content/uploads/20240625101632/how-to-create-a-pivot-table-in-excel-(1)-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20240625101632/how-to-create-a-pivot-table-in-excel-(1)-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20240625101632/how-to-create-a-pivot-table-in-excel-(1)-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20240625101632/how-to-create-a-pivot-table-in-excel-(1)-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20240625101632/how-to-create-a-pivot-table-in-excel-(1)-768.webp 768w"><p class="wp-caption-text">How to Create a Pivot Table in Excel</p></div> <div id="table_of_content"> <p style="margin:4px; font-size:20px; font-weight:bold;">Table of Content</p> <ul> <li><a href="#what-is-a-pivot-table-in-excel">What is a Pivot Table in Excel?</a></li> <li><a href="#what-are-pivot-tables-used-for">What are Pivot Tables used for?</a></li> <li><a href="#how-to-make-a-pivot-table-in-excel">How to Make a Pivot Table in Excel</a></li> <li><a href="#how-to-create-pivot-table-columns-area-in-excel">How to Create Pivot Table Columns Area in Excel</a></li> <li><a href="#how-to-add-filter-area-in-excel">How to Create a Pivot Table with Multiple Columns</a></li> <li><a href="#how-to-use-pivot-tables-in-excel-essential-features">How to Use Pivot Tables in Excel: Essential Features</a></li> <li><a href="#how-to-build-a-pivot-table-report">How to Build a Pivot Table Report</a></li> <li><a href="#pivot-table-keyboard-shortcuts-in-excel">Pivot Table Keyboard Shortcuts in Excel</a></li> <li><a href="#how-to-add-filter-area-in-excel-1">How to Add Filter Area in Excel</a></li> <li><a href="#how-to-sort-a-pivot-table">How to Sort a Pivot Table</a></li> <li><a href="#how-to-copy-a-pivot-table">How to Copy a Pivot Table </a></li> <li><a href="#how-to-delete-a-pivot-table">How to Delete a Pivot Table</a></li> <li><a href="#tips-tricks-for-excel-pivot-tables">Tips & Tricks For Excel Pivot Tables</a></li> </ul> </div> <h2 id="what-is-a-pivot-table-in-excel"><span>What is a Pivot Table in Excel?</span></h2> <p dir="ltr" style="text-align: justify;"><span>A </span><a href="https://www.geeksforgeeks.org/how-to-add-and-use-an-excel-pivot-table-calculated-field/" target="_blank" rel="noopener"><span>Pivot table</span></a><span> is a summary of your data package. The word ‘</span><b><strong>Pivot</strong></b><span>‘ in the Pivot table means to rotate the data in Excel to view it from a different perspective. Creating a Pivot table doesn’t mean </span><b><strong>adding</strong></b><span>, </span><b><strong>subtracting</strong></b><span>, or </span><b><strong>changing </strong></b><span>the data, it simply means reorganizing it so you can easily work with useful information.</span></p> <blockquote> <h3><b><strong>Data Format Tips:</strong></b></h3> <ul> <li value="1"><span>Use clean, tabular data for the best report.</span></li> <li value="2"><span>Better to organize your data in columns, instead of rows.</span></li> <li value="3"><span>Ensure all columns have headers, with a single row of unique, non-blank labels for each column. Avoid double rows of headers or merged cells.</span></li> <li value="4"><span>Format your data as an Excel table (select anywhere in your data and then select Insert > Table from the ribbon).</span></li> <li value="5"><span>If you have complicated or nested data, use Power Query to transform it (for example, to unpivot your data) so it is organized in columns with a single header row</span></li> </ul> </blockquote> <h2 id="what-are-pivot-tables-used-for"><span>What are Pivot Tables used for?</span></h2> <p dir="ltr"><span>Pivot tables enable efficient data analysis, allowing users to visualize </span><b><strong>numerical data</strong></b><span>,</span><b><strong> summarize details</strong></b><span>, and </span><b><strong>identify trends quickly</strong></b><span>. With Excel and pivot tables, you can:</span></p> <ul> <li value="1"><span>Compare product sales totals</span></li> <li value="2"><span>Combine and remove duplicates</span></li> <li value="3"><span>Filter out irrelevant data</span></li> <li value="4"><span>Calculate totals or percentages</span></li> </ul> <h2 id="how-to-make-a-pivot-table-in-excel"><span>How to Make a Pivot Table in Excel</span></h2> <p dir="ltr" style="text-align: justify;"><b><strong>Creating a pivot table in Excel</strong></b><span> is easy and provides immense value. Here’s a simple guide:</span></p> <h3 id="step-1-open-ms-excel-and-select-the-data"><b><strong>Step 1: Open MS Excel and Select the Data</strong></b></h3> <p dir="ltr" style="text-align: start;"><span>Open your worksheet, then select the data range you wish to analyze. Ensure the data is organized with columns and headers.</span></p> <h3 id="step-2-go-to-the-insert-tab"><b><strong>Step 2: Go to the Insert tab</strong></b></h3> <p dir="ltr" style="text-align: start;"><span>Go to the “</span><b><strong>Insert</strong></b><span>” tab and click on “</span><b><strong>PivotTable</strong></b><span>.” Excel will prompt you to choose where the pivot table will appear.</span></p> <h3 id="step-3-in-the-tables-group-click-on-the-pivot-table-tool"><b><strong>Step 3: In the Tables group, click on the Pivot table tool</strong></b></h3> <img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113181650079758/In-the-Tables-group-click-on-the-Pivot-table-tool.webp" alt="Create a Pivot Table in Excel" width="556" height="439" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113181650079758/In-the-Tables-group-click-on-the-Pivot-table-tool.webp 556w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181650079758/In-the-Tables-group-click-on-the-Pivot-table-tool-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181650079758/In-the-Tables-group-click-on-the-Pivot-table-tool-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181650079758/In-the-Tables-group-click-on-the-Pivot-table-tool-300.webp 300w" loading="lazy"> <p dir="ltr"></p> <h3 id="step-5-set-up-your-pivot-table"><b><strong>Step 5: Set Up Your Pivot Table</strong></b></h3> <p dir="ltr" style="text-align: start;"><span>Excel will create an empty pivot sheet in Excel. Use the right-side panel to drag fields (column headers) into rows, columns, and values.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113181737065106/Set-Up-Your-Pivot-Table.webp" alt="Create a Pivot Table in Excel" width="900" height="552" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113181737065106/Set-Up-Your-Pivot-Table.webp 900w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181737065106/Set-Up-Your-Pivot-Table-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181737065106/Set-Up-Your-Pivot-Table-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181737065106/Set-Up-Your-Pivot-Table-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181737065106/Set-Up-Your-Pivot-Table-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181737065106/Set-Up-Your-Pivot-Table-768.webp 768w" loading="lazy"><p class="wp-caption-text">Set Up Your Pivot Table</p></div> <h2 id="how-to-create-pivot-table-columns-area-in-excel"><span>How to Create Pivot Table Columns Area in Excel</span></h2> <p dir="ltr"><span>Creating Pivot Table using the Column Area in Excel </span></p> <h3 id="step-1-use-discount-band"><span>Step 1: Use Discount Band </span></h3> <p dir="ltr" style="text-align: justify;"><span>The data in the pivot table gets grouped by(</span><b><strong>Column-Wise)</strong></b><span> by the</span><b><strong> Field Names</strong></b><span> dragged to Columns Area. As here, row-wise, our data is grouped by </span><b><strong>Countries </strong></b><span>and column-wise, it is grouped by</span><b><strong> Discount Band.</strong></b><span> </span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625122102/Screenshot20210516at102830PMmin.webp" alt="Create a Pivot Table in Excel" width="395" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625122102/Screenshot20210516at102830PMmin.webp 395w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122102/Screenshot20210516at102830PMmin-100.webp 44w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122102/Screenshot20210516at102830PMmin-200.webp 88w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122102/Screenshot20210516at102830PMmin-300.webp 132w" loading="lazy"><p class="wp-caption-text">Use Discount band</p></div> <h3 id="step-2-fields-dragged-to-columns"><span>Step 2: Fields Dragged to Columns</span></h3> <p dir="ltr"><span>The Fields are dragged to Columns in the below image.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625122138/Screenshot20210516at102814PMmin.webp" alt="Create a Pivot Table in Excel" width="900" height="299" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625122138/Screenshot20210516at102814PMmin.webp 900w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122138/Screenshot20210516at102814PMmin-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122138/Screenshot20210516at102814PMmin-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122138/Screenshot20210516at102814PMmin-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122138/Screenshot20210516at102814PMmin-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122138/Screenshot20210516at102814PMmin-768.webp 768w" loading="lazy"><p class="wp-caption-text">Fields Dragged to Columns</p></div> <p dir="ltr"><span>This area can accommodate many Fields. </span></p> <h2 id="how-to-add-filter-area-in-excel"><span>How to Create a Pivot Table with Multiple Columns</span></h2> <p dir="ltr"><span>After the basic construction of Pivot table, let’s go in depth and learn how to create a Pivot table with multiple columns:</span></p> <h3 id="step-1-select-the-data"><span>Step 1: Select the Data </span></h3> <p dir="ltr"><span>Select the data range you want to use in Excel pivot Table </span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241114113136281610/file.webp" alt=" Create a Pivot Table in Excel" width="688" height="596" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241114113136281610/file.webp 688w,https://media.geeksforgeeks.org/wp-content/uploads/20241114113136281610/file-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241114113136281610/file-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241114113136281610/file-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20241114113136281610/file-660.webp 660w" loading="lazy"><p class="wp-caption-text">Enter and select the data</p></div> <h3 id="step-2-go-to-the-insert-tab-and-click-on-pivot-table"><span>Step 2: Go to the Insert Tab and Click on Pivot table </span></h3> <p dir="ltr"><span>Go to the Insert Tab in the Excel ribbon and click on the “Pivot Table” button.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241114115502026954/image-.webp" alt=" Create a Pivot Table in Excel" width="662" height="720" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241114115502026954/image-.webp 662w,https://media.geeksforgeeks.org/wp-content/uploads/20241114115502026954/image--100.webp 92w,https://media.geeksforgeeks.org/wp-content/uploads/20241114115502026954/image--200.webp 184w,https://media.geeksforgeeks.org/wp-content/uploads/20241114115502026954/image--300.webp 276w,https://media.geeksforgeeks.org/wp-content/uploads/20241114115502026954/image--660.webp 607w" loading="lazy"><p class="wp-caption-text">Go to Insert Tab>> Select Pivot Table</p></div> <h3 id="step-3-add-fields-to-columns"><span>Step 3: Add Fields to Columns</span></h3> <p dir="ltr"><span>In the PivotTable Fields pane, drag the fields (column headers) you want to use for columns into the Columns area.</span></p> <p dir="ltr"><span>You can also drag fields to the Rows area to categorize data vertically.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241114120147267287/image-.webp" alt=" Create a Pivot Table in Excel" width="800" height="408" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241114120147267287/image-.webp 800w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120147267287/image--100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120147267287/image--200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120147267287/image--300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120147267287/image--660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120147267287/image--768.webp 768w" loading="lazy"><p class="wp-caption-text">Add Fields to Column by Dragging them</p></div> <h3 id="step-4-add-values"><span>Step 4: Add Values</span></h3> <p dir="ltr"><span>Drag fields you want to summarize or calculate (like sales figures or quantities) into the Values area. You can choose to sum, count, average, etc., based on your needs.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241114120404724802/image-.webp" alt=" Create a Pivot Table in Excel" width="800" height="381" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241114120404724802/image-.webp 800w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120404724802/image--100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120404724802/image--200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120404724802/image--300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120404724802/image--660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20241114120404724802/image--768.webp 768w" loading="lazy"><p class="wp-caption-text">Add Values to Fields</p></div> <h3 id="step-5-apply-filters"><span>Step 5: Apply Filters</span></h3> <p dir="ltr"><span>To further refine your data, drag fields into the Filters area to filter results as needed.</span></p> <h2 id="how-to-use-pivot-tables-in-excel-essential-features"><span>How to Use Pivot Tables in Excel: Essential Features</span></h2> <h3 id="step-1-sort-and-filter-data"><b><strong>Step 1: Sort and Filter Data</strong></b></h3> <ul> <li value="1"><span>Use the dropdown arrows in row or column headers to </span><b><strong>sort</strong></b><span> or </span><b><strong>filter</strong></b><span> data within the pivot table.</span></li> </ul> <h3 id="step-2-add-a-calculated-field"><b><strong>Step 2: Add a Calculated Field</strong></b></h3> <p dir="ltr"><span>To perform custom calculations within the pivot table:</span></p> <ul> <li value="1"><span>Click </span><b><strong>PivotTable Analyze > Fields, Items & Sets > Calculated Field</strong></b><span>.</span></li> <li value="2"><span>Enter the formula and name for your calculated field.</span></li> <li value="3"><span>Click </span><b><strong>OK</strong></b><span> to apply it.</span></li> </ul> <h3 id="step-3-update-a-pivot-table"><b><strong>Step 3: Update a Pivot Table</strong></b></h3> <ul> <li value="1"><span>Modify the original dataset as needed.</span></li> <li value="2"><span>Click </span><b><strong>PivotTable Analyze > Refresh</strong></b><span> to update the pivot table.</span></li> </ul> <h3 id="step-4-create-a-pivot-chart"><b><strong>Step 4: Create a Pivot Chart</strong></b></h3> <ul> <li value="1"><span>Select the pivot table.</span></li> <li value="2"><span>Go to </span><b><strong>Insert > PivotChart</strong></b><span> and choose a chart type.</span></li> <li value="3"><span>The chart will dynamically update as you modify the pivot table.</span></li> </ul> <h2 id="how-to-build-a-pivot-table-report"><span>How to Build a Pivot Table Report</span></h2> <p dir="ltr" style="text-align: justify;"><span>On the left side of the sheet, a new empty pivot table has been created where the summary would be shown. On the right side, we can see the </span><b><strong>FIELD NAME</strong></b><span> which are the headers of the columns of our data set. </span><b><strong>FIELD NAME</strong></b><span> is to be </span><b><strong>dragged </strong></b><span>to</span><b><strong> empty boxes</strong></b><span> i.e. </span><b><strong>Filters</strong></b><span>, </span><b><strong>Columns</strong></b><span>, </span><b><strong>Rows</strong></b><span>, and </span><b><strong>values </strong></b><span>to show their corresponding values in the Pivot Table.</span></p> <p dir="ltr" style="text-align: start;"><span>Let’s drag the </span><b><strong>FIELD NAME into the boxes</strong></b><span> and see their effects individually. </span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113181900515058/Drag.webp" alt="Create a Pivot Table in Excel" width="450" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113181900515058/Drag.webp 450w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181900515058/Drag-100.webp 50w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181900515058/Drag-200.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241113181900515058/Drag-300.webp 150w" loading="lazy"><p class="wp-caption-text">Drag the Fields Name</p></div> <h3 id="step-1-add-pivot-table-fields"><span>Step 1: Add Pivot Table Fields</span></h3> <p dir="ltr" style="text-align: justify;"><span>Values sum up all the entries in the</span><b><strong> FIELD NAME</strong></b><span> dragged in it. Here, as</span><b><strong> Sales are dragged here</strong></b><span>, our pivot table shows the</span><b><strong> sum of all the sales</strong></b><span> that took place. </span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113182009403292/Sum-of-Sales.webp" alt="Create a Pivot Table in Excel" width="450" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113182009403292/Sum-of-Sales.webp 450w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182009403292/Sum-of-Sales-100.webp 50w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182009403292/Sum-of-Sales-200.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182009403292/Sum-of-Sales-300.webp 150w" loading="lazy"><p class="wp-caption-text">Add Pivot Table Fields</p></div> <h3 id="step-2-sum-of-sales-appeared"><span>Step 2: Sum of Sales Appeared</span></h3> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113182105703679/Sum-of-Sales-Appeared.webp" alt="Create a Pivot Table in Excel" width="433" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113182105703679/Sum-of-Sales-Appeared.webp 433w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182105703679/Sum-of-Sales-Appeared-100.webp 48w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182105703679/Sum-of-Sales-Appeared-200.webp 96w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182105703679/Sum-of-Sales-Appeared-300.webp 144w" loading="lazy"><p class="wp-caption-text">Sum of Sales Appeared</p></div> <h3 id="step-3-add-more-fields"><span>Step 3: Add More Fields</span></h3> <p dir="ltr" style="text-align: start;"><span>We can add as many </span><b><strong>FIELD names</strong></b><span> as we require in Values.</span><b><strong> Individual sums</strong></b><span> would be shown then.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113182949431936/Add-More-Fields.webp" alt="Create a Pivot Table in Excel" width="463" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113182949431936/Add-More-Fields.webp 463w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182949431936/Add-More-Fields-100.webp 51w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182949431936/Add-More-Fields-200.webp 103w,https://media.geeksforgeeks.org/wp-content/uploads/20241113182949431936/Add-More-Fields-300.webp 154w" loading="lazy"><p class="wp-caption-text">Add More Fields</p></div> <h3 id="step-4-drag-to-get-sum"><span>Step 4: Drag to Get Sum</span></h3> <p dir="ltr" style="text-align: start;"><span>Dragging fields into values will give you the sum of values as a result.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113183029209075/Drag-to-Get-sum.webp" alt="Create a Pivot Table in Excel" width="900" height="433" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113183029209075/Drag-to-Get-sum.webp 900w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183029209075/Drag-to-Get-sum-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183029209075/Drag-to-Get-sum-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183029209075/Drag-to-Get-sum-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183029209075/Drag-to-Get-sum-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183029209075/Drag-to-Get-sum-768.webp 768w" loading="lazy"><p class="wp-caption-text">Drag to get sum</p></div> <h3 id="step-5-returned-to-total-count"><span>Step 5: Returned to Total Count</span></h3> <p dir="ltr" style="text-align: justify;"><span>If the entities in the column can’t be </span><b><strong>summed</strong></b><span>, it will give us the</span><b><strong> total count</strong></b><span> of the entries present in that column.  Here as </span><b><strong>Country </strong></b><span>and </span><b><strong>Product </strong></b><span>do not contain numeric values, it returned the</span><b><strong> total count</strong></b><span> of each column.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113183144819690/Returned-to-Total-Count.webp" alt="Create a Pivot Table in Excel" width="900" height="860" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113183144819690/Returned-to-Total-Count.webp 900w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183144819690/Returned-to-Total-Count-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183144819690/Returned-to-Total-Count-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183144819690/Returned-to-Total-Count-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183144819690/Returned-to-Total-Count-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183144819690/Returned-to-Total-Count-768.webp 768w" loading="lazy"><p class="wp-caption-text">Returned to Total Count</p></div> <h3 id="step-6-drag-fields-into-values"><span>Step 6: Drag Fields into Values</span></h3> <p dir="ltr" style="text-align: start;"><span>Dragging Fields into Values.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113183345582864/Drag-Fields-into-Values.webp" alt="Create a Pivot Table in Excel" width="567" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113183345582864/Drag-Fields-into-Values.webp 567w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183345582864/Drag-Fields-into-Values-100.webp 63w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183345582864/Drag-Fields-into-Values-200.webp 126w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183345582864/Drag-Fields-into-Values-300.webp 189w" loading="lazy"><p class="wp-caption-text">Drag Fields into Values</p></div> <h3 id="step-7-count-not-found"><span>Step 7: Count Not Found</span></h3> <p dir="ltr" style="text-align: start;"><span>In the below image, you can</span><b><strong> find the Count</strong></b><span> of the Values.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113183528267851/Count-Not-Found-768.webp" alt="Create a Pivot Table in Excel" width="768" height="685" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113183528267851/Count-Not-Found.webp 900w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183528267851/Count-Not-Found-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183528267851/Count-Not-Found-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183528267851/Count-Not-Found-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183528267851/Count-Not-Found-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183528267851/Count-Not-Found-768.webp 768w" loading="lazy"><p class="wp-caption-text">Count Not Found</p></div> <h3 id="step-8-data-gets-grouped"><span>Step 8: Data Gets Grouped</span></h3> <p dir="ltr" style="text-align: start;"><span>The data in the pivot table gets grouped</span><b><strong> (Row-Wise) by the Field Names</strong></b><span> dragged to the Rows Area. </span></p> <p dir="ltr" style="text-align: start;"><span>In this example, we have </span><b><strong>grouped the sales</strong></b><span> by the countries. </span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113183632356747/Data-Gets-Grouped.webp" alt="Create a Pivot Table in Excel" width="401" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113183632356747/Data-Gets-Grouped.webp 401w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183632356747/Data-Gets-Grouped-100.webp 45w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183632356747/Data-Gets-Grouped-200.webp 89w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183632356747/Data-Gets-Grouped-300.webp 134w" loading="lazy"><p class="wp-caption-text">Data Gets Grouped</p></div> <h3 id="step-9-fields-dragged-to-rows"><span>Step 9: Fields dragged to Rows</span></h3> <p dir="ltr" style="text-align: start;"><span>In the below image, the fields are </span><b><strong>dragged to Rows</strong></b><span>.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20241113183712762460/Fields-Dragged-to-Rows.webp" alt="Create a Pivot Table in Excel" width="900" height="728" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20241113183712762460/Fields-Dragged-to-Rows.webp 900w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183712762460/Fields-Dragged-to-Rows-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183712762460/Fields-Dragged-to-Rows-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183712762460/Fields-Dragged-to-Rows-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183712762460/Fields-Dragged-to-Rows-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20241113183712762460/Fields-Dragged-to-Rows-768.webp 768w" loading="lazy"><p class="wp-caption-text">Fields dragged to Rows</p></div> <p dir="ltr" style="text-align: start;"><span>We can drag as many Fields as we require in this region.</span></p> <h2 id="pivot-table-keyboard-shortcuts-in-excel"><span>Pivot Table Keyboard Shortcuts in Excel</span></h2> <table> <thead> <tr> <th><b><strong>Action</strong></b></th> <th><b><strong>Windows Shortcut</strong></b></th> <th><b><strong>Mac Shortcut</strong></b></th> </tr> </thead> <tbody> <tr> <td><span>Insert a Pivot Table</span></td> <td><code><span>Alt + N + V</span></code></td> <td><code><span>Command + Option + V</span></code></td> </tr> <tr> <td><span>Refresh a Pivot Table</span></td> <td><code><span>Alt + F5</span></code></td> <td><code><span>Command + Shift + R</span></code></td> </tr> <tr> <td><span>Open Value Field Settings</span></td> <td><code><span>Alt + D + F</span></code></td> <td><code><span>Control + Option + F</span></code></td> </tr> <tr> <td><span>Group Data in Pivot Table</span></td> <td><code><span>Alt + Shift + Right</span></code></td> <td><code><span>Command + Shift + G</span></code></td> </tr> </tbody> </table> <h2 id="how-to-add-filter-area-in-excel-1"><span>How to Add Filter Area in Excel</span></h2> <p dir="ltr" style="text-align: justify;"><span>The filter is an important feature in the pivot table. using which we can </span><b><strong>filter out</strong></b><span> the data based on the</span><b><strong> Field dragged</strong></b><span> into it. </span></p> <h3 id="step-1-filter-the-total-sales"><span>Step 1: Filter the Total Sales</span></h3> <p dir="ltr"><span>Here, we have</span><b><strong> filtered the total sales</strong></b><span> based on one </span><b><strong>particular product</strong></b><span> that is only that product is considered while </span><b><strong>calculating the sales</strong></b><span>. </span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625122222/Screenshot20210516at104940PMmin.webp" alt="Create a Pivot Table in Excel" width="395" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625122222/Screenshot20210516at104940PMmin.webp 395w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122222/Screenshot20210516at104940PMmin-100.webp 44w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122222/Screenshot20210516at104940PMmin-200.webp 88w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122222/Screenshot20210516at104940PMmin-300.webp 132w" loading="lazy"><p class="wp-caption-text">Filter the Total Sales</p></div> <h3 id="step-2-apply-features"><span>Step 2: Apply Features </span></h3> <p dir="ltr"><span>You can also apply many features to the </span><b><strong>Product fields</strong></b><span> as shown below.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625122303/Screenshot20210516at104957PMmin.webp" alt=" Create a Pivot Table in Excel" width="823" height="900" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625122303/Screenshot20210516at104957PMmin.webp 823w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122303/Screenshot20210516at104957PMmin-100.webp 91w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122303/Screenshot20210516at104957PMmin-200.webp 183w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122303/Screenshot20210516at104957PMmin-300.webp 274w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122303/Screenshot20210516at104957PMmin-660.webp 604w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122303/Screenshot20210516at104957PMmin-768.webp 702w" loading="lazy"><p class="wp-caption-text">Apply features</p></div> <h3 id="step-3-final-output"><span>Step 3: Final Output </span></h3> <p dir="ltr" style="text-align: justify;"><span>Below is the final output of the above steps. In this way, using pivot tables, a summary of the data is achieved in the form of a matrix. There are many other tools and features of the Pivot Tables which can be explored. </span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625122333/Screenshot20210516at105014PMmin.webp" alt=" Create a Pivot Table in Excel" width="900" height="254" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625122333/Screenshot20210516at105014PMmin.webp 900w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122333/Screenshot20210516at105014PMmin-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122333/Screenshot20210516at105014PMmin-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122333/Screenshot20210516at105014PMmin-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122333/Screenshot20210516at105014PMmin-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122333/Screenshot20210516at105014PMmin-768.webp 768w" loading="lazy"><p class="wp-caption-text">Final Output</p></div> <h2 id="how-to-sort-a-pivot-table"><span>How to Sort a Pivot Table</span></h2> <p dir="ltr"><span>Here are the steps to sort a Pivot Table:</span></p> <h3 id="step-1-select-the-column-or-row"><b><strong>Step 1</strong></b><span>: Select the column or row </span></h3> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625114836/Screenshot21-ezgifcom-png-to-webp-converter.webp" alt=" Create a Pivot Table in Excel" width="999" height="576" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625114836/Screenshot21-ezgifcom-png-to-webp-converter.webp 999w,https://media.geeksforgeeks.org/wp-content/uploads/20240625114836/Screenshot21-ezgifcom-png-to-webp-converter-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20240625114836/Screenshot21-ezgifcom-png-to-webp-converter-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20240625114836/Screenshot21-ezgifcom-png-to-webp-converter-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20240625114836/Screenshot21-ezgifcom-png-to-webp-converter-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20240625114836/Screenshot21-ezgifcom-png-to-webp-converter-768.webp 768w" loading="lazy"><p class="wp-caption-text">Select a Column or Row</p></div> <h3 id="step-2-sort-in-ascending-or-descending-order"><b><strong>Step 2</strong></b><span>: Sort in ascending or descending order.</span></h3> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625115540/Screenshot23-ezgifcom-png-to-webp-converter.webp" alt=" Create a Pivot Table in Excel" width="1025" height="576" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625115540/Screenshot23-ezgifcom-png-to-webp-converter.webp 1025w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115540/Screenshot23-ezgifcom-png-to-webp-converter-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115540/Screenshot23-ezgifcom-png-to-webp-converter-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115540/Screenshot23-ezgifcom-png-to-webp-converter-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115540/Screenshot23-ezgifcom-png-to-webp-converter-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115540/Screenshot23-ezgifcom-png-to-webp-converter-768.webp 768w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115540/Screenshot23-ezgifcom-png-to-webp-converter-1024.webp 1024w" loading="lazy"><p class="wp-caption-text">Click on Sort button to Sort Pivot Table</p></div> <h2 id="how-to-copy-a-pivot-table"><span>How to Copy a Pivot Table </span></h2> <p dir="ltr"><span>After learning how to build pivot table in excel, now let’s learn how to copy a excel build pivot table:</span></p> <h3 id="step-1-select-the-entire-pivot-table"><span>Step 1: Select the Entire Pivot Table</span></h3> <p dir="ltr"><span>Press</span><b><strong> Ctrl + A</strong></b><span> to select the entire Pivot Table.</span></p> <h3 id="step-2-copy-the-selected-pivot-table"><span>Step 2: Copy the Selected Pivot Table</span></h3> <ul> <li value="1"><span>On Windows ,Press</span><b><strong> Ctrl + C</strong></b><span> or</span><b><strong> right-click </strong></b><span>and </span><b><strong>select Copy</strong></b><span>. </span></li> <li value="2"><span>On Mac, Press </span><b><strong>Cmd + C</strong></b><span> or </span><b><strong>right-click</strong></b><span> and </span><b><strong>select Copy</strong></b><span>.</span></li> </ul> <h3 id="step-3-paste-the-pivot-table"><span>Step 3: Paste the Pivot Table</span></h3> <ul> <li value="1"><span>Navigate to the location where you want to paste the Pivot Table.</span></li> <li value="2"><span>On Windows , Press </span><b><strong>Ctrl + V</strong></b><span> or right-click and select Paste.</span></li> <li value="3"><span>On Mac, Press </span><b><strong>Cmd + V</strong></b><span> or right-click and select Paste.</span></li> </ul> <h2 id="how-to-delete-a-pivot-table"><span>How to Delete a Pivot Table</span></h2> <p dir="ltr" style="text-align: justify;"><span>Once you’ve created a Pivot Table, you may want to delete it at some point. Follow these steps to remove a Pivot Table:</span></p> <h3 id="step-1-select-a-pivot-table"><b><strong>Step 1: Select the Pivot Table</strong></b></h3> <p dir="ltr"><span>Click anywhere inside the Pivot Table to activate it.</span></p> <h3 id="step-2-highlight-the-entire-pivot-table"><b><strong>Step 2: Highlight the Entire Pivot Table</strong></b></h3> <p dir="ltr"><span>Place your cursor on the </span><b><strong>Pivot Table</strong></b><span>, and you’ll see a four-way arrow in the corner. Use this to select the entire table. Alternatively, click and drag to manually highlight the table.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625122619/Screenshot21-ezgifcom-png-to-webp-converter.webp" alt=" Create a Pivot Table in Excel" width="999" height="576" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625122619/Screenshot21-ezgifcom-png-to-webp-converter.webp 999w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122619/Screenshot21-ezgifcom-png-to-webp-converter-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122619/Screenshot21-ezgifcom-png-to-webp-converter-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122619/Screenshot21-ezgifcom-png-to-webp-converter-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122619/Screenshot21-ezgifcom-png-to-webp-converter-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20240625122619/Screenshot21-ezgifcom-png-to-webp-converter-768.webp 768w" loading="lazy"><p class="wp-caption-text">Select the Pivot Table</p></div> <h3 id="step-2-press-the-delete-key"><b><strong>Step 3: Press the Delete Key</strong></b></h3> <p dir="ltr"><span>Once the entire </span><b><strong>Pivot Table</strong></b><span> is selected, press the </span><b><strong>Delete key</strong></b><span> on your keyboard to remove it.</span></p> <div style="width: 810px" class="wp-caption alignnone"><img src="https://media.geeksforgeeks.org/wp-content/uploads/20240625115024/Screenshot22-ezgifcom-png-to-webp-converter-(1).webp" alt=" Create a Pivot Table in Excel" width="1025" height="576" srcset="https://media.geeksforgeeks.org/wp-content/uploads/20240625115024/Screenshot22-ezgifcom-png-to-webp-converter-(1).webp 1025w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115024/Screenshot22-ezgifcom-png-to-webp-converter-(1)-100.webp 100w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115024/Screenshot22-ezgifcom-png-to-webp-converter-(1)-200.webp 200w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115024/Screenshot22-ezgifcom-png-to-webp-converter-(1)-300.webp 300w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115024/Screenshot22-ezgifcom-png-to-webp-converter-(1)-660.webp 660w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115024/Screenshot22-ezgifcom-png-to-webp-converter-(1)-768.webp 768w,https://media.geeksforgeeks.org/wp-content/uploads/20240625115024/Screenshot22-ezgifcom-png-to-webp-converter-(1)-1024.webp 1024w" loading="lazy"><p class="wp-caption-text">Click on Delete button</p></div> <h3 id="step-3-table-deleted"><span>Step 4: Clear Associated Data (Optional)</span></h3> <p dir="ltr"><span>If your Pivot Table data is connected to a data source, clear or modify the source as needed to ensure no residual links.</span></p> <h3 id="step-5-remove-pivot-cache-optional"><span>Step 5: Remove Pivot Cache (Optional)</span></h3> <p dir="ltr"><span>To completely remove all related data, clear the </span><b><strong>Pivot Cache by refreshing the workbook </strong></b><span>or deleting unused data ranges.</span></p> <p dir="ltr" style="text-align: justify;"><span>Your </span><b><strong>Pivot Table</strong></b><span> will now be deleted, and the spreadsheet will return to its original format without the summary table.</span></p> <h2 id="tips-tricks-for-excel-pivot-tables"><span>Tips & Tricks For Excel Pivot Tables</span></h2> <ul> <li value="1"><span>Let Excel suggest Pivot Table layouts based on your data. Go to Insert > Recommended PivotTables.</span></li> <li value="2"><span>Group dates by month, quarter, or year for better trend analysis.</span></li> <li value="3"><span>Group items manually to create custom categories.</span></li> <li value="4"><span>Add slicers for a visual and interactive way to filter your Pivot Table data.</span></li> <li value="5"><span>Use multiple slicers for more granular control over your data views.</span></li> <li value="6"><span>Add calculated fields to perform custom calculations within your Pivot Table without altering the source data.</span></li> <li value="7"><span>Use complex formulas for sophisticated data analysis.</span></li> </ul> <blockquote> <h3><span>Also Read: </span></h3> <ul> <li value="1"><a href="https://www.geeksforgeeks.org/group-pivot-table-data-in-excel/" target="_blank" rel="noopener"><span>How to Group or Ungroup Data in a PivotTable</span></a></li> <li value="2"><a href="https://www.geeksforgeeks.org/how-to-add-and-use-an-excel-pivot-table-calculated-field/" target="_blank" rel="noopener"><span>How to Add and Use an Excel Pivot Table Calculated Field?</span></a></li> <li value="3"><a href="https://" rel=""><span>How to Create Excel Pivot Table Calculated Field with Examples</span></a></li> </ul> </blockquote> <h2 id="conclusion"><span>Conclusion</span></h2> <p dir="ltr" style="text-align: justify;"><span>Mastering pivot tables in Excel will revolutionize your data analysis capabilities. With Excel pivot tables, you can quickly identify patterns, trends, and anomalies in your datasets. Whether you’re new to Excel and pivot tables or an experienced user, understanding how to prepare a pivot table in excel is essential for efficient data analysis. Make the most of your data by utilizing this powerful feature across both Excel and Google Sheets.</span></p> <h2 id="pivot-table-faqs"><b><strong>How to Create a Pivot Table in Excel – FAQs </strong></b></h2> <h3 id="what-is-a-pivot-table-in-excel-1"><span>What is a Pivot Table in Excel?</span></h3> <blockquote> <p dir="ltr"><span>A Pivot Table in Excel is a powerful tool that helps you summarize, analyze, and organize large data sets. By dragging and dropping fields, you can quickly view data in different ways, making it easier to generate insights and reports</span></p> </blockquote> <h3 id="how-do-i-create-a-pivottable-in-excel"><span>How do I make a Pivot Table in Excel?</span></h3> <blockquote> <p dir="ltr"><span>To make a Pivot Table in Excel, select your data, go to Insert > PivotTable, choose the location, and then drag fields to the Rows, Columns, Values, and Filters sections to create your custom table</span></p> </blockquote> <h3 id="how-do-i-create-a-pivottable-with-rows-and-columns"><span>How do I create a PivotTable with rows and columns?</span></h3> <blockquote> <p dir="ltr"><span>To create Pivot Table with rows and columns follow the steps given below:</span></p> <ul> <li value="1"><span>Select Your Data</span></li> <li value="2"><span>Go to the Insert tab</span></li> <li value="3"><span>Drag the rows </span></li> <li value="4"><span>Drag the Columns</span></li> </ul> </blockquote> <h3 id="what-is-a-pivottable-in-excel-used-for"><span>What is a PivotTable in Excel used for?</span></h3> <blockquote> <p dir="ltr"><span>A PivotTable in Excel is used for:</span></p> <ul> <li value="1"><span>Summarizing Data</span></li> <li value="2"><span>Analyzing Data</span></li> <li value="3"><span>Data Exploration</span></li> <li value="4"><span>Creating Reports</span></li> <li value="5"><span>Filtering Data</span></li> </ul> </blockquote> <h3 id="what-is-a-pivot-table-xls-file"><span>What is a Pivot Table XLS file?</span></h3> <blockquote> <p dir="ltr"><span>An Excel Pivot Table saved in .xls format refers to an older version of Excel files. You can create and work with Pivot Tables in both .xls and newer .xlsx formats.</span></p> </blockquote> <h3 id="how-do-i-create-a-pivot-chart-from-excel-data"><span>How do I create a pivot chart from Excel data?</span></h3> <blockquote> <p dir="ltr"><span>Here are the steps to create a pivot table from the Excel data:</span></p> <ul> <li value="1"><span>Go to the Insert tab</span></li> <li value="2"><span>Click on PivotTable</span></li> <li value="3"><span>Customize the PivotChart</span></li> </ul> </blockquote> <h3 id="can-i-use-pivot-tables-in-excel-to-create-summaries"><span>Can I use Pivot Tables in Excel to create summaries?</span></h3> <blockquote> <p dir="ltr"><span>Yes, doing Pivot Tables in Excel allows you to create summaries, aggregate data, and easily view key metric</span></p> </blockquote> <h3 id="how-do-i-use-pivot-tables-in-excel-for-data-analysis"><span>How do I use Pivot Tables in Excel for data analysis?</span></h3> <blockquote> <p dir="ltr"><span>To analyze data with Pivot Tables, you can group, filter, and sort data, perform calculations, and create custom views. Excel with Pivot Tables simplifies complex data analysis tasks.</span></p> </blockquote> <h3 id="what-is-pivot-table-in-excel-formula"><span>Can I create a Pivot Table from another Pivot Table?</span></h3> <blockquote> <p dir="ltr"><span>Yes, you can create an Excel Pivot Table from a Pivot Table. Simply select the existing Pivot Table, then copy and paste it to a new location, and modify it as needed.</span></p> </blockquote> <div hideAd="MID"></div><br/><div id="AP_G4GR_6"></div> <div class='article_bottom_text'></div><br> </div> <div class="article_tags_div"> <div class="t-head"><span style="line-height: 30px;">Article Tags : </span></div> <ul class="article_tag_ul"> <li class="article_tag_li "><a href="https://www.geeksforgeeks.org/category/microsoft-office/excel/?ref=article_category">Excel</a></li> <li class="article_tag_li "><a href="https://www.geeksforgeeks.org/category/microsoft-office/?ref=article_category">Microsoft Office</a></li> <li class="article_tag_li "><a href="https://www.geeksforgeeks.org/category/news/?ref=article_category">News</a></li> <li class="article_tag_li "><a href="https://www.geeksforgeeks.org/tag/excel/?ref=article_tag">excel</a></li> <li class="article_tag_li hidden_cat_tag"><a href="https://www.geeksforgeeks.org/tag/excel-how-to/?ref=article_tag">Excel-How To</a></li> <li class="article_tag_li hidden_cat_tag"><a href="https://www.geeksforgeeks.org/tag/msexcel/?ref=article_tag">MSExcel</a></li> <li class="article_tag_li hidden_cat_tag"><a href="https://www.geeksforgeeks.org/tag/picked/?ref=article_tag">Picked</a></li> </ul> <button id="showMoreCatTags" class="">+3 More</button> </div> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B5EAEA; ">R</p> <i class="author_badge proficient"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/riyaaggarwaldtu/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">riya aggarwal</a> </div> <div class="author_follow follow_icon" value= "riyaaggarwaldtu" onclick=followUnfollow(event);><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> <div class="article_action_btns"> <div class="article_bottom_suggestion " data-title="Follow"> <a href='https://news.google.com/publications/CAAqBwgKMLTrzwsw44bnAw?hl=en-IN&gl=IN&ceid=IN%3Aen' target="_blank"> <img class="gfg-icon_Gnews no-zoom-in-cursor" src=https://media.geeksforgeeks.org/auth-dashboard-uploads/Google-news.svg loading="lazy" alt="News"></img> </a> </div> <i class="author_icon author_improve_icon" onclick= improveArticleCall(); ></i> <span class="gfg_tooltip">Improve</span> <div pid="606965" class="article--viewer_like tooltip tooltipBottom" data-title="Like Article">  <button id="likeButton" aria-label="like article" data-gfg-action="like-article" data-bookmark-value="0" data-liked="false" style="color: #5B5A5A !important; display: flex; align-items: center; background-color: unset; margin: 0px !important; padding: 5px 0px;"> <i class="author_icon author_like_icon"></i> <figure id="likeCount" style="margin-left: 3px; margin-top: 4px; color: var(--like-count-color); font-size: 14px; font-weight: 600;" class="favoriteText"></figure> </button> </div> </div> </div>  </div> </div> <div class="article_tabs"> <div class="article_tabs_wrapper" data-gfg-action="loadComments"> <div id="discuss_tab" class="article_tab"> <i class="gfg_icon gfg_discuss_icon"></i> <span>Discuss </span> </div> <div><i class="gfg-icon gfg-icon_arrow-down article_tab_icon"></i></div> </div> </div> <div id="tabs_panel_wrapper"> <div class="onopen-discussion-panel"> <div class="discussion-tab"> <div class="discussion_heading"> <div></div> <i class="gfg-icon close-tab-icon"></i> </div> <div class="discussion_content"> <div style="height:100%"> <div style="height:100%" id="comment-system"></div> </div> </div> </div> </div> <div id="practice_panel"></div> <div id="jobs_panel"></div> <div id="courses_panel" class="courses_nav_tab_content"></div> </div> </div>  <div id="article_section_2" class="article_section"> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#FFEEB3; ">N</p> <i class="author_badge proficient"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/nandinigujral/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Nandini Gujral</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="nandinigujral" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/how-to-create-pivot-chart-from-pivot-table-in-excel-using-java/" class="similar_article_anchor"> <div class="article_title"> <h1>How to Create Pivot Chart from Pivot Table in Excel using Java?</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <div class="similar_article_content">A Pivot Chart is used to analyze data of a table with very little effort (and no formulas) and it gives you the big picture of your raw data. It allows you to analyze data using various types of graphs and layouts. It is considered to be the best chart during a business presentation that involves huge data. To add a pivot chart to an Excel worksheet, you need to use the "WorksheetChartsCollection.add" method. Before Creating a Pivot Chart, one first needs to go through how to Create Pivot Table in Excel using Java. Now let's discuss the steps to create a pivot chart in an Excel file in Java using Free Spire.XLS for Java API. How to Create a Pivot Table in Excel using JavaStep 1: Load the Excel fileWorkbook workbook = new Workbook() String workbookName = "Geeks_For_Geeks.xlsx"; workbook.loadFromFile(workbookName); Step 2: Get the first worksheetWorksheet sheet = workbook.getWorksheets().get(0); Step 3: Get the first pivot table in the worksheetIPivotTable pivotTable = sheet.getPivotTables().get(0); Step 4: Add a clustered column chart based on the pivot table to the second worksheetChart chart = workbook.getWorksheets().get(1).getCharts().add(ExcelChartType.ColumnClustered, pivotTa</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B5EAEA; ">R</p> <i class="author_badge proficient"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/mishraridmrn/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Rishabh Mishra</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="mishraridmrn" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/excel-pivot-table-shortcut-keys/" class="similar_article_anchor"> <div class="article_title"> <h1>Top Excel Pivot Table Shortcuts Keys: Complete List</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <img class="similar_article_img" loading="lazy" alt="article_img" src="https://media.geeksforgeeks.org/wp-content/uploads/20241001171514/Top-Excel-Pivot-Table-Keyboard-Shortcuts.webp"></img> <div class="similar_article_content">Mastering Pivot Tables in Excel can significantly enhance your data analysis and reporting capabilities. To make the process even faster and more efficient, learning the top Excel Pivot Table shortcut keys is a must. These shortcuts save time, streamline tasks, and allow you to quickly create, modify, and analyze your data using Pivot Tables. In this guide, we’ll cover the essential shortcut keys that every Excel user should know to maximize productivity and work smarter with Pivot Tables. Excel Pivot Table Shortcuts - A Comprehensive GuideUsing keyboard shortcuts not only makes working with pivot tables in Excel faster but also reduces the likelihood of errors. Below are some commonly used Keyboard shortcuts for pivot tables that will save you time across all Excel versions. Shortcut Keys for Pivot Table Operations in ExcelActionShortcut (Windows)Shortcut (Mac)Create a PivotTable from selected dataAlt + N + V + T + EnterN/ACreate a pivot table on a new worksheetF11Fn+F11Create a pivot table on an existing worksheetAlt + F1N/AGroup pivot table itemsAlt + Shift + →⌘ + ⇧ + KUngroup pivot table itemsAlt + Shift + ←⌘ + ⇧ + JHide pivot table itemCtrl + -N/AOpen pivot table wizardAlt + D</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B5EAEA; ">I</p> <i class="author_badge proficient"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/ishita28rai/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Ishita Rai</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="ishita28rai" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/how-to-create-calculated-columns-in-power-pivot-in-excel/" class="similar_article_anchor"> <div class="article_title"> <h1>How to Create Calculated Columns in Power Pivot in Excel: A Complete Guide</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <img class="similar_article_img" loading="lazy" alt="article_img" src="https://media.geeksforgeeks.org/wp-content/uploads/20231009005025/Create-Calculated-Columns-in-Power-Pivot-in-Excel-copy.webp"></img> <div class="similar_article_content">Power Pivot in Excel is a powerful data modelling tool that enables advanced calculations on large datasets. One of its standout features is calculated columns, which allow users to derive new data by applying custom formulas to existing columns. In this article, we’ll cover what calculated columns are, how to create them in Power Pivot, and their advantages and limitations. Table of ContentWhat are Calculated Columns in ExcelCreate Calculated Columns in Power Pivot in ExcelHow to Create Calculated Columns in Power Pivot in Excel ExamplesAdvantages of Calculated Columns in Power PivotLimitations of Calculated Columns in Power PivotUnderstanding Calculated Columns in Excel Power PivotCalculated columns are dynamic columns in Power Pivot that allow users to create new data by applying formulas or expressions to existing data. Unlike calculated fields, which are computed on-the-fly based on the context, calculated columns compute their values during data refresh. This makes them suitable for pre-computed data scenarios, such as sorting, filtering, complex calculations, or creating hierarchies. How to Create Calculated Columns in Power Pivot in ExcelFollow these steps to create calcula</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B0DAFF; ">A</p> <i class="author_badge proficient"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/sk123online/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Asha Senthilkumar</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="sk123online" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/excel-pivot-table-calculated-field/" class="similar_article_anchor"> <div class="article_title"> <h1>How to Create Excel Pivot Table Calculated Field with Examples</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <img class="similar_article_img" loading="lazy" alt="article_img" src="https://media.geeksforgeeks.org/wp-content/uploads/20211123073148/pivotCalcFld001.png"></img> <div class="similar_article_content">You can add calculated fields to a pivot table using your own unique algorithms that add up to other pivot fields. A calculated field has some restrictions, but it gives the pivot tables in your Excel worksheet a strong tool. What is a Pivot Table Calculated Field in Excel“Pivot Table calculated field” is an option to include more data or calculations in the pivot table. Often, we need to add our own custom calculations that can refer to other fields in the data set for our reports. In the below examples, we create a sales report by-product with an additional column "Sales Differences" [2020_Sales - 2019_Sales]. The calculated field "Sales Differences" calculation refers to other fields in the dataset [subtract 2019_Sales from 2020_Sales]. Example: We have a data set in four columns “Product”, ”Customer”, “2019_Sales” and “2020_Sales” as below How to Create a Pivot Table in ExcelFollow the below steps to create a pivot table Step 1: Select Insert >> Pivot >> From Table/Range (Img1) to pop-up "Pivot Table from table or range" dialogue box (Img 2). Step 2: Enter your data set range in "Table/Range" input, choose New worksheet, and Click “OK Step 3: Above step, add a n</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#FFEEB3; ">N</p> <i class="author_badge proficient"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/nandinigujral/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Nandini Gujral</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="nandinigujral" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/how-to-create-pivot-table-in-excel-using-java/" class="similar_article_anchor"> <div class="article_title"> <h1>How to Create Pivot Table in Excel using Java?</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <div class="similar_article_content">A pivot table is needed to quickly analyze data of a table with very little effort (and no formulas) and sometimes not everyone has time to look at the data in the table and see what’s going on and use it to build good-looking reports for large data sets in an Excel worksheet. Let's discuss a step-by-step proper explanation to create a pivot table in an Excel file in Java using Free Spire.XLS for Java API. Requirements to Create Pivot Table in Excel using JavaFirstly, we need to add necessary dependencies to the Maven project including the Free Spire.XLS project before starting to write the code. How to Install Spire.XLS for JavaBy adding the following code to your project's pom.xml file, you can quickly import the JAR file into your program if you use Maven. C/C++ Code <repositories> <repository> <id>com.e-iceblue</id> <name>e-iceblue</name> <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url> </repository> </repositories> <dependencies> <dependency> <groupId>javax.xml.bind</groupId> <artifactId>jaxb-api</artifactId> <version>2.3.1</version> </dependency></div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B5EAEA; ">I</p> <i class="author_badge contributor"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/ishikalohia4/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Ishika</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="ishikalohia4" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/how-to-remove-pivot-table-but-keep-data-in-excel/" class="similar_article_anchor"> <div class="article_title"> <h1>How to Remove Pivot Table But Keep Data in Excel?</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <div class="similar_article_content">In this article, we will look into how to remove the Pivot Table but want to keep the data intact in Excel. To do so follow the below steps: Step 1: Select the Pivot table. To select the table, go to Analyze tabSelect the menu and choose the Entire Pivot Table. Step 2: Now copy the entire Pivot table data by Ctrl+C. Step 3: Select a cell in the worksheet where you want to paste the data. Step 4: Click Ctrl+V, to paste the data. Step 5: Click on the Ctrl dropdown. Choose the value(v) option from Paste options. Step 6: Now, again select the entire Pivot table. Step 7: Delete it using the Delete key on the keyboard. Step 8: Or you can also choose the Clear All command from the Home tab => Editing section => Clear dropdown. You will find your pivot table will be completely deleted from the worksheet. Thus, we can delete the pivot table without losing pivot table data.</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B5EAEA; ">R</p> <i class="author_badge contributor"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/rutujadhore60/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Rutuja Kishor Dhore</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="rutujadhore60" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/how-to-delete-a-pivot-table-in-excel/" class="similar_article_anchor"> <div class="article_title"> <h1>How to Delete a Pivot Table in Excel?</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <img class="similar_article_img" loading="lazy" alt="article_img" src="https://media.geeksforgeeks.org/wp-content/uploads/20210430205803/1step2.png"></img> <div class="similar_article_content">A pivot table is a tool in Excel that allows you to quickly summarize data in the spreadsheet. When it comes to deleting a Pivot Table, there are a few different ways you can do this. The method you choose will depend on how you want to delete the Pivot Table. 1.Delete the Pivot Table and the Resulting Data. Steps to delete the Pivot table and the Resulting Data- Select any cell in the Pivot TableSelect the ‘Analyze’ tab. Click on the ‘Select’ option in the Actions group.Choose Entire Pivot tableHit the Delete key.2.Delete the Pivot Table but Keep the Resulting Data. If we want to delete the entire pivot table but retain the resulting data, the procedure is more or less the same Steps to delete the Pivot table but Keep the Resulting Data: Select any cell in the Pivot TableChoose the ‘Analyze’ tab in the ribbon. In the Actions group, choose the ‘Select’ option. Select the Entire Pivot table. Right-click on any cell of the selected Pivot Table.Click on Copy. This will copy the data of the entire Pivot Table. Click the Home tab. Click on the Paste option. In the Paste Values section, click on the first icon. The above steps would delete the Pivot Table but still keep the resulting dat</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B5EAEA; ">I</p> <i class="author_badge contributor"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/ishikalohia4/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Ishika</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="ishikalohia4" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/refresh-pivot-table-data-in-excel/" class="similar_article_anchor"> <div class="article_title"> <h1>Refresh Pivot Table Data in Excel</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <div class="similar_article_content">In the Pivot data table, data can be grouped based on Dates, Numbers, and Text values. In the case of dates, we can group dates by months or year, months by years, etc. At any time, data for the PivotTables in your workbook can be refreshed using the Refresh button. You can also refresh data from a source table in the same or a different workbook. By default, PivotTables are not refreshed automatically when data in the source table is changed, but you can set your workbook to refresh its PivotTable data automatically when you open it. Steps to Manually refresh: Follow the below steps to manually refresh PiviotTable Data in Excel: Click on the PivotTable to show the PivotTable Tools on the ribbon. In PivotTable Tools, Click Analyze > Refresh, or press Alt+F5. Click the Refresh button on the Analyze tab (Click Analyze > Refresh All, to update all PivotTables in your workbook at once). If refreshing takes longer, click Analyze > Refresh arrow > Refresh Status to check the refresh status.To stop refreshing, click Cancel Refresh.Steps to prevent column width and cell formatting while refreshing: Follow the below steps to prevent column with and cell formatting while refreshi</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#E5F9DB; ">G</p> <i class="author_badge proficient"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/gautamgoel962/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Gautam goel</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="gautamgoel962" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/how-to-remove-old-row-and-column-items-from-the-pivot-table-in-excel/" class="similar_article_anchor"> <div class="article_title"> <h1>How to Remove Old Row and Column Items from the Pivot Table in Excel?</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <img class="similar_article_img" loading="lazy" alt="article_img" src="https://media.geeksforgeeks.org/wp-content/uploads/20220302185802/UntitledDiagram1-660x266.jpg"></img> <div class="similar_article_content">Pivot table is one of the most efficient tools in excel for data analysis. If you are using pivot tables frequently, then you will find even after deleting the old data from the data source, it remains in the filter drop-down of the pivot table. We will learn, how to remove the old row and column items from the pivot table in excel. Reason for not removal of the old dataTo better understand, why the data is not removed in the pivot table, even after removing it from the source data, you need to understand the architecture of the pivot table. Internally, the pivot tables have a pivot cache, where the copy of the source data is held. This is done to faster the data retrieving process from the source to the pivot table. Whenever you refresh the pivot table, it gets updated from the pivot cache and not the source data. So, the pivot cache has its properties and default behavior. One of the default behavior, of pivot cache, is that it does not delete the old rows or columns from the filter drop-down. It is a default setting which can be changed very easily. Removing Old rows and columns from the Pivot table Given a table students and their marks. A pivot table is also made from the give</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> <hr> <div class="similar_article_wrapper"> <div class="author_section"> <div class="author_img_wrap"> <p class="author_avatar" style="background-color:#B0DAFF; ">A</p> <i class="author_badge contributor"></i> <div class="author_name"> <a href="https://www.geeksforgeeks.org/user/earlylearning515/contributions/?itm_source=geeksforgeeks&itm_medium=article_author&itm_campaign=auth_user" style="text-decoration: none;">Aditya Upadhyay</a> </div> </div> <div class="article_action_btns"> <div class="author_follow follow_icon" value="earlylearning515" onclick="followUnfollow(event);" style="cursor: pointer;"><i class="gfg_icon gfg_plus_icon"></i>Follow</div> </div> </div> <a href="https://www.geeksforgeeks.org/how-to-add-and-use-an-excel-pivot-table-calculated-field/" class="similar_article_anchor"> <div class="article_title"> <h1>How to Add and Use an Excel Pivot Table Calculated Field?</h1> </div> <div class="article_content_wrapper"> <div class="article_main_content"> <img class="similar_article_img" loading="lazy" alt="article_img" src="https://media.geeksforgeeks.org/wp-content/uploads/20221020204159/HowToAddAndUseAnExcelPivotTableCalculatedField1.png"></img> <div class="similar_article_content">Excel pivot tables are one of its most helpful features. They are utilized to summarize or aggregate large quantities of data. The data can be summarized using the average, the count, or other statistical approaches. It summarizes a large amount of data into a few rows and columns. They make it simple to explore the data from various views and angles and are excellent for data exploration. When you create a Pivot table, you often need to add more data and calculations to your analysis. If you require a new data point that can be obtained by leveraging existing data points in the Pivot Table, you don't need to go back and add it to the source data. Instead, you can utilize a Pivot Table Calculated Field to accomplish this. Pivot Table Calculated Field The "Pivot Table calculated field" option allows you to insert more data or calculations in the pivot table. For our reports, we frequently need to include our own unique calculations that can relate to other fields in the data collection. Benefits of using a Pivot Table Calculated FieldIt is scalable since it will automatically account for any new data added to your Pivot Table. You can utilize a Calculate Field in your Pivot Table ju</div> </div> <span id="read_more">Read More</span> </div> </a>  </div> </div>  <div class="bottom_ad"> <div id="GFG_AD_InContent_Desktop_BTF_650x250" style="text-align:center;max-height: 300px;"></div> </div> </div> <script> var practiceTab = 0; var communityApiUrl = "https://communityapi.geeksforgeeks.org/"; var showReadMoreBtn = 0</script> <script defer src="https://www.geeksforgeeks.org/wp-content/themes/iconic-one/js/article-page.min.js?ver=1.01"></script> <div id="report_modal_content" class="report_modal_content" style="display:hidden;"></div> <div class="onopen-discussion-panel"> <div class="discussion-tab"> <div class="discussion_heading"> <div></div> <i class="gfg-icon close-tab-icon"></i> </div> <div class="discussion_content"> <div style="height:100%"> <div style="height:100%" id="comment-system"></div> </div> </div> </div> </div> <div class="rightBar" style="padding-right: 5px;"> <style> .article--container_content{ align-items: unset !important; } .sideBar { position: sticky !important; } .gfg-icon_switch::after { background-position: -40px -281px !important; } .gfg-icon_transaction::after { background-position: -40px -321px !important; } .header-main__profile.selected+.mega-dropdown{ width: 225px !important; } #courses-container .course-price{ display:none; } /* .side--container_wscard .card-content .content .meta:empty, .practiceBannerFromPlugin{ display:none !important; } */ .side--container_wscard .card-content .content .meta{ display:block !important; } .side--container_wscard .card-content .content .meta p{ background-color: rgba(254, 212, 91, 0.6); font-size: 10pt; font-weight: bold; display: inline-block; color: var(--color-black); margin-top: 15px; padding: 0px 5px; } #try-it{ display:initial !important; } #try-it .try-it-div{ line-height: 34px; } .gfg-icon_dark-mode::after { background-position: -40px -680px; } .side--container_wscard .head{ font-size: 14px !important; } .nineDot-menu, .gfg-icon_ndot{ display: none; } #text-15{ flex-direction: column; } .mtq_correct_marker, .mtq_wrong_marker{ display: none; } .sidebar_wrapper > :last-child{ margin: unset !important; margin-left: 5px !important; margin-top: 20px !important; top: 70px !important; } .darkMode-wrap{ bottom:1% !important; } #secondary .textwidget{ margin-left: auto; margin-right: 0; text-align: right; } #secondary .widget_text:last-child{ top: 70px !important; } @media(max-width:768px){ #scrollTopBtn{ display:none !important; } } .rightbar_loggedin_promo_cta{ display:flex; cursor:pointer; margin-bottom:20px; } </style> <div id="secondary" class="widget-area"> <div class='OINTechPromoRightBarBanner' id='rightBarSaleBanner' style='text-align:right; margin-bottom:5px;'><a href=https://www.geeksforgeeks.org/geeksforgeeks-premium-subscription?itm_source=geeksforgeeks&itm_medium=rightbar_oin&itm_campaign=premium><img src=https://media.geeksforgeeks.org/auth-dashboard-uploads/premium_oin_rbar_min.png alt='three90RightbarBannerImg' style='width:300px; height:250px;'></a></div>  <aside id="text-15" class="widget widget_text"> <div class="textwidget"> <div id="_GFG_ABP_Desktop_RightSideBar_ATF_300x600_2"></div> <div id="GFG_AD_Desktop_RightSideBar_ATF_300x250_2" style="min-width: 300px;margin-bottom:10px;"></div> <div id='GFG_AD_Desktop_RightSideBar_ATF_300x600' style='min-width: 300px; min-height: 600px;margin-bottom:10px;'></div> </div> </aside>  <aside id="text-16" class="widget widget_text"> <div class="textwidget"> <div id="_GFG_ABP_Desktop_RightSideBar_MTF_300x600"></div> <div id='GFG_AD_Desktop_RightSideBar_MTF_300x250' style='min-width: 300px;'></div> <div id="_GFG_ABP_Desktop_RightSideBar_BTF_300x600"></div> <div id="_GFG_ABP_Desktop_RightSideBar_BTF_300x600_3"></div> </div> </aside>  <style>.right-bar-explore-more{ visibility: hidden; min-height: 230px;text-align:left;min-width:300px;max-width:300px; padding-left: 19px; padding-right: 25px; margin-top: 20px;} .right-bar-explore-more .title{text-align:left;font-size:20px; font-weight: 600; line-height: 22px; color:var(--em-heading);padding:14px 0;font-family:var(--font-primary)} .right-bar-explore-more .rightbar-sticky-ul {list-style: disc outside; padding-left: 17px;} .right-bar-explore-more li{font-size: 14px !important;font-weight: 400;line-height: 18px !important;color: var(--em-text);margin: 14px 0;font-family:var(--font-primary);} .right-bar-explore-more li::marker{color: var(--em-text) !important;} .right-bar-explore-more .rightbar-sticky-ul a{text-align:left !important; color: var(--em-text); display: block !important;} .right-bar-explore-more .rightbar-sticky-ul a:hover{text-decoration:underline;color:var(--em-link)!important;} .right-bar-explore-more hr {margin: 0;background-color: var(--tn-hr);} @media (max-width: 991px){ .right-bar-explore-more{ width: 85%; margin: auto; margin-top: 20px; max-width: unset; display: none !important; } #text-18 .textwidget{ width: 100%; } }</style> <script> var rightBarExploreMoreList = `<li style="color:var(--color-black)"><a href="https://www.geeksforgeeks.org/track-location-with-phone-number/?ref=rightbar_explore" target="_blank" style="font-family:var(--font-primary)">How to Track Someone's Location with Phone Number</a></li><li style="color:var(--color-black)"><a href="https://www.geeksforgeeks.org/reverse-phone-number-lookup/?ref=rightbar_explore" target="_blank" style="font-family:var(--font-primary)">Free Reverse Phone Number Lookup: 10 Best Picks in 2024</a></li><li style="color:var(--color-black)"><a href="https://www.geeksforgeeks.org/best-plex-plugins/?ref=rightbar_explore" target="_blank" style="font-family:var(--font-primary)">11 Best Plex Plugins Worth Using in 2024 (How to Install)</a></li><li style="color:var(--color-black)"><a href="https://www.geeksforgeeks.org/best-iptv-service-provider-subscriptions/?ref=rightbar_explore" target="_blank" style="font-family:var(--font-primary)">15 Best IPTV Service Providers Subscriptions (Top Picks)</a></li><li style="color:var(--color-black)"><a href="https://www.geeksforgeeks.org/top-spotify-alternatives/?ref=rightbar_explore" target="_blank" style="font-family:var(--font-primary)">10 Best Spotify Alternatives in 2024: Best Music Streaming Service</a></li>` </script>  <aside id="text-18" class="widget widget_text"> <div class="textwidget"> <div class="right-bar-explore-more" style="display:none;visibility: unset;"> <div class="title">Explore More</div> <ul class="rightbar-sticky-ul"></ul> </div> <div id='GFG_AD_Desktop_RightSideBar_BTF_Sticky_300x250' style='min-width: 300px;margin-bottom:10px'></div> <div id='GFG_AD_Desktop_RightSideBar_Docked_160x600' style='min-width: 160px;'></div><div id='GFG_AD_Desktop_RightSideBar_BTFdocked_300x600' style='min-width: 300px;'></div> </aside>  <aside id="text-20" class="widget widget_text"> <div class="textwidget">  </div> </aside> </div> <div id="user-personal-note" style="display: none;"></div> </div> </div> <section class="disqus-section"> <div class="article-page_flex"> <div class="leftBar"> </div> </div> </section> </div> <div id="video-popup" style="display:none"></div> <link rel="stylesheet" href='https://www.geeksforgeeks.org/wp-content/themes/iconic-one/css/articleList.min.css?ver=1.7'> <script> $(document).ready(function() { var isfollowingApiCall = false; if ($('.follow-btn').length) { var articleRecommendedTop = $(".article--recommended").offset().top; var articleRecommendedBottom = articleRecommendedTop + $(".article--recommended").outerHeight(); $(window).scroll(function() { var top_of_element = $(".article--recommended").offset().top; var bottom_of_element = $(".article--recommended").offset().top + $(".article--recommended").outerHeight(); var bottom_of_screen = $(window).scrollTop() + $(window).innerHeight(); var top_of_screen = $(window).scrollTop(); if ((bottom_of_screen > top_of_element && top_of_screen < bottom_of_element) || (bottom_of_screen > articleRecommendedTop && top_of_screen < articleRecommendedBottom) || (top_of_screen > articleRecommendedBottom)) { if (!isfollowingApiCall) { isfollowingApiCall = true; setTimeout(function(){ if (loginData && loginData.isLoggedIn) { if (loginData.userName !== $('#followAuthor').val()) { is_following(); } else { $('.profileCard-profile-picture').css('background-color', '#E7E7E7'); } } else { $('.follow-btn').removeClass('hideIt'); } }, 3000); } } }); } $(".accordion-header").click(function() { var arrowIcon = $(this).find('.bottom-arrow-icon'); arrowIcon.toggleClass('rotate180'); }); }); window.isReportArticle = false; function report_article(){ if (!loginData || !loginData.isLoggedIn) { const loginModalButton = $('.login-modal-btn') if (loginModalButton.length) { loginModalButton.click(); } return; } if(!window.isReportArticle){ //to add loader $('.report-loader').addClass('spinner'); jQuery('#report_modal_content').load(gfgSiteUrl+'wp-content/themes/iconic-one/report-modal.php', { PRACTICE_API_URL: practiceAPIURL, PRACTICE_URL:practiceURL },function(responseTxt, statusTxt, xhr){ if(statusTxt == "error"){ alert("Error: " + xhr.status + ": " + xhr.statusText); } }); }else{ window.scrollTo({ top: 0, behavior: 'smooth' }); $("#report_modal_content").show(); } } function closeShareModal() { const shareOption = document.querySelector('[data-gfg-action="share-article"]'); shareOption.classList.remove("hover_share_menu"); let shareModal = document.querySelector(".hover__share-modal-container"); shareModal && shareModal.remove(); } function openShareModal() { closeShareModal(); // Remove existing modal if any let shareModal = document.querySelector(".three_dot_dropdown_share"); shareModal.appendChild(Object.assign(document.createElement("div"), { className: "hover__share-modal-container" })); document.querySelector(".hover__share-modal-container").append( Object.assign(document.createElement('div'), { className: "share__modal" }), ); document.querySelector(".share__modal").append(Object.assign(document.createElement('h1'), { className: "share__modal-heading" }, { textContent: "Share to" })); const socialOptions = ["LinkedIn", "WhatsApp", "Copy Link"]; socialOptions.forEach((socialOption) => { const socialContainer = Object.assign(document.createElement('div'), { className: "social__container" }); const icon = Object.assign(document.createElement("div"), { className: `share__icon share__${socialOption.split(" ").join("")}-icon` }); const socialText = Object.assign(document.createElement("span"), { className: "share__option-text" }, { textContent: `${socialOption}` }); const shareLink = (socialOption === "Copy Link") ? Object.assign(document.createElement('div'), { role: "button", className: "link-container CopyLink" }) : Object.assign(document.createElement('a'), { className: "link-container" }); if (socialOption === "LinkedIn") { shareLink.setAttribute('href', `https://www.linkedin.com/sharing/share-offsite/?url=${window.location.href}`); shareLink.setAttribute('target', '_blank'); } if (socialOption === "WhatsApp") { shareLink.setAttribute('href', `https://api.whatsapp.com/send?text=${window.location.href}`); shareLink.setAttribute('target', "_blank"); } shareLink.append(icon, socialText); socialContainer.append(shareLink); document.querySelector(".share__modal").appendChild(socialContainer); //adding copy url functionality if(socialOption === "Copy Link") { shareLink.addEventListener("click", function() { var tempInput = document.createElement("input"); tempInput.value = window.location.href; document.body.appendChild(tempInput); tempInput.select(); tempInput.setSelectionRange(0, 99999); // For mobile devices document.execCommand('copy'); document.body.removeChild(tempInput); this.querySelector(".share__option-text").textContent = "Copied" }) } }); document.querySelector(".hover__share-modal-container").addEventListener("mouseover", () => document.querySelector('[data-gfg-action="share-article"]').classList.add("hover_share_menu")); } function toggleLikeElementVisibility(selector, show) { document.querySelector(`.${selector}`).style.display = show ? "block" : "none"; } function closeKebabMenu(){ document.getElementById("myDropdown").classList.toggle("show"); } </script>  <script> $(document).ready(function() { $("#showMoreTagsBtn").click(function() { $('.articles-hidden-tags').show(); $(this).hide(); }); $("#showMorePracticeTagsBtn").click(function() { $(".practice-tags li:nth-child(n+5)").show(); $(this).hide(); }); }); </script>  <style> .grecaptcha-badge { visibility: hidden !important; } .thank-you-message { height: 100%; display:flex; flex-direction: column; justify-content: center; align-items: center; } .thank-you-message-content { margin-top: 17px; font: 400 20px var(--font-secondary); color: var(--improve-modal-text); line-height: 180%; text-align: center; } .thank-you-message-content h2{ font-family: var(--font-secondary); } .all-footer-information{ width: 100% !important;; } .footer-wrapper_links-list{ margin-block-start: 0em !important; width: 16% !important; padding-inline-start: 18px !important; } .link-head{ margin-bottom: 0px; } @media only screen and (max-width:1340px) { .footer-wrapper_links-list{ overflow-wrap: break-word; } } @media screen and (min-width: 991px) { .all-footer-information{ padding-left:15px; } } @media only screen and (max-width:980px) { .footer-wrapper_branding-address{ padding-top: 10px; } } @media (max-width: 750px) { .thank-you-message-content{ font-size: 14px; line-height: 170%; } } /* CSS variable meant to handle the dark and light mode icon for three 90 event in header courses dropdown */ :root{ --three90headericon : url('https://media.geeksforgeeks.org/auth-dashboard-uploads/three90daylogocompressed.svg'); --three90headericonposition : 0px -40px; --three90leftbarimggrid : url('https://media.geeksforgeeks.org/auth-dashboard-uploads/three90leftbarspritecompressed.svg'); --three90leftbarimgposition : -5px -55px; --three90leftbarbgcolour : #b3abd0; } body[data-dark-mode="true"]{ --three90leftbarimgposition : -6px 1px; --three90headericonposition : 0px 0px; --three90leftbarbgcolour: #8c82b9; } .three90leftbarimg{ margin-left: -5px; height: 30px; background-image: var(--three90leftbarimggrid); background-repeat: no-repeat; background-position: var(--three90leftbarimgposition); background-size: 212px; } .courseTabShimmer{ position: absolute; height: 110%; width: 0; opacity: .7; -webkit-animation: courseShimmer 2s cubic-bezier(0,0,.07,.61) infinite; animation: courseShimmer 2s cubic-bezier(0,0,.07,.61) infinite; box-shadow: 0 0 25px 5px #dddcdc; -webkit-transform: rotate(90deg); transform: rotate(90deg); padding:0px !important; border:unset !important; } @keyframes courseShimmer{ 0% { left: 0; } 55% { left: 100%; } 99% { left: 110%; } } </style> </div> <div id="displayModal" class="modal fade" role="dialog"> <div class="modal-dialog">  <div class="modal-content"> <div class="error-message"></div>  <div class="modal-body" id="dmBody"> <div id="modal-dm-content"></div> <div class="modal-overlay" aria-hidden=true> <span class="loader__animation"></span> </div>  </div> </div> </div> </div> <div id="displayModalBackdrop" class="backdrop"></div>  <footer class="gfg-footer" id="gfg-footer"> <div class="footer-wrapper"> <div class="footer-wrapper_branding"> <a class="footer-wrapper_branding-anchor" aria-label="GeeksforGeeks Logo" href="https://www.geeksforgeeks.org/"> <img style="height: 32px; width: 230px; max-width: fit-content;" class="footer-wrapper_branding-nlogo" src="https://media.geeksforgeeks.org/auth-dashboard-uploads/gfgFooterLogo.png" alt="geeksforgeeks-footer-logo"/> </a> <div class="footer-wrapper_branding-address"> <div class="address_section"> <div class="address-icon-wrapper"> <i class="gfg-icon gfg-icon_pin"></i> <div class="address_div"> <div class="footer-address"> Corporate & Communications Address:- A-143, 9th Floor, Sovereign Corporate Tower, Sector- 136, Noida, Uttar Pradesh (201305) | Registered Address:- K 061, Tower K, Gulshan Vivante Apartment, Sector 137, Noida, Gautam Buddh Nagar, Uttar Pradesh, 201305 </div> </div> </div> </div> </div> <div class="footer-wrapper_branding-social"> <a href="https://www.facebook.com/geeksforgeeks.org/" rel="noopener noreferrer" aria-label="GeeksforGeeks Facebook" target="_blank"> <div class="facebook"></div> </a> <a href="https://www.instagram.com/geeks_for_geeks/" rel="noopener noreferrer" aria-label="GeeksforGeeks Instagram" target="_blank"> <div class="instagram"></div> </a> <a href="https://in.linkedin.com/company/geeksforgeeks" rel="noopener noreferrer" aria-label="GeeksforGeeks LinkedIn" target="_blank"> <div class="linkedin"></div> </a> <a href="https://twitter.com/geeksforgeeks" rel="noopener noreferrer" aria-label="GeeksforGeeks Twitter" target="_blank"> <div class="twitter"></div> </a> <a href="https://www.youtube.com/geeksforgeeksvideos" rel="noopener noreferrer" aria-label="GeeksforGeeks YouTube" target="_blank"> <div class="youtube"></div> </a> </div> <div class="footer-wrapper_branding-app"> <a aria-label="GeeksforGeeks App Link" href="https://geeksforgeeksapp.page.link/gfg-app" target="_blank" ><img src="https://media.geeksforgeeks.org/auth-dashboard-uploads/googleplay.png" alt="GFG App on Play Store" id="gplay" loading="lazy"></a> <a aria-label="GeeksforGeeks App Link" href="https://geeksforgeeksapp.page.link/gfg-app" target="_blank"><img src="https://media.geeksforgeeks.org/auth-dashboard-uploads/appstore.png" alt="GFG App on App Store" id="appstore" loading="lazy"></a> </div> </div> <div class="all-footer-information"> <div class="footer-wrapper_links" style="justify-content: space-between; text-align: -webkit-left;"><ul class="footer-wrapper_links-list" ><li>Company</li><li><a href=https://www.geeksforgeeks.org/about/?ref=outindfooter>About Us</a></li><li><a href=https://www.geeksforgeeks.org/legal/?ref=outindfooter>Legal</a></li><li><a href=https://www.geeksforgeeks.org/press-release/?ref=outindfooter>In Media</a></li><li><a href=https://www.geeksforgeeks.org/about/contact-us/?ref=outindfooter>Contact Us</a></li><li><a href=https://www.geeksforgeeks.org/advertise-with-us/?ref=outindfooter>Advertise with us</a></li><li><a href=https://www.geeksforgeeks.org/gfg-corporate-solution/?ref=outindfooter>GFG Corporate Solution</a></li><li><a href=https://www.geeksforgeeks.org/campus-training-program/?ref=outindfooter>Placement Training Program</a></li><li><a href=https://www.geeksforgeeks.org/community/?ref=outindfooter>GeeksforGeeks Community</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/introduction-to-programming-languages/?ref=outindfooter>Languages</a></li><li><a href=https://www.geeksforgeeks.org/python-programming-language/?ref=outindfooter>Python</a></li><li><a href=https://www.geeksforgeeks.org/java/?ref=outindfooter>Java</a></li><li><a href=https://www.geeksforgeeks.org/c-plus-plus/?ref=outindfooter>C++</a></li><li><a href=https://www.geeksforgeeks.org/php-tutorials/?ref=outindfooter>PHP</a></li><li><a href=https://www.geeksforgeeks.org/golang/?ref=outindfooter>GoLang</a></li><li><a href=https://www.geeksforgeeks.org/sql-tutorial/?ref=outindfooter>SQL</a></li><li><a href=https://www.geeksforgeeks.org/r-tutorial/?ref=outindfooter>R Language</a></li><li><a href=https://www.geeksforgeeks.org/android-tutorial/?ref=outindfooter>Android Tutorial</a></li><li><a href=https://www.geeksforgeeks.org/geeksforgeeks-online-tutorials-free/?ref=outindfooter>Tutorials Archive</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/learn-data-structures-and-algorithms-dsa-tutorial/?ref=outindfooter>DSA</a></li><li><a href=https://www.geeksforgeeks.org/data-structures/?ref=outindfooter>Data Structures</a></li><li><a href=https://www.geeksforgeeks.org/fundamentals-of-algorithms/?ref=outindfooter>Algorithms</a></li><li><a href=https://www.geeksforgeeks.org/complete-guide-to-dsa-for-beginners/?ref=outindfooter>DSA for Beginners</a></li><li><a href=https://www.geeksforgeeks.org/basic-coding-problems-in-dsa-for-beginners/?ref=outindfooter>Basic DSA Problems</a></li><li><a href=https://www.geeksforgeeks.org/complete-roadmap-to-learn-dsa-from-scratch/?ref=outindfooter>DSA Roadmap</a></li><li><a href=https://www.geeksforgeeks.org/top-100-data-structure-and-algorithms-dsa-interview-questions-topic-wise/?ref=outindfooter>Top 100 DSA Interview Problems</a></li><li><a href=https://www.geeksforgeeks.org/dsa-roadmap-for-beginner-to-advanced-by-sandeep-jain/?ref=outindfooter>DSA Roadmap by Sandeep Jain</a></li><li><a href=https://www.geeksforgeeks.org/geeksforgeeks-master-sheet-list-of-all-cheat-sheets/?ref=outindfooter>All Cheat Sheets</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/ai-ml-ds/?ref=outindfooter>Data Science & ML</a></li><li><a href=https://www.geeksforgeeks.org/data-science-tutorial/?ref=outindfooter>Data Science With Python</a></li><li><a href=https://www.geeksforgeeks.org/data-science-for-beginners/?ref=outindfooter>Data Science For Beginner</a></li><li><a href=https://www.geeksforgeeks.org/machine-learning/?ref=outindfooter>Machine Learning</a></li><li><a href=https://www.geeksforgeeks.org/machine-learning-mathematics/?ref=outindfooter>ML Maths</a></li><li><a href=https://www.geeksforgeeks.org/python-data-visualization-tutorial/?ref=outindfooter>Data Visualisation</a></li><li><a href=https://www.geeksforgeeks.org/pandas-tutorial/?ref=outindfooter>Pandas</a></li><li><a href=https://www.geeksforgeeks.org/numpy-tutorial/?ref=outindfooter>NumPy</a></li><li><a href=https://www.geeksforgeeks.org/natural-language-processing-nlp-tutorial/?ref=outindfooter>NLP</a></li><li><a href=https://www.geeksforgeeks.org/deep-learning-tutorial/?ref=outindfooter>Deep Learning</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/web-technology/?ref=outindfooter>Web Technologies</a></li><li><a href=https://www.geeksforgeeks.org/html/?ref=outindfooter>HTML</a></li><li><a href=https://www.geeksforgeeks.org/css/?ref=outindfooter>CSS</a></li><li><a href=https://www.geeksforgeeks.org/javascript/?ref=outindfooter>JavaScript</a></li><li><a href=https://www.geeksforgeeks.org/typescript/?ref=outindfooter>TypeScript</a></li><li><a href=https://www.geeksforgeeks.org/learn-reactjs/?ref=outindfooter>ReactJS</a></li><li><a href=https://www.geeksforgeeks.org/nextjs/?ref=outindfooter>NextJS</a></li><li><a href=https://www.geeksforgeeks.org/bootstrap/?ref=outindfooter>Bootstrap</a></li><li><a href=https://www.geeksforgeeks.org/web-design/?ref=outindfooter>Web Design</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/python-programming-language/?ref=outindfooter>Python Tutorial</a></li><li><a href=https://www.geeksforgeeks.org/python-programming-examples/?ref=outindfooter>Python Programming Examples</a></li><li><a href=https://www.geeksforgeeks.org/python-projects-beginner-to-advanced/?ref=outindfooter>Python Projects</a></li><li><a href=https://www.geeksforgeeks.org/python-tkinter-tutorial/?ref=outindfooter>Python Tkinter</a></li><li><a href=https://www.geeksforgeeks.org/python-web-scraping-tutorial/?ref=outindfooter>Web Scraping</a></li><li><a href=https://www.geeksforgeeks.org/opencv-python-tutorial/?ref=outindfooter>OpenCV Tutorial</a></li><li><a href=https://www.geeksforgeeks.org/python-interview-questions/?ref=outindfooter>Python Interview Question</a></li><li><a href=https://www.geeksforgeeks.org/django-tutorial/?ref=outindfooter>Django</a></li></ul></div><div class="footer-wrapper_links" style="justify-content: space-between; text-align: -webkit-left;"><ul class="footer-wrapper_links-list" style="margin-block-start: 0em; width:16%; padding-inline-start: 18px;"><li>Computer Science</li><li><a href=https://www.geeksforgeeks.org/operating-systems/?ref=outindfooter>Operating Systems</a></li><li><a href=https://www.geeksforgeeks.org/computer-network-tutorials/?ref=outindfooter>Computer Network</a></li><li><a href=https://www.geeksforgeeks.org/dbms/?ref=outindfooter>Database Management System</a></li><li><a href=https://www.geeksforgeeks.org/software-engineering/?ref=outindfooter>Software Engineering</a></li><li><a href=https://www.geeksforgeeks.org/digital-electronics-logic-design-tutorials/?ref=outindfooter>Digital Logic Design</a></li><li><a href=https://www.geeksforgeeks.org/engineering-mathematics-tutorials/?ref=outindfooter>Engineering Maths</a></li><li><a href=https://www.geeksforgeeks.org/software-development/?ref=outindfooter>Software Development</a></li><li><a href=https://www.geeksforgeeks.org/software-testing-tutorial/?ref=outindfooter>Software Testing</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/devops-tutorial/?ref=outindfooter>DevOps</a></li><li><a href=https://www.geeksforgeeks.org/git-tutorial/?ref=outindfooter>Git</a></li><li><a href=https://www.geeksforgeeks.org/linux-tutorial/?ref=outindfooter>Linux</a></li><li><a href=https://www.geeksforgeeks.org/aws-tutorial/?ref=outindfooter>AWS</a></li><li><a href=https://www.geeksforgeeks.org/docker-tutorial/?ref=outindfooter>Docker</a></li><li><a href=https://www.geeksforgeeks.org/kubernetes-tutorial/?ref=outindfooter>Kubernetes</a></li><li><a href=https://www.geeksforgeeks.org/microsoft-azure/?ref=outindfooter>Azure</a></li><li><a href=https://www.geeksforgeeks.org/google-cloud-platform-tutorial/?ref=outindfooter>GCP</a></li><li><a href=https://www.geeksforgeeks.org/devops-roadmap/?ref=outindfooter>DevOps Roadmap</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/system-design-tutorial/?ref=outindfooter>System Design</a></li><li><a href=https://www.geeksforgeeks.org/what-is-high-level-design-learn-system-design/?ref=outindfooter>High Level Design</a></li><li><a href=https://www.geeksforgeeks.org/what-is-low-level-design-or-lld-learn-system-design/?ref=outindfooter>Low Level Design</a></li><li><a href=https://www.geeksforgeeks.org/unified-modeling-language-uml-introduction/?ref=outindfooter>UML Diagrams</a></li><li><a href=https://www.geeksforgeeks.org/system-design-interview-guide/?ref=outindfooter>Interview Guide</a></li><li><a href=https://www.geeksforgeeks.org/software-design-patterns/?ref=outindfooter>Design Patterns</a></li><li><a href=https://www.geeksforgeeks.org/object-oriented-analysis-and-design/?ref=outindfooter>OOAD</a></li><li><a href=https://www.geeksforgeeks.org/system-design-interview-bootcamp-guide/?ref=outindfooter>System Design Bootcamp</a></li><li><a href=https://www.geeksforgeeks.org/most-commonly-asked-system-design-interview-problems-questions/?ref=outindfooter>Interview Questions</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/technical-interview-preparation/?ref=outindfooter>Inteview Preparation</a></li><li><a href=https://www.geeksforgeeks.org/competitive-programming-a-complete-guide/?ref=outindfooter>Competitive Programming</a></li><li><a href=https://www.geeksforgeeks.org/top-algorithms-and-data-structures-for-competitive-programming/?ref=outindfooter>Top DS or Algo for CP</a></li><li><a href=https://www.geeksforgeeks.org/company-wise-recruitment-process/?ref=outindfooter>Company-Wise Recruitment Process</a></li><li><a href=https://www.geeksforgeeks.org/company-preparation/?ref=outindfooter>Company-Wise Preparation</a></li><li><a href=https://www.geeksforgeeks.org/aptitude-questions-and-answers/?ref=outindfooter>Aptitude Preparation</a></li><li><a href=https://www.geeksforgeeks.org/puzzles/?ref=outindfooter>Puzzles</a></li></ul><ul class="footer-wrapper_links-list" ><li>School Subjects</li><li><a href=https://www.geeksforgeeks.org/maths/?ref=outindfooter>Mathematics</a></li><li><a href=https://www.geeksforgeeks.org/physics/?ref=outindfooter>Physics</a></li><li><a href=https://www.geeksforgeeks.org/chemistry/?ref=outindfooter>Chemistry</a></li><li><a href=https://www.geeksforgeeks.org/biology/?ref=outindfooter>Biology</a></li><li><a href=https://www.geeksforgeeks.org/social-science/?ref=outindfooter>Social Science</a></li><li><a href=https://www.geeksforgeeks.org/english-grammar/?ref=outindfooter>English Grammar</a></li><li><a href=https://www.geeksforgeeks.org/commerce/?ref=outindfooter>Commerce</a></li><li><a href=https://www.geeksforgeeks.org/tag/world-general-knowledge/?ref=outindfooter>World GK</a></li></ul><ul class="footer-wrapper_links-list" ><li><a class="link-head" href=https://www.geeksforgeeks.org/videos/?ref=outindfooter>GeeksforGeeks Videos</a></li><li><a href=https://www.geeksforgeeks.org/videos/category/sde-sheet/?ref=outindfooter>DSA</a></li><li><a href=https://www.geeksforgeeks.org/videos/category/python/?ref=outindfooter>Python</a></li><li><a href=https://www.geeksforgeeks.org/videos/category/java-w6y5f4/?ref=outindfooter>Java</a></li><li><a href=https://www.geeksforgeeks.org/videos/category/c/?ref=outindfooter>C++</a></li><li><a href=https://www.geeksforgeeks.org/videos/category/web-development/?ref=outindfooter>Web Development</a></li><li><a href=https://www.geeksforgeeks.org/videos/category/data-science/?ref=outindfooter>Data Science</a></li><li><a href=https://www.geeksforgeeks.org/videos/category/cs-subjects/?ref=outindfooter>CS Subjects</a></li></ul></div> </div> </div>  <style> :root{ --home-jobs-section-jf-logo: url('https://media.geeksforgeeks.org/auth-dashboard-uploads/JobFair2024Logo.svg'); } body[data-dark-mode="true"] { --home-jobs-section-jf-logo: url('https://media.geeksforgeeks.org/auth-dashboard-uploads/JobFair2024LogoDark.svg'); } .hp_job_section_jf_logo, .job-a-thon-jf-sticky-header-logo{ background: var(--home-jobs-section-jf-logo); height: 50px; background-repeat: no-repeat; width: 105px; background-size: 100px; } @keyframes challenge { 0%{ transform: scale(1); } 50%{ transform: scale(1.03); } 100%{ transform: scale(1); } } .job-a-thon-jf-sticky-header-logo{ height: 45px; } </style>  <div class="footer-strip" > <div class="copyright"> <a href="https://www.geeksforgeeks.org/" rel="noopener noreferrer" target="_blank">@GeeksforGeeks, Sanchhaya Education Private Limited</a><span>, <a href="https://www.geeksforgeeks.org/copyright-information/">All rights reserved</a></span> </div> <div class="social-links"> </div> </div> </footer> </div> <script type='text/javascript' src='https://www.geeksforgeeks.org/wp-includes/js/wp-embed.min.js?ver=4.9.8'></script>  <div class="cookie-consent hide-consent"> <span class="cookie-text"> We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our <a href="https://www.geeksforgeeks.org/cookie-policy/" target="_blank"><u>Cookie Policy</u></a> & <a href="https://www.geeksforgeeks.org/privacy-policy/" target="_blank"><u>Privacy Policy</u></a> </span> <button class="consent-btn"> Got It ! </button> </div>   <div class="lightbox-target"> <img id="lightbox-image" src="" alt="Lightbox"/> <span class="lightbox-close"></span> </div>   <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@400;700&family=Source+Sans+3:wght@400;600&display=swap" rel="stylesheet"> <script> if(post_slug.includes('premium-plans-payment/') || post_slug.includes('premium-plans/')){ $('.darkMode-wrap').remove(); $('.toggle-darkMode').remove(); } function setGoogleRecaptcha() { var captchaSiteKey = '6LdMFNUZAAAAAIuRtzg0piOT-qXCbDF-iQiUi9KY'; grecaptcha.ready(function() { grecaptcha.execute(captchaSiteKey).then(function(token) { document.getElementById('g-recaptcha-response-suggestion-form').value = token; suggestionCall(); }); }); } </script> <div class="improve-modal--overlay" style="display: none;"> <div class="improve-modal--improvement" status="locked"> <div class="improve-modal--improve-header"> <div class="improve-header-fst-child">Improvement</div> <div class="improve-header-sec-child"> <i class="gfg-icon improve-cross-icon"></i> </div> </div> <div class="locked-status--impove-modal"> <div class="improve-modal--improve-content error-message"></div> <div class="improve-modal--improve-bottom"> <button class="improve-bottom-btn" type="button">Suggest changes</button> </div> </div> <div class="unlocked-status--improve-modal-content"> <div class="suggest-change_wrapper"> <div class="suggest-change-content_wrapper"> <div class="suggest-change">Suggest Changes</div> <div class="suggest-changes-about">Help us improve. Share your suggestions to enhance the article. Contribute your expertise and make a difference in the GeeksforGeeks portal.</div> </div> <div class="suggest-change-icon_wrapper"> <img class="suggest-change-icon" src="https://media.geeksforgeeks.org/auth-dashboard-uploads/suggestChangeIcon.png" alt="geeksforgeeks-suggest-icon"/> </div> </div> <div class="create-improvement_wrapper"> <div class="create-improvement-content_wrapper"> <div class="create-improvement">Create Improvement</div> <div class="create-improvements-about">Enhance the article with your expertise. Contribute to the GeeksforGeeks community and help create better learning resources for all.</div> </div> <div class="create-improvement-icon_wrapper"> <img class="create-improvement-icon" src="https://media.geeksforgeeks.org/auth-dashboard-uploads/createImprovementIcon.png" alt="geeksforgeeks-improvement-icon"/> </div> </div> <div class="error-status"></div> </div> </div> <div class="improve-modal--suggestion" style="display: none;">  <div class="improve-modal--improve-header"> <div class="left-arrow-icon_suggest_wrapper"> <div class="left-arrow-icon_wrapper"> <i class="gfg-icon improve-left-arrow-icon"></i> </div> <div class="improve-header-fst-child">Suggest Changes</div> </div> <div class="improve-header-sec-child"> <i class="gfg-icon improve-cross-icon"></i> </div> </div> <div class="suggestion-modal-section"> <form> <label for="suggestion-section">min 4 words, max CharLimit:2000</label> <textarea id="suggestion-section-textarea" name="suggestion-section" placeholder="Write your suggestions here"></textarea> <input type="hidden" name="g-recaptcha-suggestion-response" id="g-recaptcha-response-suggestion-form"> </form> </div>  <div class="improve-modal--improve-bottom suggestion-btn"> <p><span id="suggestion-modal-alert" style="display: none;"></span></p> <button class="suggest-bottom-btn" type="button"></button> </div> </div> <a href="#" style="visibility:hidden" class="create-improvement-redirection-to-write" target="_blank"></a> </div> <script> var lockedCasesHtml = `<span class="improve-modal--improve-content-modified"></span><span>You can suggest the changes for now and it will be under 'My Suggestions' Tab on Write.</span><br><br><span>You will be notified via email once the article is available for improvement. Thank you for your valuable feedback!</span>`; var badgesRequiredHtml = `<span>It seems that you do not meet the eligibility criteria to create improvements for this article, as only users who have earned specific badges are permitted to do so.</span><br><br><span>However, you can still create improvements through the <a href="https://write.geeksforgeeks.org/pick-improvements/pick" target='_blank'>Pick for Improvement</a> section.</span>`; jQuery('.improve-header-sec-child').on('click', function(){ jQuery('.improve-modal--overlay').hide(); $('.improve-modal--suggestion').hide(); }); $('.suggest-change_wrapper, .locked-status--impove-modal .improve-bottom-btn').on('click',function(){ // when suggest changes option is clicked $('#suggestion-section-textarea').val(""); $('.suggest-bottom-btn').html("Suggest changes"); $('.improve-modal--improvement').hide(); $('.improve-modal--suggestion').show(); }); $('.create-improvement_wrapper').on('click',function(){ // when create improvement option clicked then improvement reason will be shown if(loginData && loginData.isLoggedIn) { $('body').append('<div class="spinner-loading-overlay"></div>'); $('.spinner-loading-overlay').show(); jQuery.ajax({ url: writeApiUrl + 'create-improvement-post/?v=1', type: "POST", contentType: 'application/json; charset=utf-8', dataType: 'json', xhrFields: { withCredentials: true }, data: JSON.stringify({ gfg_id: post_id }), success:function(result) { $('.spinner-loading-overlay:eq(0)').remove(); $('.improve-modal--overlay').hide(); $('.unlocked-status--improve-modal-content').css("display","none"); $('.create-improvement-redirection-to-write').attr('href',writeUrl + 'improve-post/' + `${result.id}` + '/', '_blank'); $('.create-improvement-redirection-to-write')[0].click(); }, error:function(e) { showErrorMessage(e.responseJSON,e.status) }, }); } else { if(loginData && !loginData.isLoggedIn) { $('.improve-modal--overlay').hide(); if ($('.header-main__wrapper').find('.header-main__signup.login-modal-btn').length) { $('.header-main__wrapper').find('.header-main__signup.login-modal-btn').click(); } return; } } }); $('.left-arrow-icon_wrapper').on('click',function(){ if($('.improve-modal--suggestion').is(":visible")) $('.improve-modal--suggestion').hide(); else{ } $('.improve-modal--improvement').show(); }); const showErrorMessage = (result,statusCode) => { if(!result) return; $('.spinner-loading-overlay:eq(0)').remove(); if(statusCode == 403) { $('.improve-modal--improve-content.error-message').html(result.message); jQuery('.improve-modal--overlay').show(); jQuery('.improve-modal--improvement').show(); $('.locked-status--impove-modal').css("display","block"); $('.unlocked-status--improve-modal-content').css("display","none"); $('.improve-modal--improvement').attr("status","locked"); return; } } function loadScript(src, callback) { var script = document.createElement('script'); script.src = src; script.onload = callback; document.head.appendChild(script); } function suggestionCall() { var suggest_val = $.trim($("#suggestion-section-textarea").val()); var array_String= suggest_val.split(" ") var gCaptchaToken = $("#g-recaptcha-response-suggestion-form").val(); var error_msg = false; if(suggest_val != "" && array_String.length >=4){ if(suggest_val.length <= 2000){ var payload = { "gfg_post_id" : `${post_id}`, "suggestion" : `<p>${suggest_val}</p>`, } if(!loginData || !loginData.isLoggedIn) // User is not logged in payload["g-recaptcha-token"] = gCaptchaToken jQuery.ajax({ type:'post', url: "https://apiwrite.geeksforgeeks.org/suggestions/auth/create/", xhrFields: { withCredentials: true }, crossDomain: true, contentType:'application/json', data: JSON.stringify(payload), success:function(data) { jQuery('.spinner-loading-overlay:eq(0)').remove(); jQuery('#suggestion-section-textarea').val(""); jQuery('.suggest-bottom-btn').css("display","none"); // Update the modal content const modalSection = document.querySelector('.suggestion-modal-section'); modalSection.innerHTML = ` <div class="thank-you-message" style="text-align: center;"> <h2>Thank You!</h2> <div class="thank-you-message-content">Your suggestions are valuable to us.</div> </div> `; }, error:function(data) { jQuery('.spinner-loading-overlay:eq(0)').remove(); jQuery('#suggestion-modal-alert').html("Something went wrong."); jQuery('#suggestion-modal-alert').show(); error_msg = true; } }); } else{ jQuery('.spinner-loading-overlay:eq(0)').remove(); jQuery('#suggestion-modal-alert').html("Minimum 5 Words and Maximum Character limit is 2000."); jQuery('#suggestion-modal-alert').show(); jQuery('#suggestion-section-textarea').focus(); error_msg = true; } } else{ jQuery('.spinner-loading-overlay:eq(0)').remove(); jQuery('#suggestion-modal-alert').html("Enter atleast four words !"); jQuery('#suggestion-modal-alert').show(); jQuery('#suggestion-section-textarea').focus(); error_msg = true; } if(error_msg){ setTimeout(() => { jQuery('#suggestion-section-textarea').focus(); jQuery('#suggestion-modal-alert').hide(); }, 3000); } } document.querySelector('.suggest-bottom-btn').addEventListener('click', function(){ jQuery('body').append('<div class="spinner-loading-overlay"></div>'); jQuery('.spinner-loading-overlay').show(); if(loginData && loginData.isLoggedIn) { suggestionCall(); return; } // load the captcha script and set the token loadScript('https://www.google.com/recaptcha/api.js?render=6LdMFNUZAAAAAIuRtzg0piOT-qXCbDF-iQiUi9KY',[], function() { setGoogleRecaptcha(); }); }); $('.improvement-bottom-btn.create-improvement-btn').click(function() { //create improvement button is clicked $('body').append('<div class="spinner-loading-overlay"></div>'); $('.spinner-loading-overlay').show(); // send this option via create-improvement-post api jQuery.ajax({ url: writeApiUrl + 'create-improvement-post/?v=1', type: "POST", contentType: 'application/json; charset=utf-8', dataType: 'json', xhrFields: { withCredentials: true }, data: JSON.stringify({ gfg_id: post_id }), success:function(result) { $('.spinner-loading-overlay:eq(0)').remove(); $('.improve-modal--overlay').hide(); $('.create-improvement-redirection-to-write').attr('href',writeUrl + 'improve-post/' + `${result.id}` + '/', '_blank'); $('.create-improvement-redirection-to-write')[0].click(); }, error:function(e) { showErrorMessage(e.responseJSON,e.status); }, }); }); </script> <script> var AdblockPlus = new function() { this.detect = function(px, callback) { var detected = false; var checksRemain = 2; var error1 = false; var error2 = false; if (typeof callback != "function") return; px += "?ch=*&rn=*"; function beforeCheck(callback, timeout) { if (checksRemain == 0 || timeout > 1E3) callback(checksRemain == 0 && detected); else setTimeout(function() { beforeCheck(callback, timeout * 2) }, timeout * 2) } function checkImages() { if (--checksRemain) return; detected = !error1 && error2 } var random = Math.random() * 11; var img1 = new Image; img1.onload = checkImages; img1.onerror = function() { error1 = true; checkImages() }; img1.src = px.replace(/\*/, 1).replace(/\*/, random); var img2 = new Image; img2.onload = checkImages; img2.onerror = function() { error2 = true; checkImages() }; img2.src = px.replace(/\*/, 2).replace(/\*/, random); beforeCheck(callback, 250) } }; /* AdblockPlus.detect("https://cdnads.geeksforgeeks.org/res/px.gif", function(abp){ window.googletag = window.googletag || {cmd: []}; window.abp=abp; var elms = [...document.querySelectorAll('div[id^=_GFG_ABP_]')]; const units=elms.map(elem=>elem.id) if(abp) { for(let curr_unit of units) { const iframe = document.createElement('iframe'); iframe.setAttribute('src',"https://aa.geeksforgeeks.org/iframe.html?code="+curr_unit.substr(1)) const elem = document.getElementById(curr_unit) const div = document.createElement('div'); div.setAttribute('id',curr_unit.substr(1)) let sizes = curr_unit.split("_"); sizes = sizes.filter(val => val.includes('x')); let [width, height] = sizes[0].split("x"); iframe.style.width = `${+width+20}px` iframe.style.height = `${+height+20}px` if(elem) { elem.appendChild(iframe); } } var gfgAdDivs = [...document.querySelectorAll('div[id^=GFG_AD_]')]; gfgAdDivs.forEach(gfgDiv => document.getElementById(gfgDiv.id).removeAttribute("style")); jQuery('#secondary .widget_text:last-child').css({"position": "unset"}); } });*/ AdblockPlus.detect("https://cdnads.geeksforgeeks.org/res/px.gif", function(abp){ window.googletag = window.googletag || {cmd: []}; window.abp=abp; var elms = [...document.querySelectorAll('div[id^=_GFG_ABP_]')]; //const units=elms.map(elem=>elem.id) const units = elms .filter(elem => !(window.innerWidth < 1500 && elem.id === "_GFG_ABP_Incontent_728x90")) .map(elem => elem.id); if(abp) { isAdBlockerPresent = true; for(let curr_unit of units) { const iframe = document.createElement('iframe'); iframe.addEventListener("load", () => { iframe.contentWindow.postMessage(JSON.stringify({host: window.location.host,category: window.arrPostCatName,parentWidth: window.innerWidth}),'https://aa.geeksforgeeks.org'); }); iframe.setAttribute('src',"https://aa.geeksforgeeks.org/iframe.html?code="+curr_unit.substr(1)) const elem = document.getElementById(curr_unit) const div = document.createElement('div'); div.setAttribute('id',curr_unit.substr(1)) let sizes = curr_unit.split("_"); sizes = sizes.filter(val => val.includes('x')); let [width, height] = sizes[0].split("x"); iframe.style.width = `${+width+20}px` iframe.style.height = `${+height+20}px` if(elem) { elem.appendChild(iframe); } } var gfgAdDivs = [...document.querySelectorAll('div[id^=GFG_AD_]')]; gfgAdDivs.forEach(gfgDiv => document.getElementById(gfgDiv.id).removeAttribute("style")); jQuery('#secondary .widget_text:last-child').css({"position": "unset"}); } else{ try { var isAdblockEnabled = t => fetch( new Request('https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js', { method: 'HEAD', mode: 'no-cors' }) ).catch(t); isAdblockEnabled(() => { // here goes modal pop-up code isAdBlockerPresent = true; }); } catch (err) {console.log(err);} } }); function closeAdBlockPopupModal(){ const modal = document.getElementById("adBlockerModal"); $('body').removeClass('body-for-ad-blocker'); $('#adBlockerModal').remove() localStorage.setItem('gfgAdBlockPopup',new Date()) } function showAdblockerModal(){ let randomNumberForButtonText = Math.round(Math.random()); let currTime = new Date(); let lastTime = new Date(localStorage.getItem('gfgAdBlockPopup')); if(((currTime-lastTime)/(1000*60*60))<1) { return; } const adBlockerModal = `<div id="adBlockerModal" class="ad-blocker-modal"> <div id="ad-blocker-modal-overlay"> <div id="ad-blocker-outer-div"> <div id="ad-blocker-div"> <p id="ad-blocker-div-warning" style="margin-bottom: 30px;">It seems that you are using an ad blocker.<br><span style="font-size: 22px;font-weight: normal;">Please disable it to support us!</span></p> <div id="ad-blocker-div-btns"> <button id="ad-blocker-div-button1" onclick="handleAdBlockerClick('disabled')"> I disabled my ad blocker </button> <a href="https://www.geeksforgeeks.org/geeksforgeeks-premium-subscription${randomNumberForButtonText === 1 ? "/?itm_source=geeksforgeeks&itm_medium=adblocker&itm_campaign=premium1" : "/?itm_source=geeksforgeeks&itm_medium=adblocker&itm_campaign=premium2"}" target="_blank"> <button id="ad-blocker-div-button2" style=" background: linear-gradient(45deg, #f0bd36, #bf873f); border: 1px solid transparent; color: white; " > ${randomNumberForButtonText === 1 ? "Go Ad-Free with Premium" : "Upgrade for No Ads"} </button> </a> </div> <div id="ad-blocker-div-continue-premium-promo-text"> "For an ad-free experience and exclusive features, subscribe to our Premium Plan!"<br> </div> <div id="ad-blocker-div-continue-btn-div"> <a id="ad-blocker-div-continue-btn" href="#" onclick="closeAdBlockPopupModal()">Continue without supporting</a> </div> </div> </div> </div> </div>`; $('body').append(adBlockerModal); $('body').addClass('body-for-ad-blocker'); const modal = document.getElementById("adBlockerModal"); modal.style.display = "block"; } function handleAdBlockerClick(type){ if(type == 'disabled'){ window.location.reload(); } else if(type == 'info'){ document.getElementById("ad-blocker-div").style.display = "none"; document.getElementById("ad-blocker-info-div").style.display = "flex"; handleAdBlockerIconClick(0); } } var lastSelected= null; //Mapping of name and video URL with the index. const adBlockerVideoMap = [ ['Ad Block Plus','https://media.geeksforgeeks.org/auth-dashboard-uploads/abp-blocker-min.mp4'], ['Ad Block','https://media.geeksforgeeks.org/auth-dashboard-uploads/Ad-block-min.mp4'], ['uBlock Origin','https://media.geeksforgeeks.org/auth-dashboard-uploads/ub-blocke-min.mp4'], ['uBlock','https://media.geeksforgeeks.org/auth-dashboard-uploads/U-blocker-min.mp4'], ] function handleAdBlockerIconClick(currSelected){ const videocontainer = document.getElementById('ad-blocker-info-div-gif'); const videosource = document.getElementById('ad-blocker-info-div-gif-src'); if(lastSelected != null){ document.getElementById("ad-blocker-info-div-icons-"+lastSelected).style.backgroundColor = "white"; document.getElementById("ad-blocker-info-div-icons-"+lastSelected).style.borderColor = "#D6D6D6"; } document.getElementById("ad-blocker-info-div-icons-"+currSelected).style.backgroundColor = "#D9D9D9"; document.getElementById("ad-blocker-info-div-icons-"+currSelected).style.borderColor = "#848484"; document.getElementById('ad-blocker-info-div-name-span').innerHTML = adBlockerVideoMap[currSelected][0] videocontainer.pause(); videosource.setAttribute('src', adBlockerVideoMap[currSelected][1]); videocontainer.load(); videocontainer.play(); lastSelected = currSelected; } </script>  <style> /* Temporary CSS for Three90 pop up modal (START)*/ .three90popup__container { width: 100vw; height: 100vh; position: fixed; top:0px; background: var(--job-tab-faded-background); z-index: 1024; display: flex; align-items: center; justify-content: center; } .three90modal__wrapper{ background-color: white; max-width: 350px; display: flex; flex-direction: column; border-radius: 10px; overflow: hidden; } .three90modal__message-container { display: flex; flex-direction: column; align-items: center; font-family: var(--font-primary); } .three90modal__subheading { margin-top: 20px; font-size: 22px; font-weight: 600; } .three90modal__text-message { margin-top: 20px; font-size: 15px; font-weight: 400; text-align: center; padding: 0 5px; } .three90__modal__button-wrapper { width: 100%; padding: 20px 0px; display: flex; justify-content: space-evenly; } .three90__modal__button-wrapper > button { width: 105px; height: 35px; border-radius: 13px; border:none; font-weight: 600; cursor: pointer; } #three90__modal-close-btn:hover { background-color: #cacbcd; } #three90__modal-explore-btn { background-color: #0a0727; color: white } @media screen and (max-width: 441px) { .three90modal__wrapper { max-width: 300px; } } /* Temporary CSS for Three90 pop up modal (END)*/ </style> <script type="text/javascript" > const coursePromotionCities = JSON.parse(`{"NCR":{"LOCATIONS":["Noida","Greater Noida","Ghaziabad","Faridabad","Delhi","New Delhi"],"COURSES":[{"name":"GATE CS 2025 Classroom Program","url":"https:\/\/www.geeksforgeeks.org\/courses\/gate-cs-self-paced"},{"name":"MERN Full Stack Development","url":"https:\/\/www.geeksforgeeks.org\/courses\/mern-full-stack-development-classroom"},{"name":"DSA For Interview Preparation","url":" https:\/\/www.geeksforgeeks.org\/courses\/dsa-interview-preparation-classroom"},{"name":"JAVA Backend Development","url":"https:\/\/www.geeksforgeeks.org\/courses\/complete-java-backend-development-program"},{"name":"Data Analytics Programme","url":"https:\/\/www.geeksforgeeks.org\/courses\/complete-data-analytics-program"},{"name":"AWS Solutions Architect Certification","url":"https:\/\/www.geeksforgeeks.org\/courses\/aws-solutions-architect-certification-classroom-training"},{"name":"Explore All","url":"https:\/\/www.geeksforgeeks.org\/courses\/offline-courses"}]},"NON_NCR":{"Bengaluru":[{"name":"Data Science Classroom Program","url":"https:\/\/www.geeksforgeeks.org\/courses\/data-science-classroom-program"},{"name":"System Design Classroom Program","url":"https:\/\/www.geeksforgeeks.org\/courses\/system-design-classroom-program"},{"name":"MERN Full Stack Development","url":"https:\/\/www.geeksforgeeks.org\/courses\/mern-full-stack-development-classroom"},{"name":"DSA For Interview Preparation","url":"https:\/\/www.geeksforgeeks.org\/courses\/dsa-interview-preparation-classroom"},{"name":"JAVA Backend Development","url":"https:\/\/www.geeksforgeeks.org\/courses\/complete-java-backend-development-program"},{"name":"Data Analytics Programme","url":"https:\/\/www.geeksforgeeks.org\/courses\/complete-data-analytics-program"},{"name":"AWS Solutions Architect Certification","url":"https:\/\/www.geeksforgeeks.org\/courses\/aws-solutions-architect-certification-classroom-training"},{"name":"Explore All","url":"https:\/\/www.geeksforgeeks.org\/courses\/offline-courses"}],"Pune":[{"name":"MERN Full Stack Development","url":"https:\/\/www.geeksforgeeks.org\/courses\/mern-full-stack-development-classroom"},{"name":"DSA For Interview Preparation","url":"https:\/\/www.geeksforgeeks.org\/courses\/dsa-interview-preparation-classroom"},{"name":"Complete Data Analytics Program","url":"https:\/\/www.geeksforgeeks.org\/courses\/complete-data-analytics-program"},{"name":"Explore All","url":"https:\/\/www.geeksforgeeks.org\/courses\/offline-courses"}]}}`); const offlineCourseTermMapper = JSON.parse(`{"ALL_TERMIDS":["2058","6263","2628","1745","1789","2601","2057","5037","2971","2023","2162","2795"],"COURSE_TERMID_MAP":{"JAVA":["2058"],"DATA_ANALYTICS":["1745","1789","2601","2057","5037","2971","2023","2162","2795"],"DSA":["6263"],"MERN":["2628"]}}`); </script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-KDVRCT5');</script>  <script async src="https://www.googletagmanager.com/gtag/js?id=G-DWCCJLKX3X"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); // gtag('config', 'AW-474915276'); gtag('config', 'G-DWCCJLKX3X'); gtag('config', 'AW-796001856'); </script>  <div id="GFG_AD_Desktop_Stickyunit_1x1"></div>   <style> :root { --com-extra-icons-mobile-image: url(https://media.geeksforgeeks.org/auth-dashboard-uploads/Com-Extra-Icons13.svg); --write-experience-card-1: #ECF5F5; --write-experience-card-icon-1: #21898C; --write-experience-card-2: #EAF2F7; --write-experience-card-icon-2: #3079AC; --write-experience-card-3: #FDEFE6; --write-experience-card-icon-3: #F5A572; --write-experience-card-4: #F1F8F5; --write-experience-card-icon-4: #91C4AD; --write-experience-card-5: #EEE7FF; --write-experience-card-icon-5: #8B72C9; --write-experience-card-6: #F2F8E6; --write-experience-card-icon-6: #78C57F; --editor-button-text-color: #6E6E73; --write-modal-background: #fefefe; --experience-sidebar: #000; --left-bar-background: #FFFFFF; --write-redirect-container:#EAF2F7; --write-redirect-container-hover:#d6e7f2; } /* Dark Mode */ body[data-dark-mode="true"] { --write-modal-background: #161c23; --experience-sidebar: #000; --left-bar-background: #F0F3F5; } .popup-main { padding: 20px 18px 20px 18px; border-radius: 8px; } .popup-main .popup-heading { display: flex; align-items: center; color: #E9E9EA; margin-bottom: 10px; justify-content: space-between; } .popup-main .close-icon { background-image: var(--com-extra-icons-mobile-image);background-position: -15px -1651px;height: 22px;width: 22px;transform: scale(1); margin-bottom: 12px; cursor: pointer; } .popup-main .experience-card { color: #000; display: grid; grid-template-columns: repeat(2, 1fr); gap: 16px; /* margin-bottom:10px; */ } .popup-main a:hover, .popup-main a:active, .popup-main a:visited { color: inherit; text-decoration: none; } .popup-main .exp-card1, .popup-main .exp-card2, .popup-main .exp-card3, .popup-main .exp-card4, .popup-main .exp-card5, .popup-main .exp-card6 { display: flex; align-items: center; border-radius: 10px; cursor: pointer; } .popup-main .exp-card1 .icon1, .popup-main .exp-card2 .icon2, .popup-main .exp-card3 .icon3, .popup-main .exp-card4 .icon4, .popup-main .exp-card5 .icon5, .popup-main .exp-card6 .icon6 { width: 80px; height: 80px; border-radius: 10px 0px 0px 10px; display: flex; align-items: center; justify-content: center; background: var(--write-experience-card-icon-1); } .popup-main .exp-card1 .icon1, .popup-main .exp-card2 .icon2, .popup-main .exp-card3 .icon3, .popup-main .exp-card4 .icon4, .popup-main .exp-card5 .icon5, .popup-main .exp-card6 .icon6 { width: 80px; height: 80px; border-radius: 10px 0px 0px 10px; display: flex; align-items: center; justify-content: center; } .popup-main .exp-card1 .icon1 { background: var(--write-experience-card-icon-1); } .popup-main .exp-card2 .icon2 { background: var(--write-experience-card-icon-2); } .popup-main .exp-card3 .icon3 { background: var(--write-experience-card-icon-3); } .popup-main .exp-card4 .icon4 { background: var(--write-experience-card-icon-4); } .popup-main .exp-card5 .icon5 { background: var(--write-experience-card-icon-5); } .popup-main .exp-card6 .icon6 { background: var(--write-experience-card-icon-6); } .popup-main .exp-card6 .icon6-image { background-image: url(https://media.geeksforgeeks.org/auth-dashboard-uploads/compass.svg); width: 46px; height: 30px; background-size: 30px; background-repeat: no-repeat; background-position: center; } .popup-main .exp-card1 .icon1-image { background-image: var(--com-extra-icons-mobile-image); width: 46px; height: 28px; background-position: -4px -812px; } .popup-main .exp-card2 .icon2-image { background-image: var(--com-extra-icons-mobile-image); width: 46px; height: 28px; background-position: -4px -888px; } .popup-main .exp-card3 .icon3-image { background-image: var(--com-extra-icons-mobile-image); width: 46px; height: 28px; background-position: -4px -848px; } .popup-main .exp-card4 .icon4-image { background-image: url(https://media.geeksforgeeks.org/auth-dashboard-uploads/competitive.svg); width: 46px; height: 30px; background-size: 30px; background-repeat: no-repeat; background-position: center; } .popup-main .exp-card5 .icon5-image { background-image: var(--com-extra-icons-mobile-image); width: 46px; height: 33px; background-position: -4px -1217px; } .popup-main .exp-card1 .exp-card1-text, .popup-main .exp-card2 .exp-card2-text, .popup-main .exp-card3 .exp-card3-text, .popup-main .exp-card4 .exp-card4-text, .popup-main .exp-card5 .exp-card5-text, .popup-main .exp-card6 .exp-card6-text { display: flex; align-items: center; border-radius: 0px 10px 10px 0px; height: 80px; width: calc(100% - 80px); } .popup-main .exp-card1 { justify-content: flex-start; background: var(--write-experience-card-1); } .popup-main .exp-card2 { justify-content: flex-start; background: var(--write-experience-card-2); } .popup-main .exp-card3 { justify-content: flex-start; background: var(--write-experience-card-3); } .popup-main .exp-card4 { justify-content: flex-start; background: var(--write-experience-card-4); } .popup-main .exp-card5 { justify-content: flex-start; background: var(--write-experience-card-5); } .popup-main .exp-card6 { justify-content: flex-start; background: var(--write-experience-card-6); } .popup-main span { font-family: var(--font-primary); font-size: 14px; font-style: normal; font-weight: 500; line-height: normal; padding-left: 5px; padding-right: 5px; } #popup { display: none; background-color: var(--write-modal-background); padding: 20px; text-align: center; position: fixed; top: 50%; left: 50%; transform: translate(-50%, -50%); z-index: 1026; width: min(650px, calc(100% - 20px)); } .link-container-write{ display:flex; flex-direction:column; } .link-container-write > a { margin:7px 0px; } .phrase__container{ color:var(--color-gfg); border-radius: 6px; width: 100%; background-color:var(--write-redirect-container); padding: 15px; text-align: justify; font-size:14px; } .phrase__container:hover { color:var(--color-gfg) !important; background-color:var(--write-redirect-container-hover); } </style> <div class="popup-container"> <div id="popup" accesskey="" class="popup-main"> <div class="popup-heading"> <h2>What kind of Experience do you want to share?</h2> <div class="close-icon share-experience-modal-close"></div> </div>  <div class="experience-card"> <a class="exp-card5" href= "https://write.geeksforgeeks.org/posts-new?cid=e8fc46fe-75e7-4a4b-be3c-0c862d655ed0" target="_blank"> <div class="icon5"> <div class="icon5-image"></div> </div> <div class="exp-card5-text"> <span style="color: #000;">Interview Experiences</span> </div> </a> <a class="exp-card1" href="https://write.geeksforgeeks.org/posts-new?cid=82536bdb-84e6-4661-87c3-e77c3ac04ede" target="_blank"> <div class="icon1"> <div class="icon1-image"></div> </div> <div class="exp-card1-text"> <span style="color: #000;">Admission Experiences</span> </div> </a> <a class="exp-card6" href= "https://write.geeksforgeeks.org/posts-new?cid=5219b0b2-7671-40a0-9bda-503e28a61c31" target="_blank"> <div class="icon6"> <div class="icon6-image"></div> </div> <div class="exp-card6-text"> <span style="color: #000;">Career Journeys</span> </div> </a> <a class="exp-card2" href="https://write.geeksforgeeks.org/posts-new?cid=22ae3354-15b6-4dd4-a5b4-5c7a105b8a8f" target="_blank"> <div class="icon2"> <div class="icon2-image"></div> </div> <div class="exp-card2-text"> <span style="color: #000;">Work Experiences</span> </div> </a> <a class="exp-card3" href= "https://write.geeksforgeeks.org/posts-new?cid=c5e1ac90-9490-440a-a5fa-6180c87ab8ae" target="_blank"> <div class="icon3"> <div class="icon3-image"></div> </div> <div class="exp-card3-text"> <span style="color: #000;">Campus Experiences</span> </div> </a> <a class="exp-card4" href= "https://write.geeksforgeeks.org/posts-new?cid=5ebb8fe9-b980-4891-af07-f2d62a9735f2" target="_blank"> <div class="icon4"> <div class="icon4-image"></div> </div> <div class="exp-card4-text"> <span style="color: #000;">Competitive Exam Experiences</span> </div> </a> </div>  </div> <div id="overlay" onclick="toggleExperiencePopup()" style="display: block;min-height: 100vh;min-width: 100vw;position: fixed;top: 0;bottom: 0;right: 0;left: 0;display: none;justify-content: center;align-items: center;background: rgba(0,0,0,.702);z-index: 1025 !important;backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px);word-break: keep-all;"></div> </div> <script> $('.share-experience-modal').click(function(e){ e.preventDefault(); var link = $(this).attr('href'); toggleExperiencePopup(link); }); function toggleExperiencePopup(link) { var popup = document.getElementById("popup"); var overlay = document.getElementById("overlay"); if (window.innerWidth < 992) { window.location.href = link; } else { popup.style.display = (popup.style.display === "block") ? "none" : "block"; overlay.style.display = (overlay.style.display === "block") ? "none" : "block"; } } $('.share-experience-modal-close').click(function(e){ var popup = document.getElementById("popup"); popup.style.display = 'none'; var overlay = document.getElementById("overlay"); overlay.style.display = 'none'; }); </script> </div><script type="text/javascript"> $(window).on('load', function() { (function(c,l,a,r,i,t,y){ c[a]=c[a]||function(){(c[a].q=c[a].q||[]).push(arguments)}; t=l.createElement(r);t.async=1;t.src="https://www.clarity.ms/tag/"+i; y=l.getElementsByTagName(r)[0];y.parentNode.insertBefore(t,y); })(window, document, "clarity", "script", "ayc7ypwwuk"); }); </script>  </body> </html>

CINXE.COM

How to Create a Pivot Table in Excel: A Step-by-Step Guide