Microsoft Excel Tutorial: Three New Functions Debut in Excel: GROUPBY, PIVOTBY, and PERCENTOF.
To download the workbook from today: Excel - First Look GroupBy PivotBy PercentOf Functions - Episode 2633 Sample Files - MrExcel Publishing
Read the Microsoft Announcement: New aggregation functions: GROUPBY and PIVOTBY
Welcome to episode 2633 of MrExcel's netcast, where we explore the latest and greatest features of Microsoft Excel. In this episode, we will take a first look at three new functions: GROUPBY, PIVOTBY, and PERCENT OF. These functions are incredibly simple to use, yet offer deep options for data analysis. So let's dive in and see what they can do!
First up, we have GROUPBY. This function allows us to group data by categories...