{"id":3944,"date":"2020-08-06T02:41:36","date_gmt":"2020-08-06T00:41:36","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3944"},"modified":"2024-02-06T15:48:18","modified_gmt":"2024-02-06T14:48:18","slug":"enabling-power-pivot-excel-2016","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/enabling-power-pivot-excel-2016\/","title":{"rendered":"Enabling Power Pivot Excel 2016"},"content":{"rendered":"<p>Power Pivot\u00a0is an Excel add-in\u00a0that was first introduced in\u00a0Excel 2010\u00a0by Microsoft. It allows you to harness the power of Business Intelligence right in Excel.<\/p>\n<p><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-pivot-excel-2010\" target=\"_blank\" rel=\"noopener noreferrer\">Read the tutorial on how to install Power Pivot in Excel 2010 here<\/a><\/p>\n<p><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/enabling-power-pivot-excel-2016\/\" target=\"_blank\" rel=\"noopener noreferrer\">Read the tutorial on how to enable Power Pivot in Excel 2016 here<\/a><\/p>\n<p>In this tutorial, you will be provided with a<strong> detailed guide<\/strong> on<\/p>\n<ul>\n<li><strong><a href=\"#what-is-power-pivot\">What is Power Pivot?<\/a><\/strong><\/li>\n<li><a href=\"#how-to-enable-power-pivot-for-excel-2016\"><strong>How to Enable Power Pivot for Excel 2016?<\/strong><\/a><\/li>\n<li><a href=\"#getting-started-with-power-pivot-2016\"><strong>Getting started with Power Pivot 2016<\/strong><\/a>\n<ul>\n<li><strong><a href=\"#how-to-open-the-power-pivot-window\">How to open the Power Pivot window?<\/a><\/strong><\/li>\n<li><a href=\"#add-data-to-data-model\"><strong>Add Data to Data Model<\/strong><\/a><\/li>\n<li><a href=\"#different-views-in-power-pivot\"><strong>Different Views in Power Pivot<\/strong><\/a><\/li>\n<li><a href=\"#create-relationship-in-power-pivot\"><strong>Create Relationship in Power Pivot<\/strong><\/a><\/li>\n<li><a href=\"#create-pivot-table-using-power-pivot-data\"><strong>Create Pivot Table using Power Pivot data<\/strong><\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#advantages-of-using-power-pivot-excel-2016\"><strong>Advantages of using Power Pivot Excel 2016<\/strong><\/a><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s go through each point one-by-one!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"what-is-power-pivot\"><\/a>What is Power Pivot?<\/strong><\/h3>\n<p>Power Pivot gives you the power to work with large sets of data.<\/p>\n<p>In a nutshell, it allows you to use multiple data sources. Then you could import, merge and perform analysis on the resulting data.<\/p>\n<p>The beautiful thing with Power Pivot is it allows you to work on <strong>Big Data with no limitations<\/strong>.<\/p>\n<p>Imagine getting data from multiple sources like <strong>SQL Server, Oracle, XML, Excel, Microsoft Access<\/strong> then build a <strong>Data Model<\/strong> from it. Then you can analyze these all into one awesome <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><\/strong>!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"how-to-enable-power-pivot-for-excel-2016\"><\/a>How to Enable Power Pivot for Excel 2016?<\/strong><\/h3>\n<p><em>So how do I\u00a0get my\u00a0hands on this super awesome add-in&#8230;I hear you say?<\/em><\/p>\n<p>The good thing with Power Pivot is it already comes with your Excel 2016, we need <strong>to enable it<\/strong> to start using Power Pivot.<\/p>\n<p>You just need to make sure you have one of these versions:<\/p>\n<p><strong><a href=\"https:\/\/microsoft-us.evyy.net\/c\/312894\/243952\/3327?u=https%3A%2F%2Fproducts.office.com%2Fen-us%2Fbusiness%2Foffice-365-proplus-business-software\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Office 365 Pro Plus<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/microsoft-us.evyy.net\/c\/312894\/243952\/3327?u=https%3A%2F%2Fproducts.office.com\/en-us\/business\/office-365-enterprise-e3-business-software\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><strong>Office 365 E3<\/strong><\/a><\/p>\n<p>Power Pivot is <strong>NOT AVAILABLE<\/strong>\u00a0in Office\u00a02016 for the following products:<\/p>\n<p><strong><em>Office 365 Home,\u00a0Office 365 Personal,\u00a0Office 365 Business Essentials,\u00a0Office 365 Business,\u00a0Office 365 Business Premium,\u00a0Office 365 Enterprise E1<\/em><\/strong><\/p>\n<p>&nbsp;<\/p>\n\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong><\/span>: Go to <strong>File &gt; Options\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2016\"  class=\"alignnone size-full wp-image-3947\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-01.png\" alt=\"Enabling Power Pivot Excel 2016\" width=\"770\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-01.png 770w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-01-300x63.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-01-768x162.png 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2016\"  class=\"alignnone size-full wp-image-3948\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-02.png\" alt=\"Enabling Power Pivot Excel 2016\" width=\"128\" height=\"252\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Add-Ins,\u00a0<\/strong>for the\u00a0<strong>Manage dropdown\u00a0<\/strong>select\u00a0<strong>COM Add-ins.\u00a0<\/strong>Click\u00a0<strong>Go<\/strong> once set.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2016\"  class=\"alignnone size-full wp-image-3949\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-03.png\" alt=\"Enabling Power Pivot Excel 2016\" width=\"826\" height=\"678\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-03.png 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-03-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-03-768x630.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0Check\u00a0<strong>Microsoft Power Pivot for Excel<\/strong>. Click\u00a0<strong>OK<\/strong> once done.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2016\"  class=\"alignnone size-full wp-image-3950\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-04.png\" alt=\"Enabling Power Pivot Excel 2016\" width=\"607\" height=\"259\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-04.png 607w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-04-300x128.png 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/a><\/p>\n<p><em>You can easily enable Pivot Excel 2016 download and make the tab appear in the menu ribbon.<\/em><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span>\u00a0<\/strong>You should now have the\u00a0<strong>Power Pivot Tab. \u00a0<\/strong>Click\u00a0<strong>Manage<\/strong>\u00a0to see the <strong>Power Pivot Window<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2016\"  class=\"alignnone size-full wp-image-3951\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-05.png\" alt=\"Enabling Power Pivot Excel 2016\" width=\"670\" height=\"157\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-05.png 670w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-05-300x70.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a><\/p>\n<p>This will open Power Pivot in Excel 2016!<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"> <strong>Power Pivot Window (click on the image to expand):<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2016\"  class=\"alignnone wp-image-3952 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-06.png\" alt=\"Enabling Power Pivot Excel 2016\" width=\"1364\" height=\"232\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-06.png 1364w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-06-300x51.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-06-1024x174.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Enabling-in-2016-06-768x131.png 768w\" sizes=\"(max-width: 1364px) 100vw, 1364px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"#getting-started-with-power-pivot-2016\"><\/a>Getting Started with Power Pivot Excel 2016<\/strong><\/h3>\n<p>To work on Power Pivot, you must first understand how to open the <strong>Power Pivot window<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"how-to-open-the-power-pivot-window\"><\/a>How to open the Power Pivot window?<\/strong><\/span><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Click on the <strong>Power Pivot<\/strong> Tab in Menu Ribbon.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18822\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"935\" height=\"126\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376.png 935w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376-300x40.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376-768x103.png 768w\" sizes=\"(max-width: 935px) 100vw, 935px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Select the <strong>Manage<\/strong> option under Data Model.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18823\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"726\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png 726w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377-300x53.png 300w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/><\/a><\/p>\n<p>This opens the Power Pivot window and here you can explore all of its features!<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"add-data-to-data-model\"><\/a>Adding Data to Data Model<\/strong><\/span><\/p>\n<p>The first step is to add some data to your model. You can import data from two categories:<\/p>\n<ul>\n<li>From the <strong>Current Workbook<\/strong><\/li>\n<li>From<strong> External Data Sources<\/strong>.<\/li>\n<\/ul>\n<p>Let&#8217;s talk about each one of them in detail.<\/p>\n<p>&nbsp;<\/p>\n<p>To <strong>Import data from the Current Workbook<\/strong>, follow the steps below:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> Highlight<\/strong> the Data in your current workbook.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-378.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18828\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-378.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"640\" height=\"423\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-378.png 640w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-378-300x198.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Go to <strong>Insert<\/strong> &gt; <strong>Table<\/strong> to convert data into a table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-379.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18829\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-379.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"735\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-379.png 735w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-379-300x52.png 300w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>In the <strong>Create Table<\/strong> dialog box, Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-396.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18832\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-396.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"229\" height=\"149\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>Go to <strong>Power Pivot<\/strong> &gt;<strong> Add to Data Model<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-380.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18830\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-380.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"798\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-380.png 798w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-380-300x48.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-380-768x123.png 768w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/a><\/p>\n<p>This will import the data into the power pivot window.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-381.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18831\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-381.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"839\" height=\"518\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-381.png 839w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-381-300x185.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-381-768x474.png 768w\" sizes=\"(max-width: 839px) 100vw, 839px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>To<strong> Import data from an External Data Source <\/strong>like an Excel File, follow the step-by-step tutorial below:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span>\u00a0<\/strong>Click on <strong>Power Pivot<\/strong> &gt; <strong>Manage<\/strong> to open the Power Pivot Window.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18823\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"726\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png 726w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377-300x53.png 300w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span>\u00a0<\/strong>Click on <strong>Home<\/strong> &gt; <strong>From Other Sources<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-397.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18833\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-397.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"913\" height=\"116\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-397.png 913w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-397-300x38.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-397-768x98.png 768w\" sizes=\"(max-width: 913px) 100vw, 913px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>In the<strong> Table Import Wizard<\/strong>, Select <strong>Excel File<\/strong> and Click <strong>Next<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-403.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18834\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-403.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"539\" height=\"581\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>Click on <strong>Browse<\/strong>.<strong>\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-416.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18836\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-416.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"531\" height=\"581\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-416.png 531w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-416-274x300.png 274w\" sizes=\"(max-width: 531px) 100vw, 531px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5: <\/span><\/strong>Select the <strong>Excel file<\/strong> that you want to import.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-407.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18841\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-407.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"672\" height=\"475\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-407.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-407-300x212.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6: <\/span><\/strong>Click <strong>Next<\/strong>. Make sure to check the box for <strong>Use first row as column headers<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-408.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18840\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-408.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"535\" height=\"585\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-408.png 535w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-408-274x300.png 274w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 7: <\/span><\/strong>Click <strong>Next<\/strong> (As the desired sheet is already selected here)<\/p>\n<p><em>If you have multiple sheets in your file, it will be displayed here and you can select the one you want to import.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-409.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18843\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-409.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"536\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-409.png 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-409-279x300.png 279w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<p>If you also apply a filter in your data as per your required. Say, you want to display data for the month of\u00a0 January, February, and April only.<\/p>\n<p>You can do that by clicking on the<strong> Preview &amp; Filter<\/strong> button and then applying the filter.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-410-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18845\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-410-1.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"808\" height=\"517\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-410-1.png 808w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-410-1-300x192.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-410-1-768x491.png 768w\" sizes=\"(max-width: 808px) 100vw, 808px\" \/><\/a><\/p>\n<p>Only the filtered data will be imported to Power Pivot.<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 8: <\/span><\/strong>Click <strong>Finish<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-411.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18846\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-411.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"532\" height=\"579\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-411.png 532w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-411-276x300.png 276w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 9: <\/span><\/strong>A <strong>Success message<\/strong> will be displayed showing you the number of rows that have been imported. Verify that and Click <strong>Close<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-412.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18847\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-412.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"529\" height=\"578\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-412.png 529w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-412-275x300.png 275w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"different-views-in-power-pivot\"><\/a>Different Views in Power Pivot<\/strong><\/h3>\n<p>There are two views that are available in Power Pivot &#8211; <strong>Data View<\/strong> and <strong>Diagram View.<\/strong><\/p>\n<p><strong>Data View<\/strong><\/p>\n<p>This is the view shown to Excel users by <strong>default<\/strong>.<\/p>\n<p>Data view displays a table of your data model in a <strong>grid format, much like the standard Excel<\/strong>. Each table has its own tab at the bottom of the sheet. You <strong>cannot make any edits<\/strong> in the cells in the data view.<\/p>\n<p>A data view is comprised of two parts &#8211; the <strong>Table area<\/strong> and the <strong>Calculation area<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-417.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18857\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-417.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"680\" height=\"510\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-417.png 680w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-417-300x225.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><\/p>\n<p><strong>The Table area<\/strong> is where the data table is displayed and the <strong>Calculation area<\/strong> is just below the table area where you can create measures.<\/p>\n<p>You can even <strong>hide the Calculation area<\/strong> if it is not required by clicking on the <strong>Home<\/strong> &gt;<strong> Calculation Area<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18859\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"1023\" height=\"102\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1.png 1023w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1-300x30.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1-768x77.png 768w\" sizes=\"(max-width: 1023px) 100vw, 1023px\" \/><\/a><\/p>\n<p><strong>Diagram View<\/strong><\/p>\n<p><em>Ever faced a situation when you have multiple tables in Power Pivot and you are unable to analyze the relationship?<\/em><\/p>\n<p>Diagram View provides a perfect solution for this problem &#8211; a<strong> bird&#8217;s eye view<\/strong> for all your tables.<\/p>\n<p>Let&#8217;s look at an<strong> example<\/strong> of how data is displayed in Diagram View.<\/p>\n<p>You have two tables &#8211; <strong>Names<\/strong> and <strong>Sales<\/strong>.<\/p>\n<p><em><strong>Names Table<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Using the Diagram View in Power Pivot\"  class=\"alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Diagram-View-02.png\" alt=\"Using the Diagram View in Power Pivot\" width=\"500\" height=\"265\" \/><\/p>\n<p><em><strong>Sales Table<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Using the Diagram View in Power Pivot\"  src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Diagram-View-03.png\" alt=\"Using the Diagram View in Power Pivot\" \/><\/p>\n<p>The\u00a0ID column\u00a0of the\u00a0Sales\u00a0Table is linked to the ID column\u00a0of the\u00a0Name\u00a0Table.<\/p>\n<p>*** You can view the exact step-by-step tutorial of how this was done here:\u00a0<a href=\"#create-relationship-in-power-pivot\" target=\"_blank\" rel=\"noopener noreferrer\">Linking Excel Tables in Power Pivot.<\/a> ***<\/p>\n<p>To get a bird&#8217;s eye view of this relationship, Go to <strong>Home<\/strong> &gt; <strong>Diagram View<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-487.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2016\"  class=\"alignnone size-full wp-image-18969\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-487.png\" alt=\"Enabling Power Pivot Excel 2016\" width=\"1345\" height=\"519\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-487.png 1345w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-487-300x116.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-487-1024x395.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-487-768x296.png 768w\" sizes=\"(max-width: 1345px) 100vw, 1345px\" \/><\/a><\/p>\n<p>In Diagram View, each table is <strong>represented using a box<\/strong> with the header as table name, and then below is the name of the columns of that particular table.<\/p>\n<p>You can drag the corner of the table to <strong>resize them<\/strong> and can also <strong>move them<\/strong> to different locations.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"create-relationship-in-power-pivot\"><\/a>Create Relationship in Power Pivot<\/strong><\/span><\/p>\n<p>In the example above, you have imported the two tables in the Power Pivot window. You can now<strong> link the ID column<\/strong> from the <strong>Names<\/strong> table with the ID column in <strong>Sales<\/strong> Table.<\/p>\n<p>Let&#8217;s see how it can be done by <strong>following the steps<\/strong> below:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1: <\/span><\/strong>In the Power Pivot window, Go to <strong>Home<\/strong> &gt; <strong>Diagram View<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18867\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1-1.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"1024\" height=\"100\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1-1.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1-1-300x29.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Diagram-View-Excel-2010-2013-1024x456-1-1-768x75.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>Select the Column Heading and drag to connect it to the Column heading of the second table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-488.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2016\"  class=\"alignnone size-full wp-image-18970\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-488.png\" alt=\"Enabling Power Pivot Excel 2016\" width=\"1342\" height=\"539\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-488.png 1342w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-488-300x120.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-488-1024x411.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Screenshot-488-768x308.png 768w\" sizes=\"(max-width: 1342px) 100vw, 1342px\" \/><\/a><\/p>\n<p>To view the relationship created, simply<strong> double click on the arrow<\/strong> linking the two tables.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-422.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18868\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-422.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"789\" height=\"605\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-422.png 789w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-422-300x230.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-422-768x589.png 768w\" sizes=\"(max-width: 789px) 100vw, 789px\" \/><\/a><\/p>\n<p>As you can see the<strong> ID column is highlighted<\/strong> in both the tables indicating the link between the two columns.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"create-pivot-table-using-power-pivot-data\"><\/a>Create Pivot Table using Power Pivot data<\/strong><\/span><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Click on the <strong>Power Pivot<\/strong> Tab in Menu Ribbon.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18822\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"935\" height=\"126\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376.png 935w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376-300x40.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-376-768x103.png 768w\" sizes=\"(max-width: 935px) 100vw, 935px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Select the <strong>Manage<\/strong> option under Data Model.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18823\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"726\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377.png 726w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-377-300x53.png 300w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>In the Power Pivot window, Go to <strong>Home<\/strong> &gt; <strong>PivotTable<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-418.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18863\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-418.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"962\" height=\"118\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-418.png 962w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-418-300x37.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-418-768x94.png 768w\" sizes=\"(max-width: 962px) 100vw, 962px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>In the <strong>Create PowerTable<\/strong> dialog box, Select <strong>New Worksheet<\/strong> and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-419.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18864\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-419.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"380\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-419.png 380w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-419-300x126.png 300w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5: <\/span><\/strong>In the\u00a0<strong>PivotTable Fields<\/strong> panel, you can drag and drop fields to create a customized PivotTable.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-420.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18865\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-420.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"342\" height=\"501\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-420.png 342w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-420-205x300.png 205w\" sizes=\"(max-width: 342px) 100vw, 342px\" \/><\/a><\/p>\n<p>This is how the PivotTable will look like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-421.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Enabling Power Pivot Excel 2013\"  class=\"alignnone size-full wp-image-18866\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-421.png\" alt=\"Enabling Power Pivot Excel 2013\" width=\"443\" height=\"260\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-421.png 443w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-421-300x176.png 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"advantages-of-using-power-pivot-excel-2016\"><\/a>Advantages of using Power Pivot Excel 2016<\/strong><\/h3>\n<p>The main advantages of using Power Pivot Excel 2016 are as follows:<\/p>\n<ul>\n<li>You can work with<strong> millions of rows and extract data<\/strong> from multiple sources.<\/li>\n<li>You can process calculations and analysis <strong>faster<\/strong>.<\/li>\n<li>You can import data from multiple sources and you can also<strong> filter data and rename columns while importing<\/strong>.<\/li>\n<li>When you import a table in Power Pivot, each <strong>table gets organized in individual tabbed pages<\/strong>.<\/li>\n<li>You can <strong>create your own formula using DAX<\/strong> expression.<\/li>\n<li>You can<strong> create relationships among the table<\/strong> to easily analyze data fields together.<\/li>\n<li>You can <strong>create calculated fields and calculated columns<\/strong> in the data table.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"conclusion\"><\/a>Conclusion<\/strong><\/h3>\n<p>In this article, you have learned about Power Pivot Excel 2016 download- how to install Power Pivot for Excel 2016, Open a power pivot window, add data to model from current file or external sources, different views in power pivot excel 2016, and lastly the advantages of using Power Pivot.<\/p>\n<p>There is a lot you can do using this tool. <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/power-bi\/power-pivot\/\" target=\"_blank\" rel=\"noopener noreferrer\">Click here<\/a><\/strong> to learn more.<\/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>You can learn more about how to use Excel by viewing our FREE Excel webinar training on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>,<\/strong> and <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/530x300-Pivot.jpg?x85520\" alt=\"Excel Pivot Table\" width=\"530\" height=\"300\" title=\"\"><\/a>&gt;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Pivot\u00a0is an Excel add-in\u00a0that was first introduced in\u00a0Excel 2010\u00a0by Microsoft. It allows you to harness the power of Business Intelligence right in Excel. Read the tutorial on how to install Power Pivot in Excel 2010 here Read the tutorial on how to enable Power Pivot in Excel 2016 here In this tutorial, you will [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":14738,"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":[136,145],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3944"}],"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=3944"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3944\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/14738"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}