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

Join Our Mailing List button

Microsoft Office Excel - Level 2

Course Code: CS0202CC17

Microsoft Excel Computer Training Class

Bookmark and Share
Date & Time

Last Held: August 11, 2016
8:30am - 12:00pm

Click here for a schedule of other upcoming Excel classes.

Description

In-House Computer Training Available!

Have a large group that needs this Excel training? We can bring this course to you!

For more information, call Wendy Allard at 848-932-7651 or send an email to wallard@njaes.rutgers.edu.


We Offer Several Levels of Excel Training Courses!

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

This Excel training workshop is designed for students looking to go beyond the basic features of Microsoft Office Excel and master more challenging skills.

Attendees 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
  • Freeze and unfreeze panes
  • Learn "If" statements
  • Work with average, minimum, maximum and count functions
  • 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.

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

Want to read more about what you'll learn in Excel Level 2 training? View a detailed course agenda.
  • Creating Multiple Lines within a Cell
  • Formatting Numbers
  • Creating Descriptive Statistics
    • Using the Sum function
    • Using the Average function
    • Using the Minimum and Maximum functions
    • Using Count function and its modifications
    • Using the Function Wizard
    • Using What If analysis
    • Creating worksheets with relative and absolute formulas
  • Inputting Data in Percentage Format
  • Creating Summary Worksheets
  • Referencing Cells on Other Worksheets
  • Creating Calculations Between Several Worksheets
  • Checking the Flow of Formulas
  • Manipulating Data Using Goal Seeking
Fees
Registration Fee TBD  
Rutgers Faculty/Staff/Student Discount Fee TBD  

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

Meals

No meals will be provided at this course.

Location

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.

Former Agriculture Museum of New Jersey
103 College Farm Road, New Brunswick, NJ 08901
Directions

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.

Register

Sorry, registration is not currently available for this course.

Would you like to be notified when the next offering is scheduled? 
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, 848-932-7651

Attention U.S. Veterans

All of the courses offered by the Rutgers Office of Continuing Professional Education are approved by the New Jersey State Approving Agency for Veterans Training for tuition reimbursement through the GI Bill. For more information about the GI Bill, click here.