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

register now button

register by mail/fax button

Join Our Mailing List button

Microsoft Office Excel - Level 4

ONLINE COURSE

Course Code: CS0204WA21

Laptop computer with notebook and eyeglasses sitting on top with tea cup in the background

Bookmark and Share
Date & Time

September 28, 2020
8:30am - 12:00pm EDT (Check-in time: 8:15am EDT)

Click here for a schedule of other upcoming Excel classes.

Description

This Excel training workshop is designed for students looking to build on the advanced features learned in Excel – Level 3. 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.

By attending this class, attendees will gain a functional knowledge of Excel and how to use it in conjunction with the other Microsoft sister products.

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

  • Create a template
  • Write visual basic programming script
  • Use complex spreadsheet functions including Goal Seek and PMT
  • Use Lookup Using Match and Index
  • Create macros
  • Add notes and comments on cells
  • Use web toolbar and the form toolbar

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.

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 3 training required

Want to read more about what you'll learn in Excel Level 4 training? Click to view a detailed course agenda.
  • Creating a Template
  • Using the Microsoft Website to Download Additional Features
  • Creating Advanced Calculations
    • Breakeven analysis
    • Working with complex functions (using PMT)
    • Learning how to understand additional functions
    • Using What If analysis
    • Match and Index
    • Manipulating data using goal seeking
  • Enhancing Worksheets with Active X Controls
    • Creating control objects in worksheets
    • Creating a Macro
    • Using Macros
    • Protecting a worksheet
  • Adding Notes and Comments on Cells of Worksheets
  • Protecting Spreadsheets and Worksheets
Fees
Registration Fee $145.00  
Rutgers Faculty/Staff/Student Discount Fee $110.00  

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

Meals

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.

IMPORTANT: A UNIQUE EMAIL ADDRESS IS REQUIRED FOR EACH REGISTRANT TO ACCESS OUR ONLINE 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, 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.

Register

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: Wendy Allard, 848-932-7651