Business intelligence expert Philip Taylor (aka ExcelCrafter) puts the case for using the PowerPivot add-in for management and financial reporting.
Unlike earlier versions, Excel 2010 offers two approaches to building a PivotTable from a worksheet range:
- The first is the usual method of clicking in the range and then, on the Insert tab, clicking PivotTable - AccountingWEB’s Excel Zone provides a wealth of resources and tutorials on this technique.
- The second approach uses the PowerPivot add-in, a free download for Excel 2010 users available from Microsoft: Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010.
Early adopters of Excel 2013 will require the Office Professional Plus version to take advantage of the functionality described in this article. Enable the add-in which is automatically installed as part of the Office 2013 installation (named Microsoft Office PowerPivot Add-in for Excel 2013).
Creating a PivotTable with PowerPivot
The steps required for creating a PivotTable using PowerPivot are easier than you might think. Register with AccountingWEB.co.uk to see the full article which takes you step-by-step through the process. For further information on PowerPivot, visit the Microsoft PowerPivot page and ExcelZone’s previous tutorials about the add-in.
Philip Taylor is a business intelligence architect/developer who operates an Excel/BI information-and-products web site, www.excelcraft.com