Data Visualizations of WORKBOOK

  • Making sense of a workbook’s source data requires the examination of the data from a variety of different perspectives.
  • Accomplished through data summarization, aggregation, and visualization.
  • There are three workbook visualization types:

Table Views | Creating a Table View:

  • Click on the Add + icon and select Table.
  • No limit to the number of table views in a workbook.
  • Always name your table views based on the summarized data they display.
  • Table view data can be filtered, sorted, and exported in the .CSV format

Pivot Tables | Creating a Pivot Table:

  • Click on the Add + icon and select Pivot.
  • No limit to the number of pivot tables in a workbook.
  • Always name your pivot tables based on the aggregated data they display.
  • Pivot table data can be filtered, sorted, and exported in the .CSV format

Charts and Graphs | Creating a Chart:

  • Click on the Add icon and select Chart.
  • No limit to the number of charts in a single workbook.
  • Always name your charts based on the visualized data they display.
  • The Print icon allows you to print to a physical printing device or to the PDF format.
  • The Export icon allows to save the chart as a .SVG image.

Leave a comment

Your email address will not be published. Required fields are marked *