Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced PivotTables and PivotCharts in Excel
Rating: 5.0 out of 5(1 rating)
18 students

Advanced PivotTables and PivotCharts in Excel

Master Advanced PivotTables and PivotCharts to customize, analyze, and visualize data with precision and flexibility.
Created bySimon Sez IT
Last updated 1/2025
English

What you'll learn

  • Customize PivotTables with unique styles and formatting.
  • Sort data using custom lists for specific ordering.
  • Apply multiple filters to data for precise analysis.
  • Adjust slicer settings to enhance data visualization.
  • Create calculated fields and items for advanced analysis.
  • Utilize dynamic features in PivotCharts for interactive visuals.

Course content

2 sections • 20 lectures • 2h 13m total length

  • Course Introduction2:09
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:24
  • DOWNLOAD ME: Exercise Files0:22
  • Creating a Custom PivotTable Style9:48
  • Applying Custom Number Formatting10:02
  • Sorting Using Custom Lists4:38
  • Applying Multiple Filters to Data5:06
  • Adjusting Slicer Settings12:03
  • Locking Workbooks But Not Slicers3:18
  • Creating a Calculated Field8:02
  • Creating a Calculated Item6:30
  • Solve Order8:12
  • GETPIVOTDATA11:54
  • GETPIVOTDATA: Dependent Data Validation Lists8:38
  • Section Quiz

Requirements

  • Basic Excel knowledge.
  • Understanding of basic PivotTables.
  • Access to Microsoft Excel 2016 or newer.
  • Computer with internet access to access course materials.

Description

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


In this Advanced PivotTables and PivotCharts in Excel course, you'll explore advanced data analysis and visualization techniques. You'll learn to customize PivotTables by creating custom styles, applying unique number formatting, and sorting data using custom lists.


Additionally, you'll master the art of applying multiple filters and adjusting slicer settings for precise data manipulation. You'll gain insights into complex data relationships by creating calculated fields and items.


The course also covers the GETPIVOTDATA function, enhancing your ability to extract specific data points efficiently. In the PivotCharts section, you'll discover how to create dynamic titles and series and add totals to stacked column charts. Mastering these advanced Excel features will significantly enhance your data analysis skills and streamline decision-making processes.


In this course, you will learn how to:

  • Customize PivotTables with unique styles and formatting.

  • Sort data using custom lists for specific ordering.

  • Apply multiple filters to data for precise analysis.

  • Adjust slicer settings to enhance data visualization.

  • Create calculated fields and items for advanced analysis.

  • Utilize dynamic features in PivotCharts for interactive visuals.


This course includes:

  1. 130 minutes of video tutorials

  2. 17 individual video lectures

  3. Course and Exercise Files to follow along

  4. Certificate of completion

Who this course is for:

  • Excel users who want to take their skills to the next level.
  • Data Analysts and Data Enthusiasts who are working with large data sets and need to make sense of complex information.
  • Anyone who makes data-driven decisions and wants to streamline their analysis processes.
  • Students and career starters in data-related fields.

Report abuse