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.

We have distinct course dates for Pacific and Eastern Time zones. You can explore both options below.

SKU: N/A Category:

Excel Advanced Functions and Formulas

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 for you. Those who are totally new to Excel should take our Excel Level-1 & Level-2 courses first.

Prerequisites: 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.

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 training is currently not available due to the COVID-19 pandemic)
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

12-Nov-2021, 03-Feb-2022, 31-Mar-2022, 26-May-2022, 21-Jul-2022, 15-Sep-2022, 09-Nov-2022, 26-Nov-2021, 17-Feb-2022, 13-Apr-2022, 09-Jun-2022, 04-Aug-2022, 28-Sep-2022, 24-Nov-2022