Main Content

Course Status: Not Currently 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!
Jump to: Overview | Instructor | Reviews | CE Credits | Contact Us | Related Courses | Join Email List
Course Details
Course Name: Microsoft Office Excel – Level 3
Course Code: CS0203WB23
Date of Most Recent Offering: February 9, 2023
Course Overview
- Does your job require you to manage data at a high level of complexity?
- Are you losing out on the upper-level data management jobs you want because your existing spreadsheet skills are too basic?
- Have you gone to the MS “Help” website when trying to figure out formulas or charts, and you still get nowhere?
If you answered “yes” to any of these questions, Microsoft Excel, Level Three may be the right class for you!
This workshop is for the individual who needs to produce complex Excel spreadsheets. Participants will learn how to use complex mathematical and logical functions in Excel; write “What-If” analysis formulas; use advanced formatting features; add more complex charts; include charts in Word and PowerPoint; reference cells on other worksheets in complex formulas; format and change the properties of charts; and link and embed objects in a spreadsheet.
Level 3 Performance Objectives:
By the end of this course, students will be able to perform the following skills:
- Demonstrate the use of Special Number formats
- Name cells instead of using Absolute Referencing
- Demonstrate use of the “Subtotal” command or creating true tables
- Understand and demonstrate the use of filters and slicers in data organization
- Create Forms to enter data in tables
- Demonstrate use of What-If analysis formulas
- Demonstrate use of the “VLOOKUP” formula and create nested “IF” formulas and know when to use them correctly
- Create Pivot tables with graphs and slicers
- Demonstrate use of right-clicking controls and functions
- Demonstrate advanced worksheet formatting, including category cell formatting, change of height and width, and number of lines
- Demonstrate how to use Excel output, including Tables and Charts, in other MS products (Word and PowerPoint)
Prerequisites
Completion of Microsoft Office Excel – Level 2, and/or ability to perform all Level 1 and Level 2 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

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
There are no continuing education credits offered for this course.
Program Questions? We’re Here to Help!
If you have any questions about Microsoft Office Excel – Level 3, 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.