Uploaded April 2026 | Updated November 2026, 2 days ago
Download the Excel file used in the video: excelcampus.com/pivot-tables/excel-summary-reports-formulas-pivot-tables
When your boss asks for a summary report, knowing how to analyze data with both formulas and pivot tables is essential. This Excel tutorial shows you how to use powerful features like UNIQUE, SUMIFS, GROUPBY, and pivot tables to create quick data insights. You will learn when to use each technique and how to prevent outdated reports that can cause embarrassing mistakes.
Additional Resources:
📰Subscribe to our free Excel Pro Tips Newsletter:
excelcampus.com/free
🧠Latest Free Masterclass on Excel & AI: excelcampus.com/blueprint-live-replay
▶️Related Videos:
Beginners Guide to Excel Tables: youtu.be/fJnJTff4Na8
Automatically Refresh Pivot Tables: youtu.be/NI1UQcYtl1A
0:00 Introduction
0:20 Data Preparation with Excel Tables
1:11 Creating Summary Reports with UNIQUE & SUMIFS Functions
4:11 Using the GROUPBY & PIVOTBY Functions
5:26 Building Summary Reports with Pivot Tables
8:53 Comparing Summary Report Techniques
Download the Excel file used in the video: excelcampus.com/pivot-tables/excel-summary-reports-formulas-pivot-tables
When your boss asks for a summary report, knowing how to analyze data with both formulas and pivot tables is essential. This Excel tutorial shows you how to use powerful features like UNIQUE, SUMIFS, GROUPBY, and pivot tables to create quick data insights. You will learn when to use each technique and how to prevent outdated reports that can cause embarrassing mistakes.
Additional Resources:
📰Subscribe to our free Excel Pro Tips Newsletter:
excelcampus.com/free
🧠Latest Free Masterclass on Excel & AI: excelcampus.com/blueprint-live-replay
▶️Related Videos:
Beginners Guide to Excel Tables: youtu.be/fJnJTff4Na8
Automatically Refresh Pivot Tables: youtu.be/NI1UQcYtl1A
0:00 Introduction
0:20 Data Preparation with Excel Tables
1:11 Creating Summary Reports with UNIQUE & SUMIFS Functions
4:11 Using the GROUPBY & PIVOTBY Functions
5:26 Building Summary Reports with Pivot Tables
8:53 Comparing Summary Report Techniques


