Live OnLine,
Instructor Led Training

We Make OnLine Training as Good as In-Person Training

How does OnLine Training work?
Important information for attendees.

All our public training is delivered via ZOOM video conferencing application that works the best for our training. We can also deliver training via Webex or MS Teams, if you book a private, group event.

We offer OnLine training in Hands-on Mode. It is delivered by a live instructor. We do not train by playing pre-recorded videos. Attendees learn by performing the tasks that the instructor demonstrates on their screen. The attendees can also communicate with fellow participants and the instructor via live audio and video. The training is professional and as good as in-person training. Our attendees like it a lot. 

In the Hands-on Mode delivery, attendees work with two application windows on their local computer. The first window is their own work area and the second window displays the instructor’s work area via Zoom video conferencing application.

To get the best from OnLine training, the following computer setup is required:

    • An attendee’s computer must be a Windows PC with a video camera and audio capability. 
    • Our courses are interactive. An attendee must be audible and visible to all other attendees and the instructor, as in an in-person class.
    • Please note an attendee will not be allowed to attend the course without a clear audio and video connection. No free retake of the course is granted in such cases.
    • You can check your audio and video connection with a friend or with the Test Meeting feature provided by ZOOM corporation on their website by clicking on this link: ZOOM TEST 
    • A USB headset (headphone with microphone) is recommended for crystal clear audio conversation. Using the laptop’s speakers & microphone can sometimes create annoying echoes in the class.
    • Please consider using two computer monitors. One monitor will display your work window and the other, the instructor’s (Zoom) window. Any modern home TV can be used as a second monitor.
    • An attendee can attend our OnLine training with only one computer monitor. However, they may not be able to keep pace with the class while doing hands-on exercises.
    • A high-speed Internet connection is required. A wired connection works better than wireless, as it is more stable and has more throughput.
    • The attendee’s computer must have the software that the attendee wants to learn. For example, if you have signed up for an Excel course, Excel must be installed on your PC.
    • An attendee will need to install the Zoom Video Conferencing app to join the training session. It can be downloaded for free from www.zoom.us. Please familiarize yourself with the application.
    • For private group training via Webex or MS Teams, please contact us for details.
    • A PDF reader is required to view the course materials that will be sent to you as a PDF file. PDF readers are available for free on the net.  
    • Please do not register for a course if your computer does not have the audio and video capability or if you do not agree to keep the mic and the video camera on throughout the class. 
    • A certificate of course attendance is issued only after 100% attendance is observed

Excel Formulas and Functions for HR Professionals
Version 2013/2016/2019/365

This course focuses on learning Excel formulas and functions and their applications in various HR scenarios. Learn a variety of Excel functions for tackling quantitative tasks for effective decision making. Orient your approach towards automating tasks with logical functions and reducing tedious labour with Excel time savers.

With the help of several skills covered, you will be able to perform many calculations with ease, speed, and a great level of confidence. Create and manage budgets, metrics, and projections with ease. Create business charts to display the key HR indicators. Design a form for collecting HR data with validation rules. After the course, you will be able to use Excel as a system with far-reaching capabilities. View the detailed course outline by clicking on the link given below.

Prerequisites: Proficiency in Windows PC environment with excellent mouse skills. Some work experience of Microsoft Excel with basic formulas and functions.
Software Version: Microsoft Excel 365/2019/2016/2013 for Windows PC.
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver, Los Angeles)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto, New York)
Course Dates: Several available, displayed when you begin to register.
Course Pace and Style: Medium-to-fast; hands-on, intensive, interactive.
Course Delivery Format-1: OnLine Live with an Instructor.
Course Delivery Format-2: In-Person, for group training, at client sites in Canada only.
Course Fee Per Attendee: USD $385 (includes course material cost).
Course Outline Link: Excel Formulas and Functions for HR
Cancellation & Date Change Policy Link: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Rapid Computer Training is recognized by SHRM to offer Professional Development Credits (PDCs) for SHRM-CP® or SHRM-SCP® recertification activities. This course is pre-approved for 6.5 PDC.
This course is pre-approved for 6.5 CPD hours by
CPHR-BC &Yukon
CPHR-Alberta
CPHR-Manitoba

Excel Data Analysis for HR Professionals
Version 2013/2016/2019/365

Microsoft Excel as a savvy tool for enabling quantitative and research skills. HR data is either entered manually in Excel or downloaded from HRIS. For an evidence-based approach, it must be analyzed and summarized to reveal key indicators. Ordinarily, gleaning action-ready information from a large dataset could be challenging for many. This course focuses on Excel tools that will add to your perceptiveness and insight into data for effective decision making.

Learn to create and maintain well formatted data in Excel. Use the advance tools and complex criteria to filter and query the data. Create and apply custom criteria for sorts and nested sub-totals. Use PivotTable to create complex, well formatted summary reports effortlessly. Apply formula based conditional formatting to sort and filter visually. As well, create a dynamic HR dashboard in the class to reveal and monitor key indicators. In short, on completion of this course, you will be able to perform many analytical tasks with ease, speed, and a great level of confidence. For more details, please click the link below to view the course outline in PDF.

Prerequisites: Successful completion of our Formulas and Functions for HR course. Proficiency in Windows environment with excellent mouse skills.
Software Version: Microsoft Excel 365/2019/2016/2013 for Windows PC.
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver, Los Angeles)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto, New York)
Course Dates: Several available, displayed when you begin to register.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format-1: OnLine Live with an Instructor.
Course Delivery Format-2: In-Person, for group training, at client sites in Canada only.
Course Fee Per Attendee: USD $385 (includes course material cost).
Course Outline Link: Excel Data Analysis for HR
Cancellation & Date Change Policy Link: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Rapid Computer Training is recognized by SHRM to offer Professional Development Credits (PDCs) for SHRM-CP® or SHRM-SCP® recertification activities. This course is pre-approved for 6.5 PDC.
This course is pre-approved for 6.5 CPD hours by
CPHR-BC &Yukon
CPHR-Alberta
CPHR-Manitoba

Upcoming Online Excel Courses for
HR Professionals

CourseStart DateLocationTime ZonePrice-USD
Excel Formulas and Functions for HR03-Oct-2023OnLineEastern385.00
Excel Data Analysis for HR06-Oct-2023OnLineEastern385.00
Excel Formulas and Functions for HR16-Oct-2023OnLinePacific385.00
Excel Data Analysis for HR24-Oct-2023OnLinePacific385.00
Excel Formulas and Functions for HR30-Oct-2023OnLineEastern385.00
Excel Data Analysis for HR03-Nov-2023OnLineEastern385.00
Excel Formulas and Functions for HR14-Nov-2023OnLinePacific385.00
Excel Data Analysis for HR17-Nov-2023OnLinePacific385.00
Excel Formulas and Functions for HR27-Nov-2023OnLineEastern385.00
Excel Data Analysis for HR01-Dec-2023OnLineEastern385.00

MICROSOFT EXCEL CERTIFICATION

Our Excel for HR courses cover a good number of skills measured by Microsoft in their Excel certification exams. Those planning to write these exams will find our courses bolstering their efforts to earn a certificate directly from Microsoft. Please follow the link below to their site for more information.

Microsoft Office Specialist: All Exams