Main Content
NEW COURSE!
This brand new course has just been added to our Computer Skills program area. Sign up today and be one of the first to take it!
Jump to: Register | Course Details | Overview | Instructor | CE Credits | Policies | Contact Us | Related Courses | Join Email List
Register Now
Pay with Credit Card:
Pay with Check, PO, or Money Order:
Course Details
Course Name: Pivot Tables
Course Code: CS0205WA24
Date: May 7, 2024
Time: 9:00 am – 12:30 pm EDT (Log-in time: 8:50 am)
Location: Online
Format: Live, instructor-led
Registration Fee: $155 per person
Multi Course Discount Fee: $145 per person per class (Save when you sign up for this class and Fundamentals of Computers and Basic Functionalities of Microsoft, New Features in Microsoft 365, Excel Level 1, Excel Level 2, Excel Level 3, PowerPoint Level 1, or PowerPoint Level 2!)
Rutgers Employee Discount Fee: $145 per person
Registration Closes: May 6, 2024 at 2:00 pm EDT
Paying with a check, money order, or purchase order?
Payments should be made out to: Rutgers, The State University of New Jersey
Checks and money orders should be mailed to: Office of Continuing Professional Education, Attn: Registration Dept., 102 Ryders Ln, New Brunswick, NJ 08901-8519
Purchase Orders can be mailed to the address above or electronically sent to registration@njaes.rutgers.edu.
Course Overview
- Does your job require you to keep track of data using Excel?
- Are you interested in a way to rearrange and present data in a way that makes sense to you?
This course on Pivot Tables may be your answer! Expand your skills and unlock the full potential of Microsoft Excel.
This live, interactive, online workshop is for individuals who are interested in expanding their knowledge of Microsoft Excel. Pivot Tables are one of the most technologically sophisticated components in Excel. This course aids individuals in becoming familiar with pivot tables, creating pivot tables both automatically and manually, analyzing data, and creating charts.
Performance Objectives:
By the end of this course, students will be able to perform the following skills:
- Understand the use of Pivot Tables
- Create Pivot Tables both Manually and Automatically
- Copy Content from a Pivot Table
- Analyze Data with Pivot Tables
- Work with Nonnumeric Data
- Group Pivot Table Items
- Create a Calculated Field
- Filtering Pivot Tables
- Referencing Cells within Pivot Tables
- Create Pivot Charts
- Use Data Models
Prerequisites
- Completion of Microsoft Excel – Level 3 and/or the ability to perform all Level 3 Performance Objectives.
- A laptop or desktop computer with mouse is required (no trackpads) due to the types of operations practiced.
- High-speed internet access, webcam (internal or external), microphone, and speakers/headphones (call-in option available for audio) are required.
- Participants must have Microsoft Office available on their PC/Mac.
- Users should have a basic understanding of keyboard and mouse use, and an overall understanding of computer file management.
- All should be able to download email attachments to their computers, save them in organized folders, and navigate back to those files when needed.
- Prior experience with Zoom video-conferencing will be helpful, although not required.
Course Format
This will be a live, online, interactive course, using the Zoom video conferencing platform. Students should be prepared to have their webcams turned on, and microphones and speakers enabled. A call-in option is available for audio in lieu of microphone and speakers. The instructor may ask you to unmute to speak, or ask for feedback in the Chat. You will be following along with the instructor and will be doing Microsoft Excel exercises on your own computer.
Meet Your Instructor
Anne Marie DelPrincipe
Anne Marie DelPrincipe is a technically skilled training specialist with an emphasis in corporate training and specialized end-user computing. Known for accuracy, attention to detail, and timeliness in managing training for diverse industries, Anne Marie is also a personable instructor with a proven record of helping workshop participants to achieve results. She has strong, hands-on technical training and consulting experience at all levels of the organization including upper management. In particular, Anne Marie has extensive experience in compiling training manuals; creating effective training spreadsheets and captivating presentations; and conducting executive presentations/seminars. Anne Marie earned her BA in Computer Information Systems and MBA in Management Information Science.
Continuing Education Credits
The Pivot Tables course is approved for 0.35 Rutgers CEUs (3.5 contact hours).
Course Requirements and Policies
Technology Requirements
This online course will be delivered via Zoom. Registrants will be emailed the Zoom link on May 3, 2024.
Participants should log in at least 10 minutes ahead of each class.
Participants must have Microsoft Excel available on their PC/Mac. Any version of Excel will work. Desktop or laptop computers may be used, but please be sure to have a mouse. If you ordinarily do not use a mouse because your computer has a trackpad, we strongly recommend that you get a mouse for this class, due to the types of operations practiced.
Participants must have high-speed internet, have basic understanding of keyboard and mouse use, and an overall understanding of computer file management. All should be able to download email attachments to their computers, save them in organized folders, and navigate back to those files when needed. Prior experience with Zoom video-conferencing will be helpful, although not required.
Email Requirement
A unique email address is required for each registrant to register and access our courses.
- If this is your first time registering with us, please provide your own unique email address when registering; do not provide an email address that you share with co-workers.
- If you have previously taken classes with us and have used an email address that you share with your co-workers or supervisor, your account must be updated with a unique email address. To do this, please send an email to us at registration@njaes.rutgers.edu stating that your email address needs to be changed and include:
- Your full name
- The shared email address that needs to be changed
- Your unique email address
- A phone number where you can be reached if we have any questions
Cancellations and Substitutions
A $35 cancellation fee applies for this course. Substitutions are permitted. View our cancellation policy.
Program Questions? We’re Here to Help!
If you have any questions about Pivot Tables, please don’t hesitate to reach out to us.
Program Coordinator: Jill Sullivan
848-932-7443
jill.sullivan@rutgers.edu
For registration assistance, please contact our Registration Department at 848-932-9271, option 2 or email registration@njaes.rutgers.edu.