Master Excel data visualization techniques in this comprehensive tutorial covering various chart types, customization methods, and dashboard creation. Learn to create column, bar, line, pie, scatter plot, area, radar, stock, histogram, Pareto, waterfall, box & whisker, treemap, and map charts. Explore chart customization best practices, including data organization, style application, element adjustment, and color theme utilization. Dive into Excel dashboard creation, covering planning, data cleaning, relationship building, DAX writing, pivot table construction, chart building, KPI development, and interactivity incorporation. Gain practical skills to effectively present data and create engaging, interactive dashboards in Excel.
Overview
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
Taught by
freeCodeCamp.org
