Microsoft Office Excel – Level 4

Achieve an advanced level of competence with Excel so you can perform high level data management and formatting tasks.

Main Content

Two professionals working on laptop computers overlaid with business and statistics graphics

Course Status Notice – Not Scheduled

We do not have an offering of this course scheduled at this time. Please join our email list to be notified when the next offering is scheduled!

Use our Microsoft Excel Placement Tool to learn which level is right for you!

We offer four levels of Microsoft Office Excel instruction. Not sure which level to register for? Take our quick Excel Course Placement Tool to discover the course that’s perfect for your skills.

Jump to: Overview | Instructor | Reviews | CE Credits | Contact Us | Related Courses | Join Email List

Register Now

Pay with Credit Card:

Pay with Check, PO, or Money Order:

Course Details

Course Name: Microsoft Office Excel – Level 4
Course Code: CS0204WA25
Date of Most Recent Offering: April 9, 2025

Date: April 9, 2025 UPDATE THIS FOR NEXT OFFERING
Time: 9:00 am – 12:30 pm EDT (Log-in time: 8:50 am) UPDATE THIS FOR NEXT OFFERING

Location: Online UPDATE THIS FOR NEXT OFFERING
Format: Live, instructor-led UPDATE THIS FOR NEXT OFFERING

Registration Fee: $160 per person UPDATE THIS FOR NEXT OFFERING
Multi Course Discount Fee: $150 per person per class (Save when you sign up for this class and Excel Level 1, Excel Level 2, or Excel Level 3!) UPDATE THIS FOR NEXT OFFERING
Rutgers Employee Discount Fee: $150 per person UPDATE THIS FOR NEXT OFFERING

Registration Closes: April 8, 2025 at 2:00 pm UPDATE THIS FOR NEXT OFFERING

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

If you are interested in jobs that require an advanced level of competence with Excel and you have already taken a Level 3 class, MS Excel Level 4 may be the right class for you!

This course is designed for individuals who must demonstrate high level data management and formatting skills in MS Excel, for both data analysis and presentation purposes. Participants will learn how to create a template; use complex spreadsheet functions; add notes and comments on cells of worksheets; protect spreadsheets and worksheets and insert comments in a spreadsheet. Participants will understand Power Query, flash fill; match and index and linking cells.

Level 4 Performance Objectives:

By the end of this course, students will be able to perform the following skills:

  • Demonstrate creation and use of Templates
  • Use of the “IFS,” “SUMIF,” and “SUMIFS” formulas
  • Understand and demonstrate use of the Power Query, Goal Seek, and PMT functions
  • Use “Flash Fill” to eliminate the need for recopying text formulas
  • Use of the “MATCH,” “INDEX,” and “XLOOKUP” formulas
  • Protect Spreadsheets and Worksheets
  • Linking Cells
  • Add Comments to cells

Prerequisites

Completion of Microsoft Office Excel – Level 3, and/or ability to perform all Level 1, 2, and 3 Performance Objectives

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. 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 Excel exercises on your own computer.

Meet Your Instructor

Anne Marie DelPrincipe

Headshot of 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.

Student Reviews

“Quote here”

– Past Participant

“Quote here”

– Past Participant

“Quote here”

– Past Participant

Continuing Education Credits

The Microsoft Office Excel – Level 4 course is approved for 0.3 Rutgers CEUs (3 contact hours).

Course Requirements and Policies

electronic devices iconTechnology Requirements

This online course will be delivered via Zoom. Registrants will be emailed the Zoom link a few days prior to 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 iconEmail 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

x icon with circle around itCancellations 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 Microsoft Office Excel – Level 4, please don’t hesitate to reach out to us.

Rutgers University Shield

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.

Digital illustration of laptop with spreadsheet open

Microsoft Office Excel – Level 1

Woman pointing pen at computer screen showing spreadsheet and pie chart

Microsoft Office Excel – Level 2

Spreadsheet overlaid with coffee cups and employees' hands pointing to pieces of data

Microsoft Office Excel – Level 3

white envelope icon with @ sign representing email

Join Our Email List!