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...

Unfortunately, Power Pivot doesn’t work in all versions of Excel. We discuss Power Pivot’s compatibility with different versions of Excel...

Want to create a PivotTable where formatting “sticks” and data may be referenced from a myriad of various sources at the same time?