Home > Computer Classes > Microsoft Office Excel Courses > Pivot Tables

register now button

register by mail/fax button

Join Our Mailing List button

Pivot Tables

Course Code: CS0205CB20

Microsoft Excel Pivot Tables Training Class

Bookmark and Share
Date & Time

April 20, 2020
1:00pm - 4:30pm (Check-in time: 12:45pm)

Click here for a schedule of other upcoming Excel classes.

Description

In-House Computer Training Available!

Have a large group that needs Excel training? We can bring this course to you!

For more information, call Maria Fonseca-Cruz at 848-932-7626 or send an email to mfcruz@njaes.rutgers.edu.


We also Offer Other Excel Classes!

Please visit our Computer Classes page for all upcoming course offerings.

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.

Attendees will learn how to:

  • Use one or more tables
  • Drill down
  • Refresh Pivot data
  • Sort data
  • Group 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.

Note: Most of the skills taught in this class are applicable to 2010, 2013 and 2016 versions of Excel. Windows operating system is used for instruction in all Microsoft Office workshops.

Prerequisite: Microsoft Office Excel Level 4 training required

Credits
0.35 Rutgers CEUs
Fees
Registration Fee $145.00  
Rutgers Faculty/Staff/Student Discount Fee $110.00  

There are no refunds for this program. Substitutions are permitted.

Meals

No meals will be provided at this course.

Location

GPS systems may not recognize campus addresses. Even if they take you to the correct building, they will not take you to the assigned parking lot. Therefore, we strongly recommend that you use the directions we provide.

Allison Road Classroom Building, IML 116
618 Allison Road, Piscataway, NJ 08854
Directions, Parking Information & Map

CAMPUS PARKING HAS CHANGED! PLEASE REVIEW NEW POLICIES BELOW.

  • All visitors must register their vehicles online with the Rutgers Department of Transportation Services. A link will be provided in your course registration confirmation email. Be sure to complete this important step prior to traveling to campus.
  • All Rutgers faculty/staff/students must use their regular Rutgers permit and park in the nearest lot assigned for their permit type.
  • Citations/fines will be issued for failure to comply with these policies.

Note: Pre-registration is required. We're sorry, but we cannot guarantee a seat, materials or meals for walk-in registrants. Location is subject to change; registrants will be notified in the event of a change.

Register

To Pay By Credit Card:

register now button

First time registering online?
Click here for step-by-step instructions.

To Pay By Rutgers Internal Purchase Order,
Contact our Registration Dept. at
848-932-9271, option 2.

 

To Pay By Check, Money Order, or Purchase Order:

register by mail/fax button

For Registration Assistance:

Please call 848-932-9271, option 2.

Program Questions? Contact Us!

Program Coordinator: Maria Fonseca-Cruz, 848-932-7626