Pivot Tables are a powerful capability of Excel, however MOSS now provides the capability to create a pivot table from data in a SharePoint list. This example will show you how to use a SharePoint list to create a pivot table and then display it back in SharePoint using the Excel Web Access web part.

SharePoint Explained: Yes/No fields aren’t your friend – Why Choice fields are a better option

focus is on End User topics including SharePoint Project Planning, Governance, and Design. Additionally, I’ve co-authored a book with Nicola Young focused on solving business problems with MOSS.