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 SHOULD YOU 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.
AREA 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
LEARNING OBJECTIVES
- 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
WHO WILL BENEFIT?
- Data Analysts
- Financial Analysts
- Business Intelligence Analysts
- Quality Analysts
- Any Role that involves Data Analysis
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.
- 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
- 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
- Data Analysts
- Financial Analysts
- Business Intelligence Analysts
- Quality Analysts
- Any Role that involves Data Analysis