Excel Data Visualization Course – Guide to Charts & Dashboards

Published: 27 August 2024
on channel: freeCodeCamp.org
70,940
2.4k

This comprehensive tutorial will teach you everything you need to know about Excel chart types, chart customization, and creating engaging Excel dashboards.

⬇️ Download course files here: https://tinyurl.com/539e2zr2

👨‍🏫 FREE Excel Course: https://officetechskill.com/excel-fre...

⭐️ Chapters ⭐️
(0:00:00) Introduction
(0:01:17) Column Chart
(0:03:54) Bar Chart
(0:05:58) Line Chart
(0:07:46) Pie/Doughnut Chart
(0:09:05) XY Scatter Plot Chart
(0:10:42) Area Chart
(0:12:20) Radar Chart
(0:13:28) Stock Chart
(0:16:06) Histogram Chart
(0:18:26) Pareto Chart
(0:19:40) Waterfall Chart
(0:20:53) Box & Whisker Chart
(0:22:50) Treemap Chart
(0:24:42) Map Chart
(0:26:00) Recommended Chart
(0:26:49) Chart Customization
(0:27:27) Organize Data
(0:28:11) Choose the Best Chart Type
(0:28:30) Applying Chart Styles
(0:28:43) Adjust Chart Elements and Labels
(0:29:08) Enhancing Data Label and Gridlines
(0:29:33) Applying Color Themes and Palettes
(0:30:14) Utilizing Combination Chart and Secondary Axis
(0:30:51) Incorporate Trendlines
(0:31:30) Applying Chart Elements
(0:31:43) Best Practices for Chart Customization
(0:32:29) Excel Dashboard
(0:33:13) Interactive Dashboard
(0:33:34) Plan Your Excel Dashboard
(0:34:23) Clean Data
(0:43:13) Building Relationships
(0:46:11) Writing DAX
(0:48:43) Building Pivot Table
(0:51:59) Building Charts
(0:57:16) Building KPIs
(1:01:06) Incorporate Interactivity
(1:05:04) Building Dashboard
(1:09:55) Free Excel Course

❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp


Watch video Excel Data Visualization Course – Guide to Charts & Dashboards online without registration, duration hours minute second in high quality. This video was added by user freeCodeCamp.org 27 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 70,940 once and liked it 2.4 thousand people.