Spreadsheet Charts and Visualizations
  • Type Validation
  • Time Weeks

Spreadsheet Charts and Visualizations

Issued by Husson University

Earners of this badge can develop pivot tables and understand how to use charts and formulas in pivot tables. In Excel, data comparisons, patterns, and trends can be seen in data by using a pivot table to calculate, summarize, and analyze that data.

  • Type Validation
  • Time Weeks

Skills

Earning Criteria

  • Earners will create a time management and scheduling workbook. These real-world assessment models how a business could track and visualize a team of employees’ time. Additionally, students are asked to create charts and pivot tables, design and implement dashboards using functions, visualizations, and other features, and apply settings and modifications to print.
  • Earners will work in a Car Rental business workbook to compare data sets and select the data set that can be enhanced using visualizations. This includes designing pie charts using the provided data for a market analysis, and applying a pivot table to the data set to allow for visually appealing data analysis.