Data Visualization in Excel
Learn how to create a range of visualizations in Excel for different data layouts, ensuring you incorporate best practices to help you build dashboards.
Start Course for Free3 Hours9 Videos30 Exercises
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.Training 2 or more people?Try DataCamp For Business
Loved by learners at thousands of companies
Course 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?For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Excel Fundamentals
Go To Track- 1
Building basic charts
FreeIn 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!
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Excel Fundamentals
Go To TrackDatasets
Exercises and DatasetsCollaborators
Prerequisites
Introduction to ExcelAgata Bak-Geerinck
See More
Senior Data Analyst at Telenet
Agata is a passionate data analyst and a certified Tableau practitioner with years of experience in various analytical roles focusing on insights, visualization, and reporting. She currently works for a major Belgian telecom company where she translates vast amounts of complex data into actionable strategic insights for the business leaders. In her free time, she is a foreign languages lover, an avid reader, and an all-around fitness enthusiast.
What do other learners have to say?
Join over 13 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.