\n| 2026-05-09<\/td>\n | Hubballi<\/td>\n | Hubballi<\/td>\n | Saree<\/td>\n | 15<\/td>\n | 52500<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n The real sheet has 9,000 rows. Before you build anything, select the data and press Ctrl and T to turn it into an Excel Table. This takes ten seconds and prevents the single most common pivot table failure, covered further down.<\/p>\n Build one in four clicks<\/h2>\n\n\n\n| Step<\/th>\n | What to click<\/th>\n | What happens<\/th>\n<\/tr>\n<\/thead>\n | \n\n| 1<\/td>\n | Any cell inside the data<\/td>\n | Excel works out the range for you<\/td>\n<\/tr>\n | \n| 2<\/td>\n | Insert ribbon, PivotTable, From Table\/Range<\/td>\n | A dialog appears with the detected range filled in<\/td>\n<\/tr>\n | \n| 3<\/td>\n | New Worksheet, then OK<\/td>\n | A blank pivot and the PivotTable Fields pane appear<\/td>\n<\/tr>\n | \n| 4<\/td>\n | Tick or drag fields in that pane<\/td>\n | The pivot fills in as you go<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n The PivotTable Fields pane has your column names listed at the top and four empty boxes underneath: Filters, Columns, Rows and Values. Dragging a field name into one of those boxes is the entire interface.<\/p>\n The four areas and what each one does<\/h2>\n\n\n\n| Area<\/th>\n | What goes here<\/th>\n | What it produces<\/th>\n | Example from this sheet<\/th>\n<\/tr>\n<\/thead>\n | \n\n| Rows<\/td>\n | Fields you want listed down the left<\/td>\n | One row per distinct value<\/td>\n | store<\/td>\n<\/tr>\n | \n| Columns<\/td>\n | A field with only a few distinct values<\/td>\n | One column per value<\/td>\n | category<\/td>\n<\/tr>\n | \n| Values<\/td>\n | The numbers being aggregated<\/td>\n | Sums, counts, averages<\/td>\n | revenue<\/td>\n<\/tr>\n | \n| Filters<\/td>\n | A field that filters the whole table<\/td>\n | A dropdown above the pivot<\/td>\n | city<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Drag store into Rows and revenue into Values and you get this:<\/p>\n \n\n\n| Store<\/th>\n | Sum of revenue<\/th>\n<\/tr>\n<\/thead>\n | \n\n| Hubballi<\/td>\n | \u20b952,500<\/td>\n<\/tr>\n | \n| Indiranagar<\/td>\n | \u20b961,800<\/td>\n<\/tr>\n | \n| Jayanagar<\/td>\n | \u20b946,500<\/td>\n<\/tr>\n | \n| Mysuru<\/td>\n | \u20b919,200<\/td>\n<\/tr>\n | \n| Grand Total<\/td>\n | \u20b91,80,000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Add category to Columns and the same figures split into a grid, four stores down the side and three categories across the top. That is the pivot, and it is where the name comes from: the same numbers, rotated.<\/p>\n One rule about Columns. Put a field with 60 distinct values there and you get 60 columns nobody can read. Fields with two to eight values belong in Columns; everything else belongs in Rows.<\/p>\n Changing what Values calculates<\/h2>\nExcel defaults to Sum for numeric fields. To change it, click the field in the Values box, choose Value Field Settings, and pick from Sum, Count, Average, Max, Min, Product, StdDev or Var. Distinct Count also appears, but only if you ticked “Add this data to the Data Model” when creating the pivot.<\/p>\n The same dialog has a Number Format button. Use it. Formatting the pivot cells directly with the ribbon works until the next refresh, at which point the formatting disappears; formatting set through Value Field Settings sticks to the field permanently.<\/p>\n Show Values As: the percentages people rebuild by hand<\/h2>\nRight-click any value cell, choose Show Values As, and Excel recalculates the whole column as a share, a difference or a running total. Most people compute these in helper columns without knowing this menu exists.<\/p>\n \n\n\n| Option<\/th>\n | What it shows<\/th>\n | Use it when<\/th>\n<\/tr>\n<\/thead>\n | \n\n| % of Grand Total<\/td>\n | Each cell as a share of the total<\/td>\n | Working out each store’s contribution<\/td>\n<\/tr>\n | \n| % of Column Total<\/td>\n | Each cell as a share of its own column<\/td>\n | Comparing category mix across stores<\/td>\n<\/tr>\n | \n| Difference From<\/td>\n | Movement against a chosen item<\/td>\n | Month-on-month change in rupees<\/td>\n<\/tr>\n | \n| % Difference From<\/td>\n | That movement as a percentage<\/td>\n | Month-on-month growth rate<\/td>\n<\/tr>\n | \n| Running Total In<\/td>\n | A cumulative total down the field<\/td>\n | Revenue to date through the year<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Add revenue to the Values area twice, leave the first as Sum and set the second to % of Grand Total, and you have amount and share side by side in one table.<\/p>\n Grouping dates, numbers and text<\/h2>\nDrag order_date into Rows and recent versions of Excel group it into months and years automatically, adding a Years field of their own. To control it yourself, right-click any date in the pivot, choose Group, then tick Months and Years together. Ticking Months alone merges April 2025 and April 2026 into a single row, which is a real error people ship in board decks.<\/p>\n Numbers group the same way. Right-click a numeric row field, choose Group, and set Starting at, Ending at and By to create bands: units grouped by 10 turns a long list of order sizes into a handful of readable bands.<\/p>\n Text has no automatic grouping, but you can select several row items, right-click, choose Group and rename the result. Grouping Indiranagar and Jayanagar into “Bengaluru stores” takes seconds.<\/p>\n If Excel refuses with “Cannot group that selection”, the cause is nearly always one of two things: the date column is stored as text, or there is a blank cell in the field. Fix the source, refresh, and try again.<\/p>\n Slicers and timelines<\/h2>\nA slicer is a box of clickable buttons that filters the pivot. Insert ribbon, Slicer, tick the field, and you get a panel of store names or categories that anyone can use without touching the field list. A timeline does the same for dates, with a sliding bar that filters by month, quarter or year: Insert ribbon, Timeline, and it accepts date fields only.<\/p>\n Slicers become genuinely useful when one slicer drives several pivots at once. Right-click the slicer, choose Report Connections, and tick every pivot table you want it to control. All of them must be built on the same source for this to work.<\/p>\n Calculated fields and the formulas around a pivot<\/h2>\nA calculated field adds a new field computed from the existing ones: PivotTable Analyze ribbon, Fields, Items and Sets, then Calculated Field. The formula uses field names, never cell references. The table below shows the syntax for that and for the worksheet formulas that work alongside a pivot.<\/p>\n \n\n\n| Formula<\/th>\n | What it does<\/th>\n | Syntax<\/th>\n | Example<\/th>\n<\/tr>\n<\/thead>\n | \n\n| Calculated field<\/td>\n | Adds a field computed from other fields inside the pivot<\/td>\n | Field1 \/ Field2, using field names<\/td>\n | revenue \/ units<\/td>\n<\/tr>\n | \n| GETPIVOTDATA<\/td>\n | Pulls one value out of a pivot by field and item<\/td>\n | GETPIVOTDATA(value field, pivot cell, field, item)<\/td>\n | GETPIVOTDATA(“revenue”, $A$3, “store”, “Jayanagar”)<\/td>\n<\/tr>\n | \n| SUMIFS<\/td>\n | Sums a range where several conditions hold, outside a pivot<\/td>\n | SUMIFS(sum range, range1, criteria1, range2, criteria2)<\/td>\n | SUMIFS(F2:F500, B2:B500, “Jayanagar”, D2:D500, “Denim”)<\/td>\n<\/tr>\n | \n| SUBTOTAL<\/td>\n | Aggregates only the visible rows, ignoring filtered-out ones<\/td>\n | SUBTOTAL(function number, range)<\/td>\n | SUBTOTAL(109, F2:F500)<\/td>\n<\/tr>\n | \n| UNIQUE<\/td>\n | Lists distinct values, for a formula-driven summary instead<\/td>\n | UNIQUE(range)<\/td>\n | UNIQUE(B2:B500)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n There is a trap in calculated fields worth understanding before you use one. Excel applies your formula to the totals, not to each row. A field defined as revenue divided by units gives the total revenue divided by the total units, which is the correct blended price per unit. But if the sheet also carried a unit_price column, a field defined as units multiplied by unit_price would return total units multiplied by the sum of every price on the sheet, a meaningless number that looks plausible. Ratios are safe; products are not.<\/p>\n GETPIVOTDATA appears on its own whenever you click a pivot cell while writing a formula. If you wanted a plain cell reference instead, switch it off at PivotTable Analyze, the Options dropdown, Generate GetPivotData.<\/p>\n Refreshing, and why your pivot is out of date<\/h2>\nA pivot table does not update itself. Add yesterday’s orders to the sheet and the pivot keeps showing the old totals until you refresh it: Alt and F5 for one pivot, Ctrl and Alt and F5 for every pivot in the workbook. To make it automatic, right-click the pivot, choose PivotTable Options, open the Data tab and tick “Refresh data when opening the file”.<\/p>\n Refreshing is not enough if the source range itself is stale. A pivot built on a fixed range keeps looking at exactly those cells, so rows added underneath never appear no matter how often you refresh. This is why the Ctrl and T step at the start matters: a pivot built on an Excel Table follows the table as it grows. If you skipped it, repoint the pivot at PivotTable Analyze, Change Data Source.<\/p>\n The mistakes that produce wrong numbers<\/h2>\nA source range frozen at its original size.<\/strong> The most common of all, and the most dangerous, because the pivot still returns a number. It is just last month’s number.<\/p>\nCount where you meant Sum.<\/strong> Excel switches to Count when a numeric column contains text or blank cells. Seeing “Count of revenue” at the top of a column means Excel found something non-numeric in it; fix the source data rather than overriding the setting.<\/p>\nAveraging an average.<\/strong> The average of four store averages is not the average across all orders, unless every store sold exactly the same number of orders. For a blended figure, build it as total revenue divided by total units in a calculated field.<\/p>\nFormatting cells rather than the field.<\/strong> Applied through the ribbon, the rupee symbol and digit grouping vanish on the next refresh. Set number format inside Value Field Settings instead.<\/p>\nA messy source sheet.<\/strong> Pivot tables need one header row, no merged cells, no blank columns inside the range, and one kind of thing per column. Merged cells in particular produce field names like Column1 and a pivot nobody can use.<\/p>\nWhen a pivot table stops being the right tool<\/h2>\nPivot tables slow down well before the sheet limit of just over 10 lakh rows, and they summarise one table at a time. The moment you need to combine an orders sheet with a store master sheet, you are into the Data Model and relationships, which is Power Pivot rather than a plain pivot table.<\/p>\n The other signal is repetition. If the same summary has to be produced every Monday from a fresh export, the cleaning belongs in Power Query and the reporting belongs in Power BI, where the steps replay by themselves. Pivot tables are for exploring data quickly, and they are excellent at it. They are a poor foundation for a report somebody else depends on every week.<\/p>\n Frequently asked questions<\/h2>\nWhat is a pivot table in Excel used for?<\/h3>\nA pivot table summarises a large list into a compact table by grouping rows on the fields you choose and aggregating the numbers. It answers questions like revenue by store, orders by month, or average order value by category, without writing a single formula. It is the fastest way to explore a dataset you have not seen before.<\/p>\n How do I create a pivot table in Excel?<\/h3>\nClick any cell inside your data, go to the Insert ribbon, choose PivotTable, then From Table\/Range, and confirm New Worksheet. Excel creates an empty pivot with the PivotTable Fields pane on the right, where you drag field names into the Rows, Columns, Values and Filters boxes. Turning the source into an Excel Table with Ctrl and T first is worth the extra ten seconds.<\/p>\n Why does my pivot table show Count instead of Sum?<\/h3>\nExcel defaults to Count whenever the column you dropped into Values contains text or blank cells anywhere in the range, because it cannot add up something that is not a number. The usual culprits are a stray note typed into a numeric column, or numbers stored as text after a system export. Clean the source column, refresh, and it will switch to Sum on its own.<\/p>\n Why is my pivot table not showing new data?<\/h3>\nTwo separate reasons, and both are common. A pivot table never refreshes automatically, so new rows do not appear until you press Alt and F5 or use Refresh All. Even after refreshing, rows added below the original range are ignored unless the pivot is built on an Excel Table or you repoint it with Change Data Source.<\/p>\n Can a pivot table use data from more than one sheet?<\/h3>\nYes, but not as a plain pivot table. Tick “Add this data to the Data Model” when you create the pivot, add the second table to the model as well, then define a relationship between them on a shared key such as store. This is Power Pivot underneath, and it is also what gives you Distinct Count in the Value Field Settings list.<\/p>\n Do data analysts still use pivot tables?<\/h3>\nConstantly, for quick exploration and for checking a result before it goes anywhere else. Recurring reports move to SQL and Power BI because those refresh on their own, but a pivot table remains the quickest way to interrogate a fresh extract. Pivot table questions also come up in nearly every entry-level analyst interview.<\/p>\n Learn Excel to the depth the job needs<\/h2>\nPivot tables are one chapter of Excel. The parts that make an analyst useful are the ones underneath: clean source data, lookups across sheets, Power Query for the cleaning that repeats, and knowing when to stop using Excel altogether.<\/p>\n SkilloVilla’s Excel: Beginner to Advanced course<\/a> covers pivot tables, pivot charts and Power Pivot with live teaching and mentor support, at \u20b933,110. If you want Excel as one part of an analytics path rather than on its own, the Data Analytics with Python track<\/a> is \u20b971,999, currently \u20b958,999 and adds SQL, Python, Power BI and placement support over 4 to 5 months, with scholarships depending on profile.<\/p>\nFees and ratings last checked August 2026; confirm current numbers with the provider before enrolling.<\/p>\n","protected":false},"excerpt":{"rendered":" How to build a pivot table in Excel: the four field areas, grouping, slicers, calculated fields and the mistakes that produce wrong totals.<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[200],"tags":[],"class_list":["post-3879","post","type-post","status-publish","format-standard","hentry","category-data-analytics"],"yoast_head":"\n Pivot Tables in Excel: Complete Guide With Examples<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot Tables in Excel: Complete Guide With Examples\" \/>\n<meta property=\"og:description\" content=\"How to build a pivot table in Excel: the four field areas, grouping, slicers, calculated fields and the mistakes that produce wrong totals.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel\" \/>\n<meta property=\"og:site_name\" content=\"SkilloVilla\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-16T19:04:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-16T19:04:28+00:00\" \/>\n<meta name=\"author\" content=\"SkilloVilla Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SkilloVilla Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel\"},\"author\":{\"name\":\"SkilloVilla Team\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/person\/f64a2675b6d238b7e44744a87e5c4943\"},\"headline\":\"Pivot Tables in Excel: Complete Guide With Examples\",\"datePublished\":\"2026-09-16T19:04:05+00:00\",\"dateModified\":\"2026-09-16T19:04:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel\"},\"wordCount\":2302,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#organization\"},\"articleSection\":[\"Data analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel\",\"url\":\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel\",\"name\":\"Pivot Tables in Excel: Complete Guide With Examples\",\"isPartOf\":{\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#website\"},\"datePublished\":\"2026-09-16T19:04:05+00:00\",\"dateModified\":\"2026-09-16T19:04:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.skillovilla.com\/blogs\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pivot Tables in Excel: Complete Guide With Examples\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#website\",\"url\":\"https:\/\/www.skillovilla.com\/blogs\/\",\"name\":\"SkilloVilla\",\"description\":\"Data careers, taught live\",\"publisher\":{\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.skillovilla.com\/blogs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#organization\",\"name\":\"SkilloVilla\",\"url\":\"https:\/\/www.skillovilla.com\/blogs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.skillovilla.com\/blogs\/wp-content\/uploads\/2021\/07\/logo-thumbnail.png\",\"contentUrl\":\"https:\/\/www.skillovilla.com\/blogs\/wp-content\/uploads\/2021\/07\/logo-thumbnail.png\",\"width\":1200,\"height\":627,\"caption\":\"SkilloVilla\"},\"image\":{\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/person\/f64a2675b6d238b7e44744a87e5c4943\",\"name\":\"SkilloVilla Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5e0b6f9e8405f5d6fc302700051e351ffa38fb1cf2709a0cb4e96b5622c497d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5e0b6f9e8405f5d6fc302700051e351ffa38fb1cf2709a0cb4e96b5622c497d0?s=96&d=mm&r=g\",\"caption\":\"SkilloVilla Team\"},\"url\":\"https:\/\/www.skillovilla.com\/blogs\/author\/sankalp_agarwal\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pivot Tables in Excel: Complete Guide With Examples","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel","og_locale":"en_US","og_type":"article","og_title":"Pivot Tables in Excel: Complete Guide With Examples","og_description":"How to build a pivot table in Excel: the four field areas, grouping, slicers, calculated fields and the mistakes that produce wrong totals.","og_url":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel","og_site_name":"SkilloVilla","article_published_time":"2026-09-16T19:04:05+00:00","article_modified_time":"2026-09-16T19:04:28+00:00","author":"SkilloVilla Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"SkilloVilla Team","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel#article","isPartOf":{"@id":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel"},"author":{"name":"SkilloVilla Team","@id":"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/person\/f64a2675b6d238b7e44744a87e5c4943"},"headline":"Pivot Tables in Excel: Complete Guide With Examples","datePublished":"2026-09-16T19:04:05+00:00","dateModified":"2026-09-16T19:04:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel"},"wordCount":2302,"commentCount":0,"publisher":{"@id":"https:\/\/www.skillovilla.com\/blogs\/#organization"},"articleSection":["Data analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel","url":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel","name":"Pivot Tables in Excel: Complete Guide With Examples","isPartOf":{"@id":"https:\/\/www.skillovilla.com\/blogs\/#website"},"datePublished":"2026-09-16T19:04:05+00:00","dateModified":"2026-09-16T19:04:28+00:00","breadcrumb":{"@id":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.skillovilla.com\/blogs\/pivot-tables-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skillovilla.com\/blogs"},{"@type":"ListItem","position":2,"name":"Pivot Tables in Excel: Complete Guide With Examples"}]},{"@type":"WebSite","@id":"https:\/\/www.skillovilla.com\/blogs\/#website","url":"https:\/\/www.skillovilla.com\/blogs\/","name":"SkilloVilla","description":"Data careers, taught live","publisher":{"@id":"https:\/\/www.skillovilla.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skillovilla.com\/blogs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skillovilla.com\/blogs\/#organization","name":"SkilloVilla","url":"https:\/\/www.skillovilla.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.skillovilla.com\/blogs\/wp-content\/uploads\/2021\/07\/logo-thumbnail.png","contentUrl":"https:\/\/www.skillovilla.com\/blogs\/wp-content\/uploads\/2021\/07\/logo-thumbnail.png","width":1200,"height":627,"caption":"SkilloVilla"},"image":{"@id":"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/person\/f64a2675b6d238b7e44744a87e5c4943","name":"SkilloVilla Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skillovilla.com\/blogs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5e0b6f9e8405f5d6fc302700051e351ffa38fb1cf2709a0cb4e96b5622c497d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e0b6f9e8405f5d6fc302700051e351ffa38fb1cf2709a0cb4e96b5622c497d0?s=96&d=mm&r=g","caption":"SkilloVilla Team"},"url":"https:\/\/www.skillovilla.com\/blogs\/author\/sankalp_agarwal"}]}},"_links":{"self":[{"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/posts\/3879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/comments?post=3879"}],"version-history":[{"count":1,"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/posts\/3879\/revisions"}],"predecessor-version":[{"id":3880,"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/posts\/3879\/revisions\/3880"}],"wp:attachment":[{"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/media?parent=3879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/categories?post=3879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skillovilla.com\/blogs\/wp-json\/wp\/v2\/tags?post=3879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | | | | | |