PowerPivot vs Pivot Table

10 minutes Easy

power pivot training courses

PowerPivot is a new tool available in Excel 2010 and Excel 2013. International experts believe this is a quantum leap in Excel and people like Mr Excel’s Bill Jelen has stated that it is the best thing to happen to Excel in years. On the surface it looks like a traditional Pivot Table with some new screens but there is much much more.

The PowerPivot Ribbon

15 minutes Easy

power pivot training courses

How to activate your PowerPivot and what the new screen and ribbons do.

Differences between Excel and PowerPivot use

30 minutes Standard

power pivot training courses

As a regular Excel user you have a distinct advantage when it comes to learning PowerPivot as it has been built with you in mind. However, there are some differences which you need to understand in order to get started.

Linked Excel file in PowerPivot

15 minutes Easy

It is possible to link an Excel file to the PowerPivot tables. This only works with the Excel workbook ATTACHED to the PowerPivot window, i.e. the Excel workbook you were in when you clicked on the PowerPivot Manage button.

Text files in PowerPivot

10 minutes Easy

power pivot training courses

PowerPivot can import data from multiple type of text files. Click on the HOME tab, then FROM OTHER SOURCES and go to the bottom to choose Text Files and click NEXT

Databases into PowerPivot

10 minutes Standard

You can also link directly to common forms of databases. There are multiple ways of doing this but one way is to click on HOME and FROM DATABASE as shown below. In this case we are linking to an Access database

Datastream into PowerPivot

2 minutes Easy

A bit more about the Microsoft Azure market and what it can do with regards your PowerPivot use.