Date Time
Tue 06/09/2015 9:00am - 12:00pm

Excel Charts

Charts are visual representations of worksheet data. Charts often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.

Pivot Table

A pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. A pivot table can automatically sort, count, total or give the average of the data stored in a spreadsheet. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary`s structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.

Learning Objectives:

  • Create and modify charts
  • Display charts in multiple environments (both linked and detached from the original spreadsheet)
    • Excel
    • Word
    • PowerPoint
    • Web page
  • Use predefined chart styles and chart layouts for a professional look
  • Add eye-catching formatting to charts
  • Learn and understand how to create Pivot Tables
Important Notice (Microsoft Silverlight): The 2010 videos require Microsoft Silverlight. If your video does not show or play, click the Silverlight installation icon when displayed to install the application.Click here to learn more about Silverlight.

Online Course Options:

Other Resources:

Prerequisites: Completion of Excel 2013 Introduction [Online Equivalent] or comparable knowledge is required.
Cost:
$0.00
Sponsor:
Technology Services
Audience:
VCU Students, Faculty and Staff Only
Category:
Graphics/Presentations, Microsoft Office, Spreadsheets
Contact:
VCU helpIT Center
804-828-2227
helpIT@vcu.edu