Advanced Sorting and Filtering: PivotTables in Excel

About this course

This course includes downloadable course instructor files and exercise files to work with and follow along.Welcome to Advanced PivotTables in Excel, designed to elevate your data analysis skills.In this course, you'll explore techniques to summarize values efficiently and compare data dynamically. You'll learn how to utilize the Summarize Values By option to aggregate data using various functions like sum, average, min, max, and more. You'll also explore sorting methods to arrange your data alphabetically or numerically, ascending or descending, based on various fields. Gain insights into custom sorting orders tailored to your specific needs.Each module includes video demonstrations and practical exercises to ensure you master each concept. Whether you're looking to streamline your data analysis or present your findings clearly, this course will provide you with the necessary tools and knowledge. Join us and take your PivotTable skills to the next level.In this course, you will learn how to:Calculate the percentage of grand totals.Display running totals for values.Compare values with previous items.Rank values from smallest to largest.Perform basic sorting in PivotTables.Utilize manual sorting by dragging items.Apply custom sorting orders in PivotTables.This course includes:51 minutes of video tutorials8 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion