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