Synopsis: This workshop teaches participants the powerful features of Microsoft Pivot tables. Pivot tables allow you to sort, filter, group, count, summate, and format data easily and efficiently.
Start Time: Tuesday, September 17, 2019 8:30 AM
End Time: Tuesday, September 17, 2019 4:30 PM
Location: Tillett Hall
Address: 53 Avenue E
Campus: Livingston
Room: Room 106J1
City, State, Country: Piscataway, NJ US
Fee: See website
Sponsor: Rutgers Office of Continuing Professional Education
Category: Workshop, Course
Web Site: http://www.cpe.rutgers.edu/courses/current/cs0205ca.html
Contact Name: Maria Fonseca-Cruz
Contact Email: mfcruz@njaes.rutgers.edu
Contact Phone: (848) 932-7626
Additional Information:

Attendees will learn how to:

  • Use one or more tables
  • Drill down
  • Refresh Pivot data
  • Sort data
  • Grouping and filter data
  • Add calculated fields and items
  • Use slicers
  • Place subtotals and grand totals
  • Apply layouts and styles

Students will work heavily on hands-on activities with an instructor to explore the variety of features within Pivot Tables and tackle different scenarios for when to use them.

Our pivot table training builds off of topics contained in our Excel Level 1, 2, 3, and 4 courses. We highly recommend that students complete prior Levels of Excel to receive a general overview before delving deep into pivot tables.

Computers will be provided for hands-on learning.

Target Audience: Current Students,  Researchers,  Undergraduate Students,  Graduate Students,  Faculty,  Staff,  Alumni,  General Public