247Compliance appLinks, recordings and certificates
Open
Questions? Call +1-661-336-9555 Group training quotes Get the app
ON-DEMAND Software

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.

FormatRecorded sessionWatch any time
Length60 minutes
Abdelrahman Abdou Speaker Abdelrahman Abdou
Talk to an expertAsk an expertQuestions about this topic

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

Data AnalystsFinancial AnalystsBusiness Intelligence AnalystsQuality AnalystsAny Role that involves Data Analysis

What you get

CertificateEmailed to each attendee after the session.
HandoutsSlides and checklists to reuse with your team.

About the speaker

Abdelrahman Abdou
Abdelrahman Abdou

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.

All webinars by Abdelrahman Abdou →
From$219On-demand · watch any time Enroll now