PowerPivot Blog Posts

In my last blog, I showed you how easy it was to use Power Pivot to produce a Pivot table that pulled in data across two tables, Drinks and Categories (without using a Vlookup).  Well, we’re going to carry on ditching the Vlookup by looking at Power Pivot’s equivalent function, called “Related” Remember in our fictitious wine bar (in down town Billingshurst) we were able to find out that we stock most drinks that are from the “Wines” category;- But… Read More

If you don’t want to suffer from premature ageing, the most important thing is to move with the times and not get set in your ways.  This might be a traumatic thought for Excel users who have been so attached to the Vlookup Function for the past 20 years that giving it up might be like losing a beloved relative. Why is the Vlookup Function “so last year”?  Well, one of the best new features in Excel 2013 is the… Read More

Continuing with our look at PowerPivot. You should now have PowerPivot installed as an add-on to Excel, and configured some data connections to it. My most recent blog post showed how we can create relationships between disparate data imported or connected to PowerPivot. Now, with some data available, we can start to create a Pivot Table. Creating PivotTables with PowerPivot To create a PivotTable from the tables in the PowerPivot window, you can either use the icon on the PowerPivot tab… Read More

If you've been following these blog posts, you'll have PowerPivot installed in Excel (click here to read PowerPivot 1). Now we'll start to get some data into PowerPivot, and as you'll see this is one of the most powerful ways you can join together disparate data. Once PowerPivot is installed, click on the PowerPivot Window Icon on the Excel ribbon. This opens the PowerPivot client window, a separate window that controls PowerPivots's access to data. From here you can import data into PowerPivot, as… Read More