Microsoft Excel
Advanced Functions and Formulas

Half-Day Rapid Training in Vancouver

Rapid Computer Training runs this course as a scheduled public course. This course is based on Excel 2019/ 2016/ 2013/2010 versions. It is offered at 325 Howe St. in downtown Vancouver and also at client locations with our mobile lab.

This course is designed for office users who would like to focus on advanced Excel functions and formulas for intricate calculations or setup. If you have a good working experience of Excel but wish to set up a more complex worksheet, this course is meant for you. Those who are totally new to Excel should take our Excel Level-1 & Level-2 courses first.

Quality training is delivered by Microsoft Certified Trainers and other qualified computer professionals. The entire course is hands-on. Participants receive custom designed exercise files and a printed course manual for practice and reference.

We can also deliver this course at your office with our mobile computer lab. Please visit our On-site Training Page for more details.

Course Fee: $250+GST/HST per participant
Course Material: $35+GST/HST each
Course Duration: Half Day (9:00AM to 12:30PM)
Course Pace/Style: Medium to fast; hands-on, intensive
Class Location: 325 Howe St, Suite 608, Dntn Vancouver
Course Schedule: Please click here Course Schedule

Prerequisite:
Skills learned in our Excel Level-1 & Level-2 courses or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.

Course Outline:
(Please note: For LOOKUP functions we have a separate course that covers them in more detail)
  • Linking several worksheets to create a summary
  • Working with Structured References
  • Linking several workbooks to create a summary
  • Working with Array Formulas
  • Function IF nested
  • Function AND nested
  • Function OR nested
  • Function NOT
  • Function OFFSET
  • Function INDIRECT
  • Function SUMIFS
  • Function COUNTIFS
  • Database Function DSUM
  • Database Function DCOUNT
  • Database Function DAVERAGE

Courses can be customized to suit your training needs. Please send us a detailed email. We would be happy to provide you with the most cost effective solution.

Checkout More Course Outlines


Rapid Computer Training, Inc.
Email: info@rapidtraining.ca
2005, Rapid Computer Training, Inc.

Training      For             All