Visualizing data in Excel

Capire Excel

Jess Ahmet

Curriculum Manager, DataCamp

Data visualization cheat sheet

Data visualization cheat sheet

1 https://www.datacamp.com/cheat-sheet/data-viz-cheat-sheet
Capire Excel

What is data visualization?

Graphical representation of data using charts, graphs, and other visual tools

  • Presentation of (complex) data:
    • Identify trends
    • Discover outliers
  • Enhances understanding and retention of information
  • Critical part of the decision-making process in data-driven organizations

Image of a laptop with multiple data visualizations

Capire Excel

Excel for data visualization

Offers a wide variety of ways to visualize your data:

  • Simple 2D charts to complex 3D models
  • Customization options including:
    • Legends
    • Styles
    • Labels
    • Color schemes

Example column chart in Excel

Capire Excel

Visualization options

Visual representation of pie chart, bar chart, histogram, line chart, area chart and scatter plots

Capire Excel

Visualization options

Capire Excel

Let's test your skills!

Capire Excel

Preparing Video For Download...