Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Sort, Filter, and Update PivotTables in Excel for Beginners

Sort, Filter, and Update PivotTables in Excel for Beginners

Master sorting, filtering, and updating data with PivotTables, your first step to smarter data analysis!
Created bySimon Sez IT
Last updated 4/2025
English

What you'll learn

  • Master sorting and filtering techniques for efficient data analysis.
  • Learn advanced filtering methods like label and value filters.
  • Discover how to use the top 10 filter to focus on key data points.
  • Update PivotTables and PivotCharts with new data using one-click refresh.

Course content

1 section • 12 lectures • 37m total length

  • Course Introduction5:01
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:23
  • DOWNLOAD ME: Exercise Files0:23
  • Sorting Pivot Table Data8:30
  • Filtering Pivot Table Data7:20
  • Top 10 Filter3:30
  • Exercise1:56
  • Adding Data to the Dataset2:37
  • Updating Pivot Tables and Pivot Charts1:40
  • Exercise1:39
  • Course Close1:52
  • Course Quiz

Requirements

  • Basic Excel skills
  • No prior experience with PivotTables is needed, but some familiarity with organizing and analyzing data in Excel is helpful.
  • Access to a desktop version of Microsoft Excel (2016 or newer is recommended).

Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**


Welcome to PivotTables for Beginners, your gateway to mastering one of Excel's most powerful data analysis tools. This beginner-friendly course teaches you how to sort your data logically, whether by sum of profit, alphabetical order, or custom criteria. Furthermore, master the art of updating your data seamlessly with one click. PivotTables are essential for anyone looking to gain insights from data, whether for business decisions, measuring KPIs, or spotting trends.


Join us and transform how you handle data with PivotTables, making your analysis more dynamic and efficient. Course files are included and available to download, allowing you to follow along and practice as you learn. Dive in and discover how PivotTables can enhance your data analysis skills today.


In this course, you will learn how to:

  • Master sorting and filtering techniques for efficient data analysis.

  • Learn advanced filtering methods like label and value filters.

  • Discover how to use the top 10 filter to focus on key data points.

  • Update PivotTables and PivotCharts with new data using one-click refresh.


This course includes:

  1. 36 minutes of video tutorials

  2. 9 individual video lectures

  3. Course and Exercise Files to follow along

  4. Certificate of completion

Who this course is for:

  • Those who are new to PivotTables and want to streamline their data analysis process with easy-to-follow steps.
  • Entry-level employees, interns, or anyone starting in roles like data entry, marketing, finance, or business analysis who need to make sense of large datasets.
  • Entrepreneurs looking for a quick and efficient way to track sales, analyze profits, or monitor key business metrics.
  • Individuals wanting to add valuable Excel skills to their resume to stand out in the job market.

Report abuse