Creating Pivot Tables with the GROUPBY function | Everyday Office скачать в хорошем качестве

Creating Pivot Tables with the GROUPBY function | Everyday Office

One of the newest Excel functions is GROUPBY. It's job - similar to PIVOTBY - is to effectively create a Pivot Table from a data set, choosing which columns to 'group by,' and which columns to add functions to. In this video tutorial, Neil Malek from Knack Training demonstrates how this tool can be used. Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on: http://www.knacktraining.com/blog/ http://www.knacktraining.com/podcast/ Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.