Microsoft Excel Data Visualization with Charts & Graphs

Course Overview

• Course Title: Microsoft Excel Data Visualization with Charts & Graphs
• Instructor: Bright Path
• Target Audience:
  • Business professionals
  • Data analysts
  • Anyone who wants to communicate data more effectively
• Prerequisites:
  • Basic understanding of Excel
  • Access to a PC with any version of Excel

Curriculum Highlights

• Key Topics Covered:
  • What is Data Visualization and Why it Matters
  • Principles of Effective Visual Storytelling
  • Choosing the Right Chart Type for Your Data
  • Understanding Your Audience and The Message
  • Overview of Chart Types in Excel
  • Inserting Basic Charts: Column, Bar, Line, Pie
  • Chart Elements: Titles, Legends, Axis, Labels
  • Combo Charts (e.g., Line & Column)
  • Area Charts, Scatter Plots, Bubble Charts
  • Doughnut and Radar Charts
  • Using Error Bars and Trendlines
  • Custom Color Schemes and Themes
  • Creating Custom Chart Templates
  • Highlighting Specific Data Points
  • Using Drop-Downs and Slicers to Control Charts
  • Dynamic Named Ranges for Live Updating Charts
  • Heat Maps and Data Bars for Visual Impact
  • Sales and KPI Dashboards
  • Customer Feedback Visualization
  • Financial Trend Reports
• Key Skills Learned:
  • Effective data visualization techniques
  • Selecting appropriate chart types
  • Editing and formatting chart components
  • Creating interactive dashboards
  • Using advanced Excel features like slicers and named ranges
  • Applying conditional formatting for data trends
  • Building professional reports and presentations

Course Format

• Duration: 3.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Certificate of completion