{"id":3677,"date":"2021-01-21T17:11:05","date_gmt":"2021-01-21T16:11:05","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3677"},"modified":"2024-02-06T15:48:41","modified_gmt":"2024-02-06T14:48:41","slug":"installing-power-pivot-excel-2010","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-pivot-excel-2010\/","title":{"rendered":"Installing Power Pivot in Excel 2010"},"content":{"rendered":"<p>Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft.<\/p>\n<p>Excel 2010 power pivot allows you to harness the power of Business Intelligence right in Excel.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/enabling-power-pivot-excel-2013\/\" target=\"_blank\" rel=\"noopener noreferrer\">Read the tutorial on how to enable Power Pivot in Excel 2013 here<\/a><\/p>\n<p><a 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<h3><strong>So What is Power Pivot?<\/strong><\/h3>\n<p>In a nutshell, Excel 2010 Power Pivot allows you to use multiple data sources for analysis.<\/p>\n<p>Power Pivot gives you the power to work with large sets of data that are <strong>over 1 million rows<\/strong>!!!<\/p>\n<p>You could import, merge and perform analysis on the resulting data. The beautiful thing with Power Pivot is it allows you to work on\u00a0<strong data-redactor-tag=\"strong\">Big Data with no limitations<\/strong>.<\/p>\n<p>Imagine getting data from multiple sources like\u00a0<strong data-redactor-tag=\"strong\">SQL Server, Oracle, XML, Excel, Microsoft Access, <\/strong>and analyzing\u00a0these all into one awesome\u00a0<strong data-redactor-tag=\"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>Watch the Video on How to Install Excel 2010 power pivot on <a href=\"https:\/\/youtu.be\/nRGz5tPJKmU\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Youtube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/nRGz5tPJKmU?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>&nbsp;<\/p>\n<p><strong>So how do I\u00a0get my\u00a0hands on this super awesome add-in&#8230;I hear you say?<\/strong><\/p>\n<p><strong><a href=\"https:\/\/www.amazon.com\/Microsoft-Office-Home-Business-2010\/dp\/B0039L50J8\/ref=sr_1_1?s=software&amp;ie=UTF8&amp;qid=1469566717&amp;sr=1-1&amp;keywords=Microsoft+Excel+2010+Key+Card\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Get Office\u00a02010 Home &amp; Business on Amazon<\/a><\/strong><\/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 ProPlus Subscription<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\">Install Excel 2010 Power Pivot<\/span><\/h3>\n<p>Follow this step-by-step tutorial on how to install PowerPivot in Excel 2010:<\/p>\n\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong><\/span>: The first step is to check the Excel bit version that you have on your PC.<\/p>\n<p>To check the bit version, you need to go and open any\u00a0Excel workbook and go to <strong>File &gt; Help<\/strong> and on the far right-hand side, you will see the <strong>Version<\/strong> and the bit number in brackets, either<strong> (32-bit) or (64-bit)<\/strong>. \u00a0Once you know this, close out of Excel completely!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-2010-file-help-1.png\" rel=\"attachment wp-att-2554\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Install Power Query in Excel 2010\"  class=\"alignnone size-full wp-image-2554\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-2010-file-help-1.png\" alt=\"How To Install Power Query in Excel 2010\" width=\"837\" height=\"434\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-2010-file-help-1.png 837w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-2010-file-help-1-300x156.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/excel-2010-file-help-1-768x398.png 768w\" sizes=\"(max-width: 837px) 100vw, 837px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> You will need to click on the following link and <strong>download the Power Pivot\u00a0add-in<\/strong> from Microsoft&#8217;s website:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-ph\/download\/details.aspx?id=43348\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><strong>Download Power Pivot for Excel 2010<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3694\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-02.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"1023\" height=\"477\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-02.png 1023w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-02-300x140.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-02-768x358.png 768w\" sizes=\"(max-width: 1023px) 100vw, 1023px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> <strong>Press the Download button<\/strong> and you will need to <strong>select the download bit version<\/strong>\u00a0based on the bit system your Excel 2010 version is running (from Step 1).<\/p>\n<p>If your Excel is 32-bit, pick the <strong>x86 installer.<\/strong><\/p>\n<p>If your Excel is 64-bit, pick the <strong>amd64 installer<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3695\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-03.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"817\" height=\"292\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-03.png 817w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-03-300x107.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-03-768x274.png 768w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/><\/a><\/p>\n<p>Press the <strong>NEXT<\/strong> button&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3696\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-04.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"396\" height=\"419\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-04.png 396w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-04-284x300.png 284w\" sizes=\"(max-width: 396px) 100vw, 396px\" \/><\/a><\/p>\n<p>&#8230;and this will start the download of the add-in installer .msi file installer on your browser (if you do not see this, go to your browser&#8217;s Downloads folder).<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span>\u00a0Click on the .msi file to run the installer<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3697\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-05.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"613\" height=\"112\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-05.png 613w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-05-300x55.png 300w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span>\u00a0\u00a0This will bring up the <strong>Microsoft Power Pivot\u00a0for Excel Setup<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3698\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-06.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"499\" height=\"383\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-06.png 499w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-06-300x230.png 300w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Click the <strong>Next<\/strong> button and <strong>accept the terms of the Licence Agreement<\/strong> and press <strong>Next<\/strong> again:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3699\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-07.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"494\" height=\"385\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-07.png 494w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-07-300x234.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Click <strong>Next<\/strong> and select the <strong>Install<\/strong> button, wait for the Install to finish:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3700\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-08.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"509\" height=\"390\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-08.png 509w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-08-300x230.png 300w\" sizes=\"(max-width: 509px) 100vw, 509px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You will get the following message once your install has been <strong>completed successfully<\/strong>. \u00a0Press <strong>Finish!<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3701\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-09.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"502\" height=\"385\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-09.png 502w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-09-300x230.png 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> <strong>Open a blank Excel workbook<\/strong> and on the ribbon menu you should now see the <strong>Power Pivot<\/strong>\u00a0tab:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Installing Power Pivot in Excel 2010\"  class=\"alignnone size-full wp-image-3702\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-10.png\" alt=\"Installing Power Pivot in Excel 2010\" width=\"768\" height=\"134\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-10.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/installing-2010-10-300x52.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\">Enable Excel 2010 Power Pivot<\/span><\/h3>\n<p>If you cannot see the PowerPivot tab, go through the steps below to activate it:<\/p>\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 2010 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 2010!<\/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<h3><\/h3>\n<p>To work on Power Pivot, you must first understand how to open the <strong>Power Pivot window<\/strong>.<\/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>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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft. Excel 2010 power pivot allows you to harness the power of Business Intelligence right in Excel. Read the tutorial on how to enable Power Pivot in Excel 2013 here Read the tutorial on how to enable Power Pivot in Excel [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":18109,"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":[146,145],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3677"}],"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=3677"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3677\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/18109"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}