Visualizing data in Excel

Introduction to 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
Introduction to 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

Introduction to 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

Introduction to Excel

Visualization options

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

Introduction to Excel

Visualization options

Introduction to Excel

Let's test your skills!

Introduction to Excel

Preparing Video For Download...