Future-Proof Your Career: AI Manager Masterclass
AI, Data Science & Business Certificates from Google, IBM & Microsoft
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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