Visualizing data in Excel

Understanding 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
Understanding 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

Understanding 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

Understanding Excel

Visualization options

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

Understanding Excel

Visualization options

Understanding Excel

Let's test your skills!

Understanding Excel

Preparing Video For Download...