Course
Data Visualization in Excel
BasicSkill Level
Updated 04/2026
ExcelData Visualization3 hr9 videos30 Exercises2,500 XP51,462Statement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Training a Team?
Try for BusinessCourse Description
Building basic Charts
You will embark on an immersive exploration of basic Excel charts, equipping yourself with the skills to create impactful visualizations and customize chart types. Through a comprehensive understanding of Series and Categories, you will gain the expertise to transform data into compelling narratives that resonate with your audience.Advancing to more complex charts
Ready to further enhance your charting skills with Excel? You will explore how to work with dual series and prepare more advanced charts, such as Bullet charts, Waterfall charts, or Scatter plots. Additionally, we will investigate various chart editing options.Data Visualization best practices
Like any discipline, data visualization has its best practices, and it's time to take a closer look at the dos and don'ts. We will improve our skills in selecting chart elements, applying colors, legends, and labels, while also learning how to troubleshoot and customize poorly designed visuals for the benefit of end users.Visualizing disaggregated data with PivotCharts
Get ready for an exciting journey into the world of visualizing disaggregated data! We'll explore PivotTables, PivotCharts, and how to combine them into a dynamic mini-dashboard. Are you ready to unlock the true power of your data?What you'll learn
- Distinguish advanced Excel chart types used for multi-measure and comparative analysis
- Evaluate Excel chart formatting and design choices for clarity and accuracy
- Identify appropriate Excel chart types for different data and analysis needs
Feels like what you want to learn?
Start Course for FreePrerequisites
Introduction to Excel1
Building basic charts
In Chapter 1, you will embark on an immersive exploration of basic Excel charts, equipping yourself with the skills to create impactful visualizations and customize chart types. Through a comprehensive understanding of Series and Categories, you will gain the expertise to transform data into compelling narratives that resonate with your audience.
2
Advancing to more complex charts
Ready to further enhance your charting skills with Excel? This chapter will explore how to work with dual series and prepare more advanced charts, such as Bullet charts, Waterfall charts, or Scatter plots. Additionally, we will investigate various chart editing options. There's a lot to learn, so let's get started!
3
Data visualization best practices
Like any discipline, data visualization has its best practices, and it's time to take a closer look at the dos and don'ts. In this chapter, we will improve our skills in selecting chart elements, applying colors, legends, and labels, while also learning how to troubleshoot and customize poorly designed visuals for the benefit of end users.
4
Visualizing disaggregated data with PivotCharts
Get ready for an exciting journey into the world of visualizing disaggregated data in this final chapter! We'll explore PivotTables, PivotCharts, and how to combine them into a dynamic mini-dashboard. Are you ready to unlock the true power of your data? Let's dive in!
Data Visualization in Excel
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
Do I need prior experience in data visualization or Excel to take this course?
You'll need to know how to navigate Excel and how to create basic visualizations in Excel.
What types of visualizations will I learn to create in this course?
In this course, you'll learn to create a variety of visualizations, including basic bar and line charts, advanced scatter plots, bullet charts, and waterfall charts. Additionally, you'll learn how to use PivotCharts to visualize both summarized and disaggregated raw data.
What best practices for data visualization will I learn in this course?
Throughout the course, you'll learn the best practices for data visualization, including how to choose the right type of chart for your data, design principles to enhance clarity and impact, and how to leverage visual design elements to communicate data insights effectively.
Join over 19 million learners and start Data Visualization in Excel today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.