Groupby & Pivotby Excel Functions

Online course: Excel 365 for Busy People
www.udemy.com/excel90min
Corporate training for Excel and other Microsoft and Adobe applications:
ComputerTraining.Live
Between the Sheets, Episode 56:
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.