GROUPBY and PIVOTBY functions. Pivot table killers?
Duration: 60 Minutes
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.
- Explain the fundamentals of GROUPBY and PIVOTBY
- Compare these functions with traditional pivot tables and choose the right tool
- Build summaries that update automatically when data changes
- Apply multi-level grouping, custom aggregation and dynamic sorting
- 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
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.
- Data Analysts
- Financial Analysts
- Business Intelligence Analysts
- Quality Analysts
- Any Role that involves Data Analysis
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.
Upcoming Webinars
By Margie Faulk
Date: Nov. 2, 2026
By Dr. Sean Stein Smith
Date: Nov. 2, 2026
By Dr. Susan Strauss
Date: Nov. 2, 2026
By Don Phin
Date: Nov. 3, 2026
By Pete Tosh
Date: Nov. 4, 2026
By Bruce Lee
Date: Nov. 4, 2026
By Donna K Olheiser
Date: Nov. 5, 2026
By Carolyn Troiano
Date: Nov. 6, 2026
By William Mack Copeland
Date: Nov. 6, 2026
By Edwin Waldbusser
Date: Nov. 9, 2026
By Dev Strischek
Date: Nov. 9, 2026
By Cathy Horwitz
Date: Nov. 10, 2026
By Paul Pelletier
Date: Nov. 10, 2026
By Lesley Crook
Date: Nov. 13, 2026
By Dr. Susan Strauss
Date: Nov. 16, 2026
By David Nettleton
Date: Nov. 17, 2026
By Dr. Bill Trombetta
Date: Nov. 17, 2026
By Allen Evitts
Date: Nov. 17, 2026
By Diane L. Dee
Date: Nov. 19, 2026
By Abdelrahman Abdou
Date: Nov. 19, 2026
By Meredith Crabtree
Recorded Session
By Carolyn Troiano
Recorded Session
By Kelly Thomas
Recorded Session
By Rachelle D Souza
Recorded Session
By Marcia Zidle
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Margie Faulk
DOL Reverses Course on Independent Contractor Rule for 2026! How Will Employers Adapt to the Change?
Recorded Session
By Mike Thomas
Recorded Session
By Marcia Zidle
Recorded Session
By Ritu Arora
Recorded Session
By Diane L. Dee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Diane L. Dee
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Bruce Lee
Recorded Session
By Charles H. Paul
Recorded Session
By Marcia Zidle
Recorded Session
By Audrey Halpern
Recorded Session
By Marcia Zidle
Recorded Session
By Ronald L. Adler
Recorded Session
