Lessons Archive

PowerPivot Date Table

Length: 10 minutesComplexity: Easy

In normal Excel and Pivots you have some options if Excel recognized that a column contained dates. So for example you can group a date column in a Pivot Table in months, weeks, quarters, years etc.

Datastream into PowerPivot

Length: 2 minutesComplexity: Easy

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

Databases into PowerPivot

Length: 10 minutesComplexity: 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

Text files in PowerPivot

Length: 10 minutesComplexity: 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

Unlinked Excel file in PowerPivot

Length: 10 minutesComplexity: Easy

You can import data from an Excel file that is NOT the Excel file through which you opened the PowerPivot window.

Linked Excel file in PowerPivot

Length: 15 minutesComplexity: 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.

Activate PowerPivot

Free Preview

Length: 10 minutesComplexity: Easy

How to activate PowerPivot for first time use

Differences between Excel and PowerPivot use

Free Preview

Length: 30 minutesComplexity: 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.

How do I know if I have PowerPivot?

Free Preview

Length: 10 minutesComplexity: Easy

power pivot training courses

How to check whether you already have PowerPivot and how to switch it on if it is not available to you.

Dax Measures in PowerPivot

Free Preview

Length: 10 minutesComplexity: Standard

power pivot training courses

How to create and use DAX measures in your PowerPivot pivot tables

The PowerPivot Ribbon

Free Preview

Length: 15 minutesComplexity: Easy

power pivot training courses

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

PowerPivot vs Pivot Table

Free Preview

Length: 10 minutesComplexity: 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.