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
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
Upcoming Online Excel Courses for
HR Professionals
Course | Start Date | Location | Time Zone | Price-USD |
---|---|---|---|---|
Excel Formulas and Functions for HR | 03-Oct-2023 | OnLine | Eastern | 385.00 |
Excel Data Analysis for HR | 06-Oct-2023 | OnLine | Eastern | 385.00 |
Excel Formulas and Functions for HR | 16-Oct-2023 | OnLine | Pacific | 385.00 |
Excel Data Analysis for HR | 24-Oct-2023 | OnLine | Pacific | 385.00 |
Excel Formulas and Functions for HR | 30-Oct-2023 | OnLine | Eastern | 385.00 |
Excel Data Analysis for HR | 03-Nov-2023 | OnLine | Eastern | 385.00 |
Excel Formulas and Functions for HR | 14-Nov-2023 | OnLine | Pacific | 385.00 |
Excel Data Analysis for HR | 17-Nov-2023 | OnLine | Pacific | 385.00 |
Excel Formulas and Functions for HR | 27-Nov-2023 | OnLine | Eastern | 385.00 |
Excel Data Analysis for HR | 01-Dec-2023 | OnLine | Eastern | 385.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.