Sunday Night Music – Pivot tables – the Musical!

Pivot Tables Make Everything Just Right

Just watch and enjoy.

Pivot Tables Make Everything Just Right

A class project featured on YouTube and Blogs.Office.Com singing the praises of Pivot Tables

Just watch and enjoy, or go through to YouTube -where you can expand the info section to see the words and sing along..

PowerPivot for Excel 2010 and SharePoint 2010

On Friday, I was catching up on my podcasts and listing to Hilton Giesenow’s The MOSS Show and in Episode 34 Hilton interviews Pej Javaheri from the SharePoint B.I. team at Microsoft about Business Intelligence and SharePoint.

What got my attention was PowerPivot which is an add-in for Excel or SharePoint that allows you to connect to large tables of data to do pivot table like analysis.

On Friday, I was catching up on my podcasts and listing to Hilton Giesenow‘s The MOSS Show and in Episode 34 Hilton interviews Pej Javaheri from the SharePoint B.I. team at Microsoft about Business Intelligence and SharePoint.

What got my attention was  PowerPivot which is an add-in for Excel or SharePoint that allows you to connect to large tables of data to do pivot table analysis.

PowerPivot Tools as seen on Excel 2010 ribbon
PowerPivot Tools as seen on Excel 2010 ribbon
PowerPivot Window Tools
Tools Shown in PowerPivot for Excel window

Continue reading “PowerPivot for Excel 2010 and SharePoint 2010”

Grouping by Dates in Pivot Tables Excel 2010/2007

How to summarize data in Pivot Tables using Dates. Very useful if you need to summarize point of sale data, maintenance or expense records by month, week or fortnight (14 days)

How to summarise data in Pivot Tables using Dates. Very useful if you need to summarize point of sale data, maintenance or expense records by month, week or fortnight (14 days) Continue reading “Grouping by Dates in Pivot Tables Excel 2010/2007”

How to Create Calculated Items in Pivot Tables

Excel 2007/2010 How to Create Calculated Items in Pivot Tables

Calculated Items in Excel Pivot Tables allow you to make categories from existing categories. This Tutorial shoes you how!

Continue reading “How to Create Calculated Items in Pivot Tables”

Calculated Fields in Pivot Tables

The following short movie illustrates preparing calculated fields in pivot tables in Excel 2010. This technique is very similar for Excel 2007. This is the first of a short series on Pivot Tables that I am preparing.

The following short movie illustrates preparing calculated fields in pivot tables in Excel 2010. This technique is very similar for Excel 2007.  This is the first of a short series on Pivot Tables that I am preparing.

Requires Flash Player 9 or better. Continue reading “Calculated Fields in Pivot Tables”