Excel has seen many updates over the years, but one of its most transformative innovations this decade has been the introduction of the GROUPBY function. This powerful function enables users to replicate PivotTables with exciting benefits that make data analysis more efficient and flexible than ever.
Join us for an exclusive deep dive with expert presenter David Benaim, who will demonstrate everything you need to know about these revolutionary functions. You’ll learn how to:
- Create dynamic tables that refresh automatically, saving time and effort
- Use advanced functions like MEDIAN or ARRAYTOTEXT, perfect for tasks like creating comma-separated lists of data (e.g. "Book customers: Warren, Jane, Linda")
- Perform custom aggregations, including distinct counts and unique ARRAYTOTEXT outputs
- Apply these functions to modern charts like maps, waterfalls, and sunbursts—unlocking visualisation capabilities that PivotTables don’t support
Whether you’re looking to futureproof your Excel skills or discover the next big thing in data analysis, this session is for you. Don't miss your chance to explore these game-changing tools with a true Excel expert.
David Benaim
