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

Introduction to PivotTables and PivotCharts in Excel

Master data organization and visualization with PivotTables and PivotCharts for streamlined analysis and insights.
Created bySimon Sez IT
Last updated 1/2025
English

What you'll learn

  • Create PivotTables from scratch for data organization.
  • Apply subtotals and grand totals for data summarization.
  • Format PivotTable data with number formatting techniques.
  • Generate PivotCharts to visualize data effectively.
  • Insert and format slicers for interactive data filtering.
  • Update PivotTable data dynamically for real-time analysis.

Course content

3 sections • 26 lectures • 1h 56m total length

  • Course Introduction2:07
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:24
  • DOWNLOAD ME: Exercise Files0:22
  • PivotTables Explained2:12
  • Creating a PivotTable from Scratch4:48
  • Pivoting the PivotTable Fields5:30
  • Applying Subtotals and Grand Totals3:14
  • Applying Number Formatting to PivotTable Data2:59
  • Show Values As and Summarize Values By5:51
  • Grouping PivotTable Data5:39
  • Formatting Error Values and Empty Cells5:03
  • Choosing a Report Layout4:31
  • Applying PivotTable Styles4:50
  • Exercise 014:05
  • Section Quiz

Requirements

  • Basic Excel knowledge.
  • Data organization skills.
  • Experience with basic Excel formulas.
  • Access to a Microsoft Excel version that supports PivotTables and PivotCharts.

Description

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


Welcome to "Introduction to PivotTables and PivotCharts in Excel." This course teaches you the essentials of organizing and visualizing data using PivotTables and PivotCharts. You'll grasp the fundamentals of PivotTables, including creating them from scratch, applying subtotals, and formatting data effectively. Then, you'll delve into PivotCharts, mastering the art of creating and formatting dynamic visual representations of your data.


By the end of the course, you should be able to understand how to add interactivity to your PivotTables and charts using slicers and timelines, enhancing your ability to analyze and present data efficiently. Whether you're a beginner seeking to streamline data analysis or a professional aiming to improve your Excel skills, this course equips you with invaluable data management and visualization tools. Join us and unlock the power of PivotTables and PivotCharts in Excel.


In this course, you will learn how to:

  • Create PivotTables from scratch for data organization.

  • Apply subtotals and grand totals for data summarization.

  • Format PivotTable data with number formatting techniques.

  • Generate PivotCharts to visualize data effectively.

  • Insert and format slicers for interactive data filtering.

  • Update PivotTable data dynamically for real-time analysis.


This course includes:

  1. 114 minutes of video tutorials

  2. 23 individual video lectures

  3. Course Files to follow along

  4. Certificate of completion

Who this course is for:

  • Individuals who are new to Excel and want to learn foundational skills in data organization and visualization.
  • Business professionals who regularly work with data and want to enhance their reporting and data analysis capabilities.
  • Data Analysts and Researchers looking to efficiently summarize, organize, and present data insights to inform decision-making.
  • Professionals who oversee projects and need to create reports that summarize data trends and project metrics effectively.

Report abuse