{"id":509,"date":"2020-05-04T06:47:21","date_gmt":"2020-05-03T22:47:21","guid":{"rendered":"https:\/\/membership.niat.edu.ph\/?post_type=product&#038;p=509"},"modified":"2023-02-15T16:31:37","modified_gmt":"2023-02-15T08:31:37","slug":"pc-ept","status":"publish","type":"product","link":"https:\/\/membership.niat.edu.ph\/?product=pc-ept","title":{"rendered":"Professional Certificate in Excel Pivot Table"},"content":{"rendered":"<h3><strong>Take the first step to get Professional Certificate in Excel Pivot Table<\/strong><\/h3>\n<p>Let&#8217;s face it: It can be hard to find time to learn new Excel techniques.\u00a0<strong>Our Streamlined Excel Reporting Series offers four sessions to quickly build your PivotTable skills.<\/strong>\u00a0You&#8217;ll get step-by-step demonstrations to create and use PivotTables to become a more productive and effective financial professional.<\/p>\n<p><strong>Once you&#8217;ve learned about the power of PivotTables, you&#8217;ll find them intuitive and invaluable in organizing and summarizing data.<\/strong>\u00a0The features, functions, and techniques presented in this series are sure to shave time off of your reporting tasks-and boost your ability to determine what&#8217;s most significant from your analysis.<\/p>\n<p><strong>Learning Objectives<\/strong><\/p>\n<ul>\n<li><strong>Create<\/strong>\u00a0a PivotTable reports<\/li>\n<li><strong>Identify<\/strong>\u00a0different PivotTable report layout areas<\/li>\n<li><strong>Explore<\/strong>\u00a0how to create financial monthly columns and how to properly format the values<\/li>\n<li>State the\u00a0<strong>process for displaying<\/strong>\u00a0PivotTable report values as percentage of the report total<\/li>\n<li><strong>Identify<\/strong>\u00a0the default sort order of a\u00a0pivot\u00a0table<\/li>\n<li><strong>Recall<\/strong>\u00a0three ways to filter a\u00a0pivot\u00a0table report<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;ve ever struggled to make sense of a wealth of data in an Excel spreadsheet, PivotTables can help.\u00a0<strong>A PivotTable allows you to manipulate and clarify what&#8217;s meaningful in your data<\/strong>\u00a0and then share what&#8217;s important in your spreadsheet-or data visualization.<\/p>\n<p><strong>Promo:<\/strong> 2799 + 30 (online charge) = 2,829<\/p>\n","protected":false},"featured_media":599,"template":"","meta":[],"product_brand":[],"product_cat":[21],"product_tag":[],"class_list":{"0":"post-509","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-niat-certification-programs","8":"first","9":"instock","10":"sale","11":"virtual","12":"purchasable","13":"product-type-simple"},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/membership.niat.edu.ph\/index.php?rest_route=\/wp\/v2\/product\/509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/membership.niat.edu.ph\/index.php?rest_route=\/wp\/v2\/product"}],"about":[{"href":"https:\/\/membership.niat.edu.ph\/index.php?rest_route=\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/membership.niat.edu.ph\/index.php?rest_route=\/wp\/v2\/media\/599"}],"wp:attachment":[{"href":"https:\/\/membership.niat.edu.ph\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=509"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/membership.niat.edu.ph\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_brand&post=509"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/membership.niat.edu.ph\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_cat&post=509"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/membership.niat.edu.ph\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_tag&post=509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}