{"id":402,"date":"2011-04-28T09:56:15","date_gmt":"2011-04-28T09:56:15","guid":{"rendered":"http:\/\/www.yourhrworld.com\/formats\/?p=402"},"modified":"2011-05-06T11:50:31","modified_gmt":"2011-05-06T11:50:31","slug":"pivot-table","status":"publish","type":"post","link":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/","title":{"rendered":"Pivot Table"},"content":{"rendered":"<p><strong>Pivot Table<\/strong> is used to Fetch the Data according to our use or format as  which column we need we can easily sort out, (Example &#8211; if the employee  working for 12 hours daily and the total days he work for 15 days, the  the total will come in last column, so to see only empid and total hour  work, we can easily see through Pivot Table)<\/p><div class=\"69eb924294c115e6505da44099e8df92\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script type=\"text\/javascript\"><!--\r\ngoogle_ad_client = \"pub-0867779017855679\";\r\n\/* 300x250, created 4\/20\/11 *\/\r\ngoogle_ad_slot = \"1035864135\";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n\/\/-->\r\n<\/script>\r\n<script type=\"text\/javascript\"\r\nsrc=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\r\n<\/script>\n<\/div>\n\n<p><strong>Steps &#8211;<\/strong><\/p>\n<p>1, Select new sheet or existing,<br \/>\n2, Go to Insert Option<br \/>\n3, Select Pivot Table<br \/>\n4, Then the dialog box open with some formula&#8217;s type just click on ok,  then one pop open with our sheet field names, then you need to slect  exact with column u need to sort out the date.<\/p>\n<p>5, Click on check box for needed column, then ok..<\/p>\n<p>Attached is the sample excel sheet for same.<\/p>\n<p><strong><a href=\"https:\/\/www.yourhrworld.com\/formats\/wp-content\/uploads\/2011\/04\/Sample-Pivot-Table-Timesheet.xls\">Click Here To Download Sample Pivot Table -Timesheet<\/a><\/strong><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Pivot Table is used to Fetch the Data according to our use or format as which column we need we can easily sort out, (Example &#8211; if the employee working for 12 hours daily and the total days he work for 15 days, the the total will come in last column, so to see only empid and total hour work, we can easily see through Pivot Table) Steps &#8211; 1, Select new sheet or existing, 2, Go to Insert Option 3, Select Pivot Table 4, Then the dialog box open with some formula&#8217;s type just click on ok, then one<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45],"tags":[119],"class_list":["post-402","post","type-post","status-publish","format-standard","hentry","category-hr","tag-pivot-table"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Pivot Table  - HR Letter Formats<\/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.yourhrworld.com\/formats\/hr\/pivot-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot Table  - HR Letter Formats\" \/>\n<meta property=\"og:description\" content=\"Pivot Table is used to Fetch the Data according to our use or format as which column we need we can easily sort out, (Example &#8211; if the employee working for 12 hours daily and the total days he work for 15 days, the the total will come in last column, so to see only empid and total hour work, we can easily see through Pivot Table) Steps &#8211; 1, Select new sheet or existing, 2, Go to Insert Option 3, Select Pivot Table 4, Then the dialog box open with some formula&#8217;s type just click on ok, then one\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/\" \/>\n<meta property=\"og:site_name\" content=\"HR Letter Formats\" \/>\n<meta property=\"article:published_time\" content=\"2011-04-28T09:56:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-05-06T11:50:31+00:00\" \/>\n<meta name=\"author\" content=\"Hrformats\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hrformats\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/\"},\"author\":{\"name\":\"Hrformats\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\"},\"headline\":\"Pivot Table\",\"datePublished\":\"2011-04-28T09:56:15+00:00\",\"dateModified\":\"2011-05-06T11:50:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/\"},\"wordCount\":144,\"commentCount\":0,\"keywords\":[\"Pivot Table\"],\"articleSection\":[\"HR\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/\",\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/\",\"name\":\"Pivot Table - HR Letter Formats\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#website\"},\"datePublished\":\"2011-04-28T09:56:15+00:00\",\"dateModified\":\"2011-05-06T11:50:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/pivot-table\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pivot Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#website\",\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/\",\"name\":\"HR Letter Formats\",\"description\":\"Free Human Resource Forms, Formats &amp; Questionnaires\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\",\"name\":\"Hrformats\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"caption\":\"Hrformats\"},\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/author\\\/hrformats\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pivot Table  - HR Letter Formats","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.yourhrworld.com\/formats\/hr\/pivot-table\/","og_locale":"en_US","og_type":"article","og_title":"Pivot Table  - HR Letter Formats","og_description":"Pivot Table is used to Fetch the Data according to our use or format as which column we need we can easily sort out, (Example &#8211; if the employee working for 12 hours daily and the total days he work for 15 days, the the total will come in last column, so to see only empid and total hour work, we can easily see through Pivot Table) Steps &#8211; 1, Select new sheet or existing, 2, Go to Insert Option 3, Select Pivot Table 4, Then the dialog box open with some formula&#8217;s type just click on ok, then one","og_url":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/","og_site_name":"HR Letter Formats","article_published_time":"2011-04-28T09:56:15+00:00","article_modified_time":"2011-05-06T11:50:31+00:00","author":"Hrformats","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hrformats","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/#article","isPartOf":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/"},"author":{"name":"Hrformats","@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee"},"headline":"Pivot Table","datePublished":"2011-04-28T09:56:15+00:00","dateModified":"2011-05-06T11:50:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/"},"wordCount":144,"commentCount":0,"keywords":["Pivot Table"],"articleSection":["HR"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/","url":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/","name":"Pivot Table - HR Letter Formats","isPartOf":{"@id":"https:\/\/www.yourhrworld.com\/formats\/#website"},"datePublished":"2011-04-28T09:56:15+00:00","dateModified":"2011-05-06T11:50:31+00:00","author":{"@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee"},"breadcrumb":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/pivot-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yourhrworld.com\/formats\/"},{"@type":"ListItem","position":2,"name":"Pivot Table"}]},{"@type":"WebSite","@id":"https:\/\/www.yourhrworld.com\/formats\/#website","url":"https:\/\/www.yourhrworld.com\/formats\/","name":"HR Letter Formats","description":"Free Human Resource Forms, Formats &amp; Questionnaires","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yourhrworld.com\/formats\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee","name":"Hrformats","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","caption":"Hrformats"},"url":"https:\/\/www.yourhrworld.com\/formats\/author\/hrformats\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts\/402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/comments?post=402"}],"version-history":[{"count":0,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts\/402\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/media?parent=402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/categories?post=402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/tags?post=402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}