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

Join Our Mailing List button

Microsoft Office Excel - Level 2


Course Code: CS0202WA21

Microsoft Excel Computer Training Class

Bookmark and Share
Date & Time

Last Held: August 27, 2020
8:30am - 12:00pm EDT (Check-in time: 8:15am EDT)

Click here for a schedule of other upcoming Excel classes.


This Excel training workshop is designed for students looking to go beyond the basic features of Microsoft Office Excel and master more challenging skills. This online class is instructor-led, so you can ask any questions you may have as you work through the lessons. Plus, the online format gives you the opportunity to practice the skills you learn firsthand on your own computer.

Participants will learn how to create and manage large workbooks by building on the basic skills covered in Excel 1 classes (creating, editing, and saving spreadsheets).

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

  • Hide and unhide rows and columns
  • Use the Function Wizard
  • Create "If" statements
  • Work with average, minimum, maximum, and count functions
  • Use conditional formatting
  • Create hyperlinks and tables of contents
  • Create and format tables and charts

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

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: Excel Level 1 Training or equivalent experience

Want to read more about what you'll learn in Excel Level 2 training? Click to view a detailed course agenda.
  • Creating Multiple Lines within a Cell
  • Formatting Numbers
  • Creating "Adjusting" Tables
  • Using Average, Min, Max, and Count Formulas
  • Using the Function Wizard
  • Using Conditional Formatting
    • Conditional Formatting Presets
    • Removing Individual Rules
    • Using Count function and its Modifications
    • Using the Function Wizard
    • Creating Worksheets with Relative and Absolute Formulas
  • Inputting Data in Percentage Format
  • Formatting Data as a Table
  • Referencing Cells on Other Worksheets
  • Creating Calculations Between Several Worksheets
  • Checking the Flow of Formulas
0.35 Rutgers CEUs
Registration Fee TBD  
Rutgers Faculty/Staff/Student Discount Fee TBD  

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


No meals will be provided at this course.

Accessing this Online Course

This online course is being delivered via Webex. Registrants must access this course on a computer. Microphones are required; webcams are not necessary for this class.


  • 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, you must update your account with a unique email address. Click the Register Online button below and sign into your account. On the left side toolbar, click My Account. On the drop-down menu, click Edit Profile/Password. Scroll down to the Email Address field (not the secondary email address field!) and enter your own, individual (not shared!) email address here. Click the Submit button at the bottom to save. If you need assistance updating your account, please email or call (848-932-9271, option 2) our Registration Department.

Pre-registration is required.


Sorry, registration is not currently available for this course.

Would you like to be notified about future classes? 
Here are 3 convenient ways to be added to our mailing list:
1. Click here to join our mailing list (please reference "Microsoft Office Excel - Level 2" or Course Code CS0202) 
2. Call us at 848-932-9271, select option 3
3. E-mail us at ocpe@njaes.rutgers.edu

Program Questions? Contact Us!

Program Coordinator: Wendy Allard, wallard@njaes.rutgers.edu