Have you found this content useful? Use the button above to save it to your profile. Business intelligence expert Philip Taylor (aka ExcelCrafter) puts the case for using the PowerPivot add-in for ...

If your are wondering how to handle large datasets and complex calculations in your spreadsheets. This is where MS Excel PowerPivot comes into play. PowerPivot is an advanced feature in Excel that ...

Top N reports are an extremely common requirement: my customers are always trying to find their top 10 products or sales people or geographies by some measure or other. Luckily this type of report is ...