Outside of VBA, Excel's single most powerful feature is PowerPivot, which is an official MS add-in for Excel that takes pivoting not just to the next level, but to a whole other world.
With PowerPivot you can connect to your enterprise databases, analyze data, create advanced reports & prepare dashboards right from familiar interface of Excel.
You should learn as much as you can about PowerPivot if you are looking for ways to enhance your skills in data analysis, pivoting & reporting areas. To do so, you'll need Excel 2010 or newer.
This is a big subject and if you want to get up to speed quickly and learn the secrets of how best to capitalize on PowerPivot my recommendation is to take Chandoo's new PowerPivot course.
If you are familiar with Excel and PivotTables and you want to take your career to the next level then it's time to learn PowerPivot now.
.
