Excel Advanced Functions and Formulas

CAD 325.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 and register thereafter: info@rapidtraining.ca

Excel Advanced Functions and Formulas
O365/2021/2019/2016

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.

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 IFS
  • 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