{"id":3886,"date":"2016-07-18T16:55:47","date_gmt":"2016-07-18T14:55:47","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3886"},"modified":"2024-02-06T15:46:25","modified_gmt":"2024-02-06T14:46:25","slug":"linking-excel-tables-power-pivot","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/linking-excel-tables-power-pivot\/","title":{"rendered":"Linking Excel Tables in Power Pivot"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>When you have multiple tables,\u00a0<strong>Power Pivot\u00a0<\/strong>can help you link them together. After linking them together you can then create a\u00a0<strong><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>\u00a0<\/strong>that will give you a single view of data.<\/p>\n<p>What we will focus on is\u00a0a simple example of two Excel Tables: a\u00a0<em>Name\u00a0<\/em>Table\u00a0and a <em>Sales<\/em>\u00a0Table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3889\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-01.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"288\" height=\"268\" \/><\/a><\/p>\n<p>What we want to know is\u00a0how much each <strong>Employee<\/strong> made in <strong>Total Sales.\u00a0<\/strong><\/p>\n<p>You can see that each employee is<strong> uniquely identified<\/strong> by the <strong>ID number,\u00a0<\/strong>which is also used in the<strong> Sales table<\/strong>.<\/p>\n<p><br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/wUw5WPicwo0?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Linking-Excel-Tables.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong><\/span>: Select your first table. Go to <strong>Insert &gt;\u00a0Table.\u00a0<\/strong>Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3890\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-02.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"336\" height=\"325\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-02.png 336w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-02-300x290.png 300w\" sizes=\"(max-width: 336px) 100vw, 336px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Design &gt; Table Name\u00a0<\/strong> and give your new Table a descriptive name.\u00a0In our example, we will name it\u00a0<em><strong>Names<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3891\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-03.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"700\" height=\"350\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-03.png 700w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-03-300x150.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3<\/strong><\/span>: Select your second\u00a0table. Go to <strong>Insert &gt;\u00a0Table.\u00a0<\/strong>Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3892\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-04.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"353\" height=\"388\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-04.png 353w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-04-273x300.png 273w\" sizes=\"(max-width: 353px) 100vw, 353px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Go to <strong>Design &gt; Table Name\u00a0<\/strong> and give your new Table a descriptive name. In our example, we will name it\u00a0<em><strong>Sales<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3893\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-05.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"696\" height=\"377\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-05.png 696w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-05-300x163.png 300w\" sizes=\"(max-width: 696px) 100vw, 696px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> Select your first table. Go to <strong>Power Pivot &gt; Add to Data Model<\/strong>. This will import your new Table into the\u00a0<strong>Power Pivot Window<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3894\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-06.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"634\" height=\"317\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-06.png 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-06-300x150.png 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Select your second\u00a0table. Go to <strong>Power Pivot &gt; Add to Data Model<\/strong>. This will import your new Table into the\u00a0<strong>Power Pivot Window<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3895\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-07.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"679\" height=\"361\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-07.png 679w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-07-300x159.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><\/p>\n<p>For\u00a0<strong>Excel 2010, <\/strong>go to<strong> <strong>PowerPivot &gt;\u00a0Create Linked Table.<\/strong><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3958\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"1009\" height=\"142\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table.png 1009w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table-300x42.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table-768x108.png 768w\" sizes=\"(max-width: 1009px) 100vw, 1009px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 7:<\/span>\u00a0<\/strong>This will open\u00a0<strong>Power Pivot Window<\/strong>. Your two Tables should already be loaded there.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3896\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-08.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"624\" height=\"267\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-08.png 624w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-08-300x128.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3897\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-09.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"636\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-09.png 636w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-09-300x155.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 8:<\/span> <\/strong>Go to<strong>\u00a0Design<strong>\u00a0&gt; Create Relationship<\/strong>. <\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3898\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-10.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"619\" height=\"155\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-10.png 619w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-10-300x75.png 300w\" sizes=\"(max-width: 619px) 100vw, 619px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 9:<\/span>\u00a0<\/strong>Ensure\u00a0for\u00a0<strong>Table 1,\u00a0<\/strong>you set\u00a0<strong>Names = ID<\/strong> and\u00a0for\u00a0<strong>Table 2<\/strong>, you set it to\u00a0<strong>Sales = ID<\/strong><strong>.<\/strong><\/p>\n<p>This will set the relationship and your\u00a0<strong>Sales\u00a0<\/strong>table will be able to see the values in the\u00a0<strong>Names\u00a0<\/strong>table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3899\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-11.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"724\" height=\"398\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-11.png 724w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-11-300x165.png 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/a><\/p>\n<p>For\u00a0<strong>Excel 2010,\u00a0<\/strong>you can do the same using the\u00a0<strong>Create Relationship Dialog Box:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Relationship-Dialog-Box.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3959\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Relationship-Dialog-Box.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"594\" height=\"315\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Relationship-Dialog-Box.png 594w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Relationship-Dialog-Box-300x159.png 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 10:<\/span>\u00a0<\/strong>With this, our setup is complete.<b>\u00a0 <\/b>Now it&#8217;s time to create a Pivot Table to do our analysis.<\/p>\n<p>Within the <strong>PowerPivot Window<\/strong>, go to\u00a0<strong>Home\u00a0&gt; PivotTable<\/strong><strong>.\u00a0<\/strong><\/p>\n<p>Select <strong>New\/Existing\u00a0Worksheet\u00a0<\/strong>and\u00a0press<strong> OK<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3900\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-12.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"624\" height=\"256\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-12.png 624w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-12-300x123.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 11:<\/strong><\/span>\u00a0This will create a new Pivot Table within your Excel worksheet.<\/p>\n<p>In the\u00a0<strong>ROWS<\/strong>\u00a0area\u00a0put in the\u00a0<em>Name\u00a0<\/em>field from the <strong>Names Table<\/strong>, \u00a0in the\u00a0<strong>VALUES\u00a0<\/strong>area you need to put in the\u00a0<em>Sales Amount<\/em> field from the\u00a0<strong>Sales Table<\/strong>:<\/p>\n<p><a style=\"line-height: 1.5;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3901\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-13.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-13.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-13-167x300.png 167w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 12:<\/strong><\/span>\u00a0We now have the <em>Names<\/em> and the <em>Total Sales Amount<\/em>\u00a0all in one Pivot Table.<\/p>\n<p>We\u00a0were able to link and\u00a0consolidate\u00a0two Excel Tables together with no need for <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/vlookup-in-multiple-excel-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP<\/a> or helper columns&#8230;<\/strong>thanks to\u00a0<strong>Power Pivot!<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3902\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Linking-Excel-Tables-14.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"225\" height=\"111\" \/><\/a><\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/importing-excel-workbooks-power-pivot\/\" target=\"_blank\" rel=\"noopener\">Importing Excel Workbooks in Power Pivot<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/using-diagram-view-power-pivot\/\" target=\"_blank\" rel=\"noopener\">Using the Diagram View in Power Pivot<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unpivot-data-using-excel-power-query\/\" target=\"_blank\" rel=\"noopener\">Unpivot Data Using Excel Power Query<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2964 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/728x90.gif\" alt=\"PIVOT BANNER\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; When you have multiple tables,\u00a0Power Pivot\u00a0can help you link them together. After linking them together you can then create a\u00a0Pivot Table\u00a0that will give you a single view of data. What we will focus on is\u00a0a simple example of two Excel Tables: a\u00a0Name\u00a0Table\u00a0and a Sales\u00a0Table. What we want to know is\u00a0how much each Employee made [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17172,"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":[120,122],"tags":[153,157,145],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3886"}],"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=3886"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3886\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17172"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}