If you are using PowerPivot for Excel 2010, then click here.
The following collections of links and resources will help you go from short video overviews of PowerPivot and Power View capability to being fairly proficient.
Here’s a collection of short videos from Microsoft on Excel 2013 PowerPivot and Power View.
There are more links to videos later in the blog.
PowerPivot in Microsoft Excel 2013 does not have to be downloaded. It is already installed, you just have to enable it. While you are enabling PowerPivot you should enable Power View at the same time.
The PowerPivot for Excel 2013 tutorial is a sequence that begins by importing data and teaching you about the data model behind the PowerPivot. It goes all the way through to creating some amazing charts in Power View.
It’s easy on Microsoft’s website to start a tutorial for the wrong version of Excel. Be careful. This series of tutorials takes you from creating a data model and importing data, to joining data, adding calculated fields, using a Pivot Table, and finally building awesome dashboards using Power View. Grab a snack, warm up the cup, and set your Microsoft Skype to “Do Not Interrupt” and learn some cool stuff.
1. Import Data into Excel 2013, and Create a Data Model
2. Extend Data Model relationships using Excel 2013, PowerPivot, and DAX
3. Create Map-based Power View Reports
4. Incorporate Internet Data, and Set Power View Report Defaults
5. Create Amazing Power View Reports – Part 1
6. Create Amazing Power View Reports – Part 2
You’ve already seen earlier information about Power View for Excel 2013. The previous tutorial for PowerPivot also included multiple tutorials on how to create Power View dashboards. The following tutorial is devoted exclusively to Power View.
For a longer video that shows a number of tips and tricks, checkout this presentation made at the Microsoft TechEd 2014 conference. It’s about an hour in length, but has some great stuff.
Data Analysis Expressions (DAX) are the new database functions built into both versions of PowerPivot. PowerPivot for Excel 2013 has additional functions to those in Excel 2010. Adding calculated columns to the data model and using many of the DAX functions will be straightforward to any intermediate Excel users. However, some of these DAX functions are very powerful, but are real brain twisters.
I highly recommend getting a copy of Rob Collie’s book. Rob was an insider in the development of the Power tools. A number of his tips and tricks saved me frustration and time.
DAX Formulas for PowerPivot by Rob Collie
Rob has a website with PowerPivot blog and classes at
As an introduction to PowerPivot for either Excel 2010 or Excel 2013 version take a look at
PowerPivot for the Data Analyst: Microsoft Excel 2010 by Bill Jelen
Bill’s book is published by Que, my old publisher.
Bill also has a series on playlist of 23 videos on Excel 2013’s PowerPivot, Power View, and Power Query (we didn’t talk about Power Query.)
To get the data files for all of the 2013 videos, download this file and scroll down to the PowerPivot for Excel 2013 section.
This Microsoft page has a lot of resources and tutorials. If you can’t figure out how to do something, come here.