Excel Data Visualization - Guide to Charts and Dashboards

This course teaches data visualization in Excel, covering chart selection and customization across many chart types. It also introduces building interactive dashboards with organized data, relationships, DAX, PivotTables, charts, and KPIs.

Syllabus

Introduction
Column Chart
Bar Chart
Line Chart
Pie/Doughnut Chart
XY Scatter Plot Chart
Area Chart
Radar Chart
Stock Chart
Histogram Chart
Pareto Chart
Waterfall Chart
Box & Whisker Chart
Treemap Chart
Map Chart
Recommended Chart
Chart Customization
Organize Data
Choose the Best Chart Type
Applying Chart Styles
Adjust Chart Elements and Labels
Enhancing Data Label and Gridlines
Applying Color Themes and Palettes
Utilizing Combination Chart and Secondary Axis
Incorporate Trendlines
Applying Chart Elements
Best Practices for Chart Customization
Excel Dashboard
Interactive Dashboard
Plan Your Excel Dashboard
Clean Data
Building Relationships
Writing DAX
Building Pivot Table
Building Charts
Building KPIs
Incorporate Interactivity
Building Dashboard
Free Excel Course