Skip to main content
HomeExcelData Visualization in Excel

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 Free
3 hours9 videos30 exercises
19,447 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTraining 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

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Excel Fundamentals

Go To Track
  1. 1

    Building basic charts

    Free

    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.

    Play Chapter Now
    Getting started with data visualization in Excel
    50 xp
    Truth or a myth?
    100 xp
    Building the first charts
    50 xp
    Comparing Contributions
    100 xp
    Visualizing Contribution Differently
    100 xp
    How are we doing on Sales?
    100 xp
    Visualizing Sales per Segment
    100 xp
    Quarterly Sales per Region
    100 xp
  2. 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!

    Play Chapter Now
  3. 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.

    Play Chapter Now
  4. 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!

    Play Chapter Now
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

In the following Tracks

Excel Fundamentals

Go To Track

datasets

Exercises and DatasetsExcel Formula Translations

collaborators

Collaborator's avatar
Iason Prassides
Collaborator's avatar
Jess Ahmet
Agata Bak-Geerinck HeadshotAgata Bak-Geerinck

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.
See More

What do other learners have to say?

FAQs

Join over 14 million learners and start Data Visualization in Excel today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.