{"id":39,"date":"2015-08-26T16:59:58","date_gmt":"2015-08-26T16:59:58","guid":{"rendered":"http:\/\/99excel.com\/?p=39"},"modified":"2021-05-14T16:09:22","modified_gmt":"2021-05-14T16:09:22","slug":"easy-to-use-pivottables","status":"publish","type":"post","link":"https:\/\/99excel.com\/home\/easy-to-use-pivottables\/","title":{"rendered":"Easy-to-use PivotTables"},"content":{"rendered":"<p style=\"text-align: justify;\">What&#8217;s new in Microsoft Office Excel 2007<!--csasset id=\"\" date=\"2006-07-26\" number=\"1\"--><!--cstransform awsenduserHXS.xsl date 2006-07-31 --><!-- csautotext date 2006-09-28 number --><!-- csglossary date 2006-09-28 number --><!-- csglobalstrings date 2006-09-22 number --><script src=\"office12.js\" type=\"text\/javascript\"><\/script><script>\/\/ <![CDATA[\nvar strShow='Show All'; var strHide='Hide All'; var strRtl=''; var L_UNDEFINED_TEXT='Help could not locate this inline definition';\n\/\/ ]]><\/script><noscript><\/noscript><script>\/\/ <![CDATA[\nfunction go(url) { window.open(url, \"_self\"); } function OpenInNewWindow(url) { go(url); }\n\/\/ ]]><\/script><script type=\"text\/JavaScript\">\/\/ <![CDATA[\nfunction InlineDefNotFound() { alert(L_UNDEFINED_TEXT); } function AppendPopup(oSource, sPopup) { InitializeGlobalData(); if (typeof(allDivsInPage) == 'undefined' || null == allDivsInPage) return; var theDiv = allDivsInPage['divInlineDef_' + sPopup]; if (typeof(theDiv) == 'undefined' || null == theDiv) { InlineDefNotFound(); return; } if (theDiv.style.display.toUpperCase() != 'INLINE') theDiv.style.display = 'inline'; else theDiv.style.display = 'none'; }\n\/\/ ]]><\/script><\/p>\n<div class=\"cdclvSection\">\n<div class=\"cntArticleBody\">\n<p style=\"text-align: justify;\">In Office Excel 2007, PivotTables are much easier to use than in earlier versions of Excel. By using the new PivotTable user interface, the information that you want to view about your data is just a few clicks away\u2014you no longer have to drag data to drop zones that aren&#8217;t always an easy target. Instead, you can simply select the fields that you want to see in a new PivotTable field list.<\/p>\n<p style=\"text-align: justify;\">And after you create a PivotTable, you can take advantage of many other new or improved features to summarize, analyze, and format your PivotTable data.<\/p>\n<p style=\"text-align: justify;\"><b class=\"runinhead\">Using Undo in PivotTables<\/b>\u00a0\u00a0 You can now undo most actions that you take to create or rearrange a PivotTable.<\/p>\n<p style=\"text-align: justify;\"><b class=\"runinhead\">Plus and minus drill-down indicators<\/b>\u00a0\u00a0 These indicators are used to indicate whether you can expand or collapse parts of the PivotTable to see more or less information.<\/p>\n<p style=\"text-align: justify;\"><b class=\"runinhead\">Sorting and filtering<\/b>\u00a0\u00a0 Sorting is now as simple as selecting an item in the column that you want to sort and using sort buttons. You can filter data by using PivotTable filters, such as Greater than, Equals, or Contains.<\/p>\n<p style=\"text-align: justify;\"><b class=\"runinhead\">Conditional formatting<\/b>\u00a0\u00a0 You can apply conditional formatting to an Office Excel 2007 Pivot Table by cell or by intersection of cells.<\/p>\n<p style=\"text-align: justify;\"><b class=\"runinhead\">PivotTable style and layout<\/b>\u00a0\u00a0 Just like you can for Excel tables and charts, you can quickly apply a predefined or custom style to a PivotTable. And changing the layout of a PivotTable is also much easier to do in the new user interface.<\/p>\n<p style=\"text-align: justify;\"><b class=\"runinhead\">PivotCharts<\/b>\u00a0\u00a0 Like PivotTables, PivotCharts are much easier to create in the new user interface. All of the filtering improvements are also available for PivotCharts. When you create a PivotChart, specific PivotChart tools and context menus are available so that you can analyze the data in the chart. You can also change the layout, style, and format of the chart or its elements the same way that you can for a regular chart. In Office Excel 2007, the chart formatting that you apply is preserved when you make changes to the PivotChart, which is an improvement over the way it worked in earlier versions of Excel.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>What&#8217;s new in Microsoft Office Excel 2007 In Office Excel 2007, PivotTables are much easier to use than in earlier versions of Excel. By using the new PivotTable user interface, the information that you want to view about your data is just a few clicks away\u2014you no longer have to drag data to drop zones &#8230; <a title=\"Easy-to-use PivotTables\" class=\"read-more\" href=\"https:\/\/99excel.com\/home\/easy-to-use-pivottables\/\" aria-label=\"More on Easy-to-use PivotTables\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":1,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/39\/revisions"}],"predecessor-version":[{"id":901,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/39\/revisions\/901"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/categories?post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/tags?post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}