{"id":24504,"date":"2021-11-03T12:12:12","date_gmt":"2021-11-03T11:12:12","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24504"},"modified":"2024-02-06T15:49:29","modified_gmt":"2024-02-06T14:49:29","slug":"new-pivot-table-features-in-excel-2019-and-office-365","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/new-pivot-table-features-in-excel-2019-and-office-365\/","title":{"rendered":"New Pivot Table Features in Excel 2019 and Office 365"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-Features-in-Pivot-Table.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-25131\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-Features-in-Pivot-Table.png\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-Features-in-Pivot-Table.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-Features-in-Pivot-Table-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-Features-in-Pivot-Table-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>The best thing with <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a> is that <strong>more features<\/strong> are getting added with Excel updates. I will give you my top 4 picks on the new <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> features that can be used in Excel 2019 and Office 365:<\/p>\n<ul>\n<li>Personalize the Default Pivot Table Layout<\/li>\n<li>Automatic Relationship detection<\/li>\n<li>Automatic Time Grouping<\/li>\n<li>Search In The Pivot Table Fields List<\/li>\n<\/ul>\n<p><em><strong>Exercise Workbook:<\/strong><\/em><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-Pivot-Table-Features-in-Excel-2019-and-Office-365.zip\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-Pivot-Table-Features-in-Excel-2019-and-Office-365.zip\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">New-Pivot-Table-Features-in-Excel-2019-and-Office-365.zip<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<hr \/>\n<p>Let us go over these features one by one!<\/p>\n<h3>Personalize the Default Pivot Table Layout<\/h3>\n<p>This is the default pivot table layout. The cool thing is we can make changes to this so that all future pivot tables that you create will use that same layout.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24601\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-01.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"731\" height=\"505\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-01.jpg 731w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-01-300x207.jpg 300w\" sizes=\"(max-width: 731px) 100vw, 731px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Go to\u00a0<strong>File &gt; Options<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24602\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-02.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"146\" height=\"181\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Select\u00a0<strong>Data &gt; Data options &gt; Edit Default Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24603\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-03.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"826\" height=\"678\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-03.jpg 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-03-300x246.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-03-768x630.jpg 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Let us have some fun! Try out the following:<\/p>\n<ul>\n<li><strong>Subtotals<\/strong> &#8211; Show all Subtotals at Bottom of Group<\/li>\n<li><strong>Report Layout<\/strong> &#8211; Show in Tabular Form<\/li>\n<li><strong>Blank Rows<\/strong> &#8211; Tick Insert Blank Line after Each Item<\/li>\n<\/ul>\n<p>You can explore more options inside\u00a0<strong>PivotTable Options<\/strong>. Click\u00a0<strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24604\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-04.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"437\" height=\"297\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-04.jpg 437w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-04-300x204.jpg 300w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Let us insert a new Pivot Table to see our new default layout!<\/p>\n<p>Open our data table. Go to <em><strong>Insert &gt; Tables &gt; PivotTable<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24605\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-05.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"1049\" height=\"682\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-05.jpg 1049w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-05-300x195.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-05-1024x666.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-05-768x499.jpg 768w\" sizes=\"(max-width: 1049px) 100vw, 1049px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> Click <strong>OK<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24606\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-06.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"388\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-06.jpg 388w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-06-300x268.jpg 300w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Setup the following:<\/p>\n<ul>\n<li>Columns &#8211; Order Date<\/li>\n<li>Rows &#8211; Customer, Products<\/li>\n<li>Values &#8211; Sales<\/li>\n<\/ul>\n<p>And you will now see the new layout!\u00a0<strong>Products\u00a0<\/strong>column is in a separate column. The <strong>subtotals<\/strong> are now at the bottom of each group, and there is an <strong>empty row<\/strong> after each item!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24607\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-07.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"873\" height=\"610\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-07.jpg 873w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-07-300x210.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-07-768x537.jpg 768w\" sizes=\"(max-width: 873px) 100vw, 873px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>Automatic Relationship detection<\/h3>\n<p>We have 3 data tables that are related to each other: <strong>Product<\/strong>,\u00a0<strong>Customer\u00a0<\/strong>and <strong>Sales<\/strong><\/p>\n<p>What connects these tables together are related columns, you will see the following:<\/p>\n<ul>\n<li><strong>Product <\/strong>table<strong> &#8211; Product Key<\/strong><\/li>\n<li><strong>Customer\u00a0<\/strong>table &#8211;\u00a0<strong>Customer Number<\/strong><\/li>\n<li><strong>Sales\u00a0<\/strong>table &#8211;\u00a0<strong>Product Key, Customer Number<\/strong><\/li>\n<\/ul>\n<p>To better understand how the data model and relationships work for Pivot Tables, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/data-model-and-relationships-in-microsoft-excel-pivot-tables\/\" target=\"_blank\">make sure to read this first.<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24608\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-08.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"431\" height=\"516\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-08.jpg 431w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-08-251x300.jpg 251w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24609\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-09.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"667\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-09.jpg 667w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-09-300x230.jpg 300w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24610\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-10.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"523\" height=\"505\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-10.jpg 523w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-10-300x290.jpg 300w\" sizes=\"(max-width: 523px) 100vw, 523px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> The cool thing is once we add this to our data model, Excel is able to auto-detect the relationships when we work on the Pivot Table.<\/p>\n<p>Select anywhere in one of our data tables. Go to <em><strong>Insert &gt; Tables &gt; PivotTable<\/strong><\/em><\/p>\n<p>Make sure\u00a0<strong>Add this data to the Data Model\u00a0<\/strong>is ticked.\u00a0Click <strong>OK<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24611\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-11.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"883\" height=\"684\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-11.jpg 883w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-11-300x232.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-11-768x595.jpg 768w\" sizes=\"(max-width: 883px) 100vw, 883px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> You will see that all of the tables are added to the data model. Select\u00a0<strong>All<\/strong> and you will see all 3 tables are listed there.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24612\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-12.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"260\" height=\"550\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-12.jpg 260w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-12-142x300.jpg 142w\" sizes=\"(max-width: 260px) 100vw, 260px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Let us see how Excel works its magic! Setup the following:<\/p>\n<ul>\n<li>Columns &#8211;\u00a0<strong>Product Name<\/strong><\/li>\n<li>Values &#8211;\u00a0<strong>Sale Amount<\/strong><\/li>\n<\/ul>\n<p>Click\u00a0<strong>Auto-Detect<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24613\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-13.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"329\" height=\"728\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-13.jpg 329w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-13-136x300.jpg 136w\" sizes=\"(max-width: 329px) 100vw, 329px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Select\u00a0<strong>Manage Relationships\u00a0<\/strong>to see what was created automatically<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24614\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-14.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"616\" height=\"157\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-14.jpg 616w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-14-300x76.jpg 300w\" sizes=\"(max-width: 616px) 100vw, 616px\" \/><\/p>\n<p>Click\u00a0<strong>Edit<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24615\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-15.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"686\" height=\"393\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-15.jpg 686w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-15-300x172.jpg 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> This is cool as the relationship between\u00a0<strong>Sales\u00a0<\/strong>and <strong>Product\u00a0<\/strong><strong>tables\u00a0<\/strong>is correct! Excel is able to link these tables together via the <strong>Product<\/strong> <strong>Key<\/strong> columns. Click <strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24616\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-16.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"682\" height=\"205\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-16.jpg 682w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-16-300x90.jpg 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Now setup the following:<\/p>\n<ul>\n<li>Rows &#8211; <strong>Country<\/strong><\/li>\n<\/ul>\n<p>Click\u00a0<strong>Auto-Detect<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24617\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-17.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"329\" height=\"728\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-17.jpg 329w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-17-136x300.jpg 136w\" sizes=\"(max-width: 329px) 100vw, 329px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span> Select\u00a0<strong>Manage Relationships\u00a0<\/strong>to see what was created automatically<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24618\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-18.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"620\" height=\"161\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-18.jpg 620w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-18-300x78.jpg 300w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/p>\n<p>Click\u00a0<strong>Edit<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24619\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-19.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"686\" height=\"393\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-19.jpg 686w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-19-300x172.jpg 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 8:<\/strong><\/span> This is cool as the relationship between\u00a0<strong>Sales\u00a0<\/strong>and <strong>Customer <\/strong><strong>tables\u00a0<\/strong>is correct! Excel is able to link these tables together via the <strong>Customer Number<\/strong> columns. Click\u00a0<strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone wp-image-24620 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-20.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"682\" height=\"205\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-20.jpg 682w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-20-300x90.jpg 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/p>\n<p>Your Pivot Table is all setup thanks to the automatic creation of the relationships between the 3 tables.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24621\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-21.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"1202\" height=\"569\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-21.jpg 1202w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-21-300x142.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-21-1024x485.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-21-768x364.jpg 768w\" sizes=\"(max-width: 1202px) 100vw, 1202px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>Automatic Time Grouping<\/h3>\n<p>Have a look at our data table. You can see the\u00a0<strong>Time of Order <\/strong>column. Once we create the Pivot Table, Excel is able to group by time periods automatically.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24622\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-22.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"1202\" height=\"507\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-22.jpg 1202w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-22-300x127.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-22-1024x432.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-22-768x324.jpg 768w\" sizes=\"(max-width: 1202px) 100vw, 1202px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Let us setup the following:<\/p>\n<ul>\n<li>Rows <strong>&#8211; Time of Order<\/strong><\/li>\n<li>Values &#8211;\u00a0<strong>Sales<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24623\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-23.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"261\" height=\"573\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-23.jpg 261w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-23-137x300.jpg 137w\" sizes=\"(max-width: 261px) 100vw, 261px\" \/><\/p>\n<p>And just like that, our Sales amounts are <strong>grouped by the hour<\/strong>!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24624\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-24.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"565\" height=\"517\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-24.jpg 565w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-24-300x275.jpg 300w\" sizes=\"(max-width: 565px) 100vw, 565px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>Search In The Pivot Table Fields List<\/h3>\n<p>Imagine if we have a lot of PivotTable Fields, there is a new feature that allows us to find it quickly. Making our Pivot Table setup a faster process.<\/p>\n<p>Here is our field list:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24625\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-25.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"261\" height=\"665\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-25.jpg 261w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-25-118x300.jpg 118w\" sizes=\"(max-width: 261px) 100vw, 261px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Let us say we want to get the\u00a0<strong>SALES30<\/strong> field. Just type in\u00a0<strong>30<\/strong> in the search box and you have the field right away!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New Pivot Table Features in Excel 2019 and Office 365\"  class=\"alignnone size-full wp-image-24626\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-26.jpg\" alt=\"New Pivot Table Features in Excel 2019 and Office 365\" width=\"261\" height=\"665\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-26.jpg 261w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/07\/New-PT-26-118x300.jpg 118w\" sizes=\"(max-width: 261px) 100vw, 261px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The best thing with Pivot Tables is that more features are getting added with Excel updates. I will give you my top 4 picks on the new Pivot Table features that can be used in Excel 2019 and Office 365: Personalize the Default Pivot Table Layout Automatic Relationship detection Automatic Time Grouping Search In The [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":25131,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4],"tags":[802,801,803],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24504"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=24504"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24504\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25131"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}