Learn the Skills Netflix, Meta, and Capital One Actually Hire For
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Master the art of creating and customizing data visualizations in Excel through this comprehensive 25-minute tutorial. Learn essential techniques for generating various chart types including line, pie, bar, and pivot charts while exploring formatting options and best practices. Discover time-saving shortcuts, understand how to properly select and organize data for charts, and explore advanced features like sparklines and pivot charts. Follow along with hands-on exercises using the provided sample workbook to create professional-looking visualizations, modify chart elements, apply styles and colors, and implement filters. Gain practical knowledge about chart positioning, sizing, and template creation, enabling you to effectively communicate data insights through polished visual presentations.
Syllabus
Introduction
Insert chart
Modify chart selection
Avoid totals in charts
Select non-contiguous data
Change chart type
Chart shortcut keys
Chart titles
Chart elements
Styles and colors
Filter
Chart design tab
Chart format tab
Chart templates
Advanced options
Adjust position and size
Switch row and column
Sparklines
Pie charts
Pivot charts
Wrap up
Taught by
Kevin Stratvert