From the course: Excel Formulas and Functions Quick Tips
Join today to access over 24,800 courses taught by industry experts.
Use GROUPBY to aggregate data - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Use GROUPBY to aggregate data
- [Instructor] You can aggregate data easily using the new GROUPBY function. The function can group and display your data like a pivot table. However, GROUPBY is only available for Microsoft 365 users. GROUPBY has three required elements. What to group, in this case, all group product category. The specific values to collect. In this case, I want a total quantity sold of each category and the function that we want to use to aggregate the data, such as a sum, or an average. Close the parentheses, and here's my table. GROUPBY will update automatically when the data changes. You can also include the headers as an optional parameter.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.