GROUPBY and PIVOTBY functions. Pivot table killers?
Learn to use Excel's GROUPBY and PIVOTBY functions to build pivot-style summaries that update automatically, with multi-level grouping, custom aggregation and dynamic sorting.
Speaker
Abdelrahman Abdou
Overview
Excel's GROUPBY and PIVOTBY functions let you build summaries that look like pivot tables but recalculate on their own, with no manual refresh. This 60-minute Excel training explains how they work and how to use them well in your reports.
You'll start with the basics and see where these functions have the edge over traditional pivot tables. The session then shows how results stay current as source data changes and moves on to more advanced uses, including multi-level grouping, custom aggregation and dynamic sorting.
Why attend: Pivot tables need refreshing every time the data changes, which is easy to forget. GROUPBY and PIVOTBY update in real time, so they can simplify complex data work and make reports more dependable. This session suits data analysts, financial analysts, business intelligence and quality analysts, and anyone whose role involves analyzing large datasets in Excel.
What’s covered
- Fundamentals of GROUPBY and PIVOTBY
- Benefits compared with traditional pivot tables
- Real-time updates as your data changes
- Multi-level grouping
- Custom aggregation
- Dynamic sorting
Who should attend
What you get
About the speaker
Abdelrahman Abdou is an experienced Excel and Power BI Trainer and Consultant with over 10 years of expertise in reporting, business intelligence, and data analytics, Abdelrahman has worked with some of the largest telecom companies in Egypt and Canada. Their extensive background in data analysis and visualization makes them a highly sought-after consultant and educator.
As a dedicated trainer and consultant, Abdelrahman specializes in helping clients master Excel and Power BI. They conduct live sessions, webinars, and in-class training, focusing on automating reporting processes, creating insightful dashboards, and leveraging advanced Excel functions for efficient data management.

