Has anyone on the forum who is a regular 365 user got access to these new functions yet, or is it still only the Beta group? 

Why I'm asking is that I've got the need to add formulae to a spreadsheet together with the results of a dynamic pivot table, and I have no idea how to approach it currently without doing some heavy lifting with DAX. But the GROUPBY function seems great for use in a spreadsheet where its output can be used by other formulae. Its frustrating that all the internet excel gurus have demonstrated the use of these functions months ago, but we still have no idea when they'll be rolled out.