Advanced Sorting and Filtering: PivotTables in Excel
Master PivotTables: easily summarize, analyze, and visualize data for powerful insights. Learn to compare and gain clarity from complex information.
Course Content
Advanced Sorting and Filtering: PivotTables in Excel is an advanced Udemy course taught by Simon Sez IT. It runs 52m, is taught in English, and includes a certificate of completion. It is a paid course, first published April 2025.
Welcome to Advanced PivotTables in Excel, the ultimate course to master data analysis and excel reporting! This course is designed to help you elevate your Excel skills and gain deeper insights from your data.
You'll learn powerful techniques to summarize data efficiently and compare data dynamically using PivotTables. We'll cover everything you need to know to streamline your data analysis and present your findings clearly.
What you'll discover:
- Summarize Values By: Learn to aggregate data using functions like sum, average, min, max, and more with the flexible "Summarize Values By" option.
- Sorting in PivotTables: Master various sorting methods to arrange your data alphabetically or numerically, in ascending or descending order. Discover how to create custom sorting orders tailored to your specific requirements.
- Calculate Percentage of Grand Totals: Easily calculate the percentage contribution of each item to the overall total.
- Display Running Totals: Understand how to display running totals to track cumulative values.
- Compare with Previous Items: Learn to effectively compare values to previous entries for trend analysis.
- Rank Values: Rank values from smallest to largest to quickly identify top and bottom performers.
- Basic PivotTable Sorting: Perform basic sorting directly within your PivotTables.
- Manual Sorting: Utilize manual sorting by dragging and dropping items for quick adjustments.
- Custom Sorting Orders: Apply custom sorting orders to prioritize the most relevant data.
Course Features:
- 51 minutes of video tutorials: Concise and focused video lessons.
- 8 individual video lectures: Easy-to-follow video breakdowns of key concepts.
- Downloadable Course & Exercise Files: Includes course and exercise files to follow along and practice.
- Certificate of Completion: Receive a certificate upon successful completion.
This course includes downloadable course instructor files and exercise files to work with and follow along. Whether you're a beginner looking to build a solid foundation or an experienced Excel user seeking to take your PivotTable skills to the next level, this course provides the tools and knowledge you need.
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.