Explore GROUPBY and PIVOTBY Functions in Excel (NEW EXCEL FEATURES!)

In this quick demo, Chris Dutton breaks down exactly how the new GROUPBY and PIVOTBY Functions in Excel work!

💪 Access ANY aggregation mode within a single GROUPBY or PIVOTBY function (or define your own with LAMBDA)
💪 Replace thousands of SUMIFS or COUNTIFS with a single formula (dynamic arrays FTW!)
💪 Customize headers, totals, sort order and filters using simple and intuitive formula arguments

Interested in learning more about Excel from the pros?

Check out our NEW cohort learning experiences!

Admissions for our Excel and SQL immersive programs are OPEN; in just 10 weeks, you could master a new tool and take your data career to the next level!

Key Deadlines:
Early Bird – Save 10%: Friday, February 2nd
Admissions Close: Wednesday, February 7th
Here's what you can expect from each immersive...
✔️ Guided portfolio projects!
✔️Access to your own private learning community!
✔️ Weekly, 1-hour live sessions with recordings!
✔️ Live support from expert instructors!
✔️ Unlimited Maven access extending two months past the end of the program!
...and all of this is built into a program that's designed to fit into your busy life, at a more affordable price.
Space is limited; secure your seat today!

Happy learning!

Our January Jumpstart event is officially LIVE!!!
A recap of what you can expect this month…
🔓 FREE ACCESS TO 3 MAVEN EXCLUSIVE COURSES!
During January Jumpstart, Free Users will have unlimited access to three of our most popular courses from January 9th - 31st: Thinking Like an Analyst, Launching Your Data Career, and ChatGPT for Data Analytics!
📅 LIVE WEBINARS!
Meet our instructors and accelerate your career with sessions on resume writing, project portfolios, LinkedIn profiles, and interview skills!
🛠️ PRIVATE CAREER WORKSHOPS!
Workshop your resume, portfolio, LinkedIn profile, and job interview skills with the Maven pros in a small-group setting! (This is by invitation only; you MUST ATTEND the themed Tuesday webinar to join the workshop!)

[JennyR-gw]

Awesome, thank you! I always use pivots, we will see if this can speed it up for me. Appreciate the introduction!

[SBaloch]

Glad to see the Maven Analytics YouTube channel, now it will be easy to get simple solutions to complex problems.

[banihas]

First, a Power BI update video and now this! Well done Maven team. I'm a Maven App subscriber but I like to see this content as well since it's so accessible rather than revisiting a course.

[OmerMan]

That's honestly amazing. I wish MS would have taken it just one step further by turning what we see in minute 03:26 to a real groupby view (having the location shown once and maybe centered vertically instead of all these dupliactions), but it's an easy fix so that part isn't too bad and overall these are absolutely great functions. Thanks for sharing!

[oragreenough]

Great video of how the Groupby & Pivotby are awesome new Excel formulas. I have been playing around with them and they are great. One thing I was wondering is there anywhere to group together multiple items (like with pivot table groupings), for example if you have data on fruit and want apple, oranges, and bananas separate but what to group all other fruit together as Misc (grapes, peaches, plums, watermelon, ect..)? Any thoughts on how can be done using these formulas??

[christianwiah]

Always, wonder lecture! Easy to follow. Thank you!

[asvathg]

Will you be updating these new features in your Udemy Pivot Tables course?

[mirrrvelll]

Good one, but is this only in beta channel?

[Himanshu]

I'm not able to access these functions in beta channel too, can anyone help?