Excel Data Visualization Course – Guide to Charts & Dashboards
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-free-course/
⭐️ 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 on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from freeCodeCamp.org · freeCodeCamp.org · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
React: Production Server Setup Part 2 - Live Coding with Jesse
freeCodeCamp.org
cookies vs localStorage vs sessionStorage - Beau teaches JavaScript
freeCodeCamp.org
Browser history tutorial - Beau teaches JavaScript
freeCodeCamp.org
Graph Data Structure Intro (inc. adjacency list, adjacency matrix, incidence matrix)
freeCodeCamp.org
React: Parameterized Routing with Next.js - Live Coding with Jesse
freeCodeCamp.org
React: Dealing with jQuery Issues - Live Coding with Jesse
freeCodeCamp.org
setInterval and setTimeout: timing events - Beau teaches JavaScript
freeCodeCamp.org
Browser and Device Testing - Live Coding with Jesse
freeCodeCamp.org
Last Minute Updates - Live Coding with Jesse
freeCodeCamp.org
Post Launch Updates - Live Coding with Jesse
freeCodeCamp.org
React: Setting Up Google Analytics - Live Coding with Jesse
freeCodeCamp.org
React: Masonry Layout - Live Coding with Jesse
freeCodeCamp.org
Load Balancing Digital Ocean Droplets - Live Coding with Jesse
freeCodeCamp.org
try, catch, finally, throw - error handling in JavaScript
freeCodeCamp.org
Load Balancing: SSL Passthrough Setup - Live Coding with Jesse
freeCodeCamp.org
Graphs: breadth-first search - Beau teaches JavaScript
freeCodeCamp.org
React: Masonry Layout Part 2 - Live Coding with Jesse
freeCodeCamp.org
React: WordPress API Live Search - Live Coding with Jesse
freeCodeCamp.org
Creating WordPress Custom Post Types - Live Coding With Jesse
freeCodeCamp.org
Dates - Beau teaches JavaScript
freeCodeCamp.org
Miscellaneous Front End Updates - Live Coding with Jesse
freeCodeCamp.org
Merging a Pull Request from GitHub - Live Coding with Jesse
freeCodeCamp.org
React + Prettier + Standard JS - Live Coding with Jesse
freeCodeCamp.org
React: Sortable Responsive Table - Live Coding with Jesse
freeCodeCamp.org
Geolocation Sorting by Distance - Live Coding with Jesse
freeCodeCamp.org
Tradeoff Matrix - Agile Software Development
freeCodeCamp.org
The Definition of Ready - Agile Software Development
freeCodeCamp.org
Getting first React job without experience - Ask Preethi
freeCodeCamp.org
React: Google Analytics Click Tracking - Live Coding with Jesse
freeCodeCamp.org
Submitting a PR to an Open Source Project - Live Coding with Jesse
freeCodeCamp.org
Should I go back to school to get CS degree? - Ask Preethi
freeCodeCamp.org
Hero Section CSS Changes - Live Coding with Jesse
freeCodeCamp.org
Working Agreement - Agile Software Development
freeCodeCamp.org
A day at Pennybox with Co-Founder Reji Eapen
freeCodeCamp.org
React: Sorting and Filtering Data - Live Coding with Jesse
freeCodeCamp.org
React: Sorting and Filtering Data Part 2 - Live Coding with Jesse
freeCodeCamp.org
React: Building a New UI - Live Coding with Jesse
freeCodeCamp.org
Definition of Done - Agile Software Development
freeCodeCamp.org
Getting started with jQuery (tutorial) - Beau teaches JavaScript
freeCodeCamp.org
Making a React Blog with WordPress Content - Live Coding with Jesse
freeCodeCamp.org
React, NextJS, CSS - Live Coding with Jesse
freeCodeCamp.org
jQuery events - Beau teaches JavaScript
freeCodeCamp.org
React/NextJS Routing and WordPress API Custom Types - Live Coding with Jesse
freeCodeCamp.org
React: Working with API Data - Live Coding with Jesse
freeCodeCamp.org
React: Refactoring Components - Live Streaming with Jesse
freeCodeCamp.org
jQuery effects - Beau teaches JavaScript
freeCodeCamp.org
More React Refactoring - Live Coding with Jesse
freeCodeCamp.org
animate in jQuery - Beau teaches JavaScript
freeCodeCamp.org
"Finishing" My React Site - Live Coding with Jesse
freeCodeCamp.org
Starting a New React Project (P2D1) - Live Coding with Jesse
freeCodeCamp.org
React Project 2 Day 2: Learning Material UI - Live Coding with Jesse
freeCodeCamp.org
The Agile Manifesto - Agile Software Development
freeCodeCamp.org
jQuery: get and set with http, text, val, and attr - Beau teaches JavaScript
freeCodeCamp.org
React Project 2 Day 3 - Live Coding with Jesse
freeCodeCamp.org
The INVEST approach to product backlog items
freeCodeCamp.org
React Project 2 Day 4 - Live Coding with Jesse
freeCodeCamp.org
Chickens and Pigs - Agile Software Development
freeCodeCamp.org
React Project 2 Day 5 - Live Coding with Jesse
freeCodeCamp.org
jQuery: add and remove DOM elements - Beau teaches JavaScript
freeCodeCamp.org
React Project 2 Day 6 - Live Coding with Jesse
freeCodeCamp.org
More on: Data Literacy
View skill →Related AI Lessons
⚡
⚡
⚡
⚡
Why Real-Time Analytics Eventually Changes Your Database Architecture
Dev.to · Mohamed Hussain S
Day 43: Hypothesis Testing & Statistical Analysis — Understanding How Data Makes Decisions
Medium · AI
Day 43: Hypothesis Testing & Statistical Analysis — Understanding How Data Makes Decisions
Medium · Machine Learning
I Spoke With 8 Interviewers. I Expected an Offer. They Asked for a 9th Round.
Medium · Data Science
🎓
Tutor Explanation
DeepCamp AI