So I've been spending some more time analyzing publicly available energy data after a recent big data/statistics event I attended. Excel 2013 has some great new features that add on to the pivot tables, charts and graphs that you may have known before.
I am a big map guy, so I have been particularly impressed by the Powerview Mapping functionality that they now offer. Take a look at one of their demos here.
Also you can't forget the moving bubble chart, a classic in TED Talks for some time now. It's possible now to easily manipulate data this way with some strong excel knowledge, and PowerView.
Regardless, it opens up the door for better dashboards, easier access to actionable intelligence from your SQL server database, and more user friendly results. Just another reason why MS Excel is so great.