Basic data analysis and an intermediate level of Excel skills are expected. Familiarity with Pivot Tables is assumed. Basic knowledge of VBA scripting and SharePoint would be useful but not necessary.
The software required are Microsoft Excel 2010 and PowerPivot for Excel add-in, which are mandatory. PowerPivot for SharePoint and SharePoint Server 2010 are not mandatory, as a user can access them remotely on a SharePoint Server that has Excel services and PowerPivot for SharePoint.