PowerView

PowerView is a new add-in for Excel 2013 Pro Plus. It’s the best tool ever to use Excel as a BI application.

Microsoft Store

Install PowerView

To install PowerView in Excel 2013, Go to menu File > Options

  1. Select the Add-ins menu and in the dropdown list
  2. select COM Add-ins
  3. press GO …

Check the option Power View

Now, in the INSERT tab, you have a new menu; Power View

When you click on this icon, a new worksheet appears in your workbook ; exactly like for a Pivot Table. But because Power View uses the Silverlight technology (will be migrating to HTML5) you can make create interactive charts and maps.

Power View – Create a chart

Creating a chart with Power View is something really easy. But, even if the choice of chart is less important than in a worksheet, the Power View charts provide more functionality. Contents1 Create a chart.2 Chart label3 Interaction between elements Create a chart. For creating a chart in a Power View sheet, you must first …

View page »

PowerView_Create_Table_3

Power View – Create table

Creating a table with Power View is easier than creating a Pivot Table. So if you don’t feel comfortable with Pivot Tables it could be a good idea to start with Power View. Contents1 Create a Data Model2 Open Power View3 Create your first table in Power View4 Drill-Down / Drill-Up Create a Data Model Before you …

View page »

13 comments

Skip to comment form

  1. HugoL

    i need download power view for Excel 2010 is there anyone who can send me the link? pls???

  2. Johnd219

    Nice post. I was checking constantly this blog and I am impressed! Extremely useful information specially the last part

  3. Alin

    It is or it not available separately for download power view 2013?

  4. Matt P

    I have Office Professional Plus 2013, but the power view add on is not appearing in my Com Add in section. Do I need to download a key? I have looked through a number of site but not been able to find a resolution?

    1. Frédéric LE GUEN

      There is nothing to activate. Check in the menu File > Account the version of your Excel. Just bellow the logo Office, you have the product informations

    2. Zack Baresse

      Matt, it’s in preview right now until May 2014. You can download it from here:

      http://www.microsoft.com/en-us/download/confirmation.aspx?id=38395

      ————–

      EDIT: This is for Power Map, not Power View, sorry. The Power BI ‘bundle’ will be available (once out of preview) for all Professional Plus versions, but Power Map will only be available for ProPlus (365 subscribers only).

  5. Spencer Watts

    I have Excel 2013 and Power View is not showing up in my COM Add-Ins. Is there a fix available for this?

    1. Frédéric LE GUEN

      Do you have the version Pro Plus ?

    2. Rasheed

      You can install separately….. Smile

      1. Frédéric LE GUEN

        No, you must have the Excel version with PowerView inside

  6. 1ST Merchant Funding

    I like the dear information and facts an individual give to your content. I’ll take a note of your website and appearance yet again the following routinely. I am just fairly sure I’m going to be well informed lots of completely new products here! Good luck for one more!

  7. H20Dragon64-12

    Smile I have been looking for Power View and PowerPivot, and it’s only here that I found it!

    Thanks, Bro…

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Click to Insert Smiley

SmileBig SmileGrinLaughFrownBig FrownCryNeutralWinkKissRazzChicCoolAngryReally AngryConfusedQuestionThinkingPainShockYesNoLOLSillyBeautyLashesCuteShyBlushKissedIn LoveDroolGiggleSnickerHeh!SmirkWiltWeepIDKStruggleSide FrownDazedHypnotizedSweatEek!Roll EyesSarcasmDisdainSmugMoney MouthFoot in MouthShut MouthQuietShameBeat UpMeanEvil GrinGrit TeethShoutPissed OffReally PissedMad RazzDrunken RazzSickYawnSleepyDanceClapJumpHandshakeHigh FiveHug LeftHug RightKiss BlowKissingByeGo AwayCall MeOn the PhoneSecretMeetingWavingStopTime OutTalk to the HandLoserLyingDOH!Fingers CrossedWaitingSuspenseTremblePrayWorshipStarvingEatVictoryCurseAlienAngelClownCowboyCyclopsDevilDoctorFemale FighterMale FighterMohawkMusicNerdPartyPirateSkywalkerSnowmanSoldierVampireZombie KillerGhostSkeletonBunnyCatCat 2ChickChickenChicken 2CowCow 2DogDog 2DuckGoatHippoKoalaLionMonkeyMonkey 2MousePandaPigPig 2SheepSheep 2ReindeerSnailTigerTurtleBeerDrinkLiquorCoffeeCakePizzaWatermelonBowlPlateCanFemaleMaleHeartBroken HeartRoseDead RosePeaceYin YangUS FlagMoonStarSunCloudyRainThunderUmbrellaRainbowMusic NoteAirplaneCarIslandAnnouncebrbMailCellPhoneCameraFilmTVClockLampSearchCoinsComputerConsolePresentSoccerCloverPumpkinBombHammerKnifeHandcuffsPillPoopCigarette