Home > Computer Classes > Microsoft Office Excel Courses > Level 3

register now button

register by mail/fax button

Join Our Mailing List button

Microsoft Office Excel - Level 3

Course Code: CS0203CB20

Microsoft Excel Computer Training Class

Bookmark and Share
Date & Time

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

Click here for a schedule of other upcoming Excel classes.


In-House Computer Training Available!

Have a large group that needs Excel classes? 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 Higher Level Excel Training!

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

This Excel training workshop is designed for students looking to learn how to produce complex Microsoft Office Excel worksheets.

By attending this class, attendees will gain a functional knowledge of Excel and the use of Excel charts in Microsoft sister products such as Word and PowerPoint.

Upon successful completion of this Microsoft Excel training course, students will be able to:

  • Use complex mathematical functions
  • Use category cell formatting
  • Create Pivot Tables
  • Create more complex charts and use them in Word and PowerPoint
  • Link and embed objects in spreadsheet

Students will learn some timesaving tips and shortcuts to work more quickly and efficiently, and the instructor will set aside time to answer specific questions.

Computers will be provided for hands-on learning. Students will complete instructor-led practice exercises to reinforce new skills.

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 1 and Level 2 training or equivalent experience

Want to read more about what you'll learn in Excel Level 3 training? Click to view a detailed course agenda.
  • Creating and Structuring the Database
    • Using special formatting and creating custom formatting
    • Creating a database from the regular tables
    • Expanding the database
    • Using filters and multilevel sorting
    • Using the Form Toolbar
    • Creating subtotals
    • Conditional formatting
  • Using Reference and Lookup Functions
    • Using VLOOKUP for searching for records
    • Using VLOOKUP for matching up tables from multiple worksheets
    • Using MATCH function
    • Using INDEX function for single reference and arrays
  • Summarizing Data
    • Creating pivot tables
    • Manipulating and structuring pivot tables
    • Formatting pivot tables
    • Creating pivot charts
  • Linking and Embedding Objects to Your Documents
0.35 Rutgers CEUs
Registration Fee $145.00  
Rutgers Faculty/Staff/Student Discount Fee $110.00  

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


No meals will be provided at this course.


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


  • 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.


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