Creating Professional Business Charts in Excel - Advanced Visualization Techniques
Simon Sez IT via YouTube
Get 20% off all career paths from fullstack to AI
AI, Data Science & Cloud Certificates from Google, IBM & Meta
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Master professional Excel chart creation in this 59-minute video tutorial that transforms raw data into compelling visual narratives. Learn essential charting best practices and advanced techniques for creating dynamic visualizations, including multi-series dumbbell charts, alternative bar charts, and smoothed line charts. Explore how to leverage the REPT function for dynamic chart creation and enhance multi-series doughnut charts for maximum impact. Follow along with downloadable practice files to create sophisticated data visualizations that effectively communicate complex information in a business context. Progress through structured segments covering chart fundamentals, best practices, and specific chart types, gaining practical skills to elevate data presentation capabilities in Excel.
Syllabus
- Course Introduction
- Introduction to Excel Charts
- Charting Best Practices
- Multi-series Dumbbell Chart Part 1
- Multi-series Dumbbell Chart Part 2
- Alternative Bar Chart
- Dynamic Charts using REPT
- Multi-series Doughnut Chart
- Smoothed Line Chart
- Course Conclusion
Taught by
Simon Sez IT