Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Sorting and Filtering: PivotTables in Excel

Advanced Sorting and Filtering: PivotTables in Excel

Unlock PivotTable functions to summarize, compare, and visualize complex data insights.
Created bySimon Sez IT
Last updated 12/2024
English

What you'll learn

  • 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.

Course content

2 sections • 11 lectures • 53m total length

  • Course Introduction2:51
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:23
  • DOWNLOAD ME: Exercise Files0:23
  • Summarizing Values11:24
  • Show Values As9:12
  • Exercise1:45
  • Section Quiz

Requirements

  • Basic Excel knowledge.
  • Basic PivotTables Skills.
  • Basic data analysis.
  • Microsoft Excel that supports PivotTables (Excel 2016 or later is recommended, though Excel 2013 will also suffice).

Description

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:

  1. 51 minutes of video tutorials

  2. 8 individual video lectures

  3. Course and Exercise Files to follow along

  4. Certificate of completion

Who this course is for:

  • Professionals who need to efficiently summarize, analyze, and present large datasets.
  • Individuals seeking to improve their ability to manipulate and visualize complex data through PivotTables.
  • Those who need to summarize financial data, track trends, and perform dynamic comparisons.
  • Those involved in analyzing customer behavior, sales performance, and other marketing metrics using data.
  • Learners looking to gain practical skills in Excel, particularly in summarizing, analyzing, and visualizing data for business decision-making.

Report abuse