Excel 2010 PowerPivot

Excel

To learn more about PowerPivot and PowerView for Excel 2013, click here.

If you have Excel 2010 you have access to Power Pivot, but not Power View. Just the capabilities of Power Pivot make it an extremely powerful tool that any power Excel user has to be familiar with. The ribbon has slight differences from PowerPivot for Excel 2013, but you should be able to learn from videos or instructions for either version.

Check out the book Bill Jelen has written as an excellent way to get started in PowerPivot for Excel 2010. Links to Bill’s videos series on that version are below.

Microsoft’s Overview of Excel 2010 PowerPivot

https://support.office.com/en-us/article/Power-Pivot-Add-in-a9c2c6e2-cc49-4976-a7d7-40896795d045?ui=en-US&rs=en-US&ad=US

System Requirements and Installing PowerPivot for Excel 2010

https://technet.microsoft.com/en-us/library/gg413462.aspx

PowerPivot for Excel 2010 Tutorial Introduction

https://technet.microsoft.com/en-us/library/gg413497.aspx

Sample data for Excel 2010 PowerPivot Tutorial

http://powerpivotsdr.codeplex.com/

Recommended Videos and Books

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. Hope they’ve been good to you Bill!

Bill has a series of You Tube videos that go with his book on PowerPivot for Excel 2010.

The videos are in short segments. So they are much easier to use than the one hour videos.

Share the power...

Leave a Comment:

Leave a Comment: