Visualizing data in Excel

Introducción a 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
Introducción a 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

Introducción a 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

Introducción a Excel

Visualization options

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

Introducción a Excel

Visualization options

Introducción a Excel

Let's test your skills!

Introducción a Excel

Preparing Video For Download...