Excel Advanced Functions and Formulas

CAD 285.00

Intensive, hands-on, half-day Excel Advanced Functions and Formulas course delivered online by a Live Trainer and not recorded Videos. Please read prerequisites and other details in the description below.

There are no set dates for this course. It is scheduled on request. Please contact us via email for available dates: info@rapidtraining.ca

Excel Advanced Functions and Formulas

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

Prerequisites: Skills learned in our Excel Beginner & Intermediate courses or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.

Software Version: Microsoft Excel 2013/2016/2019/O365
Course Duration: Half Day
Class Times-1: 9:00 AM to 1:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 1:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person option is available for group training only)
Course Outline Download: Advanced Functions and Formulas
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Course Outline

What is covered in the course?

  • 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


Class Start Time

9:00 AM Pacific Time, 9:00 AM Eastern Time

Course Date

Please Contact us for Dates