To conclude our series covering menu tabs, we will cover the Power Pivot menu options in Excel.

Welcome back to our Power Pivot blog series. In the previous two blogs we’ve covered the ‘Home’ tab, and the ‘Design’ tab, can you guess what’s next?

oday, we consider some of the menu options in the Power Pivot window, focusing on the Design tab.

Today we consider some of the various menu options in the Power Pivot window...

Today we discuss what are relationships (in Power Pivot) and how we may create them...

Today we discuss formatting and changing table properties.

In this post, we discuss how to import data from an Access database.

Today we look at filtering the data a little before importing it form Excel.

Once data is loaded into Power Pivot it is unable to be changed from the Power Pivot window. To get around this issue, we can load data from Excel...

Let's go through some of the different methods to import data...