Excel Courses for HR and
Admin Professionals

Two Hands-on Intensive Courses

 • Formulas and Functions for HR
 • PivotTable and HR Data Management


The above two courses are specifically designed for HR and Admin Professionals who also perform HR functions in their organizations. They can also be attended by any computer user who wants to have a comprehensive grip on Excel. The course exercises focus on and strongly relate to HR topics.

Each course runs for a day from 9AM to 5PM. The two courses can be taken together or separately. However, it is recommended that you take the Formulas and Functions course before the PivotTable course. These courses are offered in downtown Vancouver and, from time to time, in different cities in Canada.

Formulas and Functions for HR

This course focuses on the use of formulas and functions in various HR scenarios. With the help of several skills covered in this course, you will be able to perform many calculations with ease, speed and a great level of confidence. This course will also show you how to set up your worksheet on auto-pilot, re-use it and re-purpose it for other applications. Essentially, after the course, you will stop using Excel just as a calculator and start using it as a system with far-reaching results.

Prerequisites:
Proficiency in Windows environment with excellent mouse skills. Everyday work experience of Microsoft Excel with simple formulas and functions. Those who are totally new to Excel should take our Excel Level-1 course first.

Course Duration: One Day (9AM to about 5PM).

Platform: Windows PC- Excel 2016/2013/2010.

Course Pace/Style: Medium to fast; hands-on, intensive.

Course Fee: $350 per participant

Cancellation Policy: Please click here to view

Course Material: Specially designed Excel course files.

Course Outline: Please click here to view

Class Location: 325 Howe St, Suite 608, Dntn Vancouver

Course Schedule: Please click here Course Schedule

PivotTable and HR Data Management

An Excel worksheet can store a large amount of data. Often, data is either hand-generated or imported from an HRIS system. Gleaning useful information from a large dataset and organizing it in a well formatted report can be overwhelming for many users. This course focuses on the tools available in Excel to manage and analyze HR data in an effortless manner.

With the help of several skills covered in this course, you will be able to perform many data related tasks with ease, speed and a great level of confidence. This includes custom sort, advance filtering, use of Database Functions, professional formatting, PivotTable reporting/charting and setting up automatically refreshable queries. If your task involves slicing and dicing, this hands-on course will give you many powerful tools.

Prerequisites:
Successful completion of our Formulas and Functions for HR course OR must have a good command over Excel formulas and functions. Proficiency in Windows environment with excellent mouse skills.

Course Duration: One Day (9AM to about 5PM).

Platform: Windows PC- Excel 2016/2013/2010.

Course Pace/Style: Medium to fast; hands-on, intensive.

Course Fee: $350 per participant

Cancellation Policy: Please click here to view

Course Material: Specially designed Excel course files.

Course Outline: Please click here to view

Class Location: 325 Howe St, Suite 608, Dntn Vancouver

Course Schedule: Please click here Course Schedule




Rapid Computer Training, Inc.
Email: info@rapidtraining.ca
2005, Rapid Computer Training, Inc.

Training      For             All