Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Creating and Customizing Pivot Charts in Excel - From Data Preparation to Advanced Filtering

Kevin Stratvert via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Master the creation and customization of pivot charts in Excel through this comprehensive 12-minute video tutorial. Learn to format data in columns, insert pivot charts via the Insert tab, and understand the functionality of fields for constructing dynamic visualizations. Discover techniques for changing chart types, applying filters to refine data presentation, and manipulating row and column arrangements. Explore design and formatting options to enhance visual appeal while gaining practical knowledge about data summarization and analysis. Access a downloadable sample workbook to practice alongside the tutorial and build confidence in creating interactive charts that effectively communicate data insights. Develop essential Excel skills that extend to pivot table creation, enabling powerful data analysis and presentation capabilities.

Syllabus

Introduction
Prepare data
Insert pivot chart
PivotChart fields
Drag fields between areas
Change chart type
Design and format
Filter field
Insert new pivot chart
Switch row and column
Filters area
Wrap up

Taught by

Kevin Stratvert

Reviews

Start your review of Creating and Customizing Pivot Charts in Excel - From Data Preparation to Advanced Filtering

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.