Class Outline

 

UNC Charlotte

Information & Technology Services
Faculty and Staff Tra
ining

 

Excel Pivot Tables and Charts

Excel pivot tables and pivot charts allow you to display and report information in visually understandable ways.  This class will address how to organize material and import it into pivot table format. 

Length
2 hours
Book:
Optional Reference Book

 
Prerequisite Class or Equivalent Knowledge:
Get to Know Your Computer
Understand the Windows (or Macintosh) Desktop Create Spreadsheets in Excel

Download Module

Course Content


Pivot Tables
  • Planning a list
  • List layout
  • Pivot table wizard
  • Drag and drop "pivoting"
  • AutoFormat options

Pivot Charts

  • Pivot chart wizard
  • Drag and drop
  • Different chart views

 


 

 

Top of Page