In partnership with Experts Exchange.
You will now be able to create Excel pivot tables with a function! That means they will be dynamic, more portable and more flexible. The functions are called Groupby and Pivotby, and they are very similar. They are still in beta, so it might be a few months until you have them available.