SHRM PDC Courses for
HR & Admin Professionals
We Make OnLine Training as Good as In-Person Training
HR professionals prefer solving problems through data analysis and critical evaluation. MS Excel is essential for tasks like budgeting, analysis, forecasting, metrics, retention, payroll, projects, and detailed reports. To meet these challenges, take our HR-centric courses with your team. All courses are instructor-led, hands-on, and come with course materials. Check out reviews from past HR attendees below.
Excel Formulas and Functions for
HR Professionals
SHRM PDC 6.5 Course Credit
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/2021/2019/2016 for Windows PC.
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Los Angeles, Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (New York, Toronto)
Course Dates: Several available, displayed when you begin to register.
Course Pace and Style: Medium-to-fast; hands-on, intensive, interactive.
Course Delivery Format: Online Live with an Instructor. We do not use recorded videos for training.
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 also pre-approved for 6.5 CPD hours by
CPHR-BC &Yukon
CPHR-Manitoba
Excel Data Analysis for
HR Professionals
SHRM PDC 6.5 Course Credit
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/2021/2019/2016 for Windows PC.
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Los Angeles, Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (New York, Toronto)
Course Dates: Several available, displayed when you begin to register.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: Online Live with an Instructor. We do not use recorded videos for training.
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 also pre-approved for 6.5 CPD hours by
CPHR-BC &Yukon
CPHR-Manitoba
Access Database for
HR Professionals
SHRM PDC 6.5 Course Credit
Microsoft Access is a widely-used desktop database application for business, commercial, and industrial purposes. As a relational database, it organizes data into tables that can be interconnected. Additionally, it features a robust query tool, enabling users to retrieve information from the database for reporting and decision-making purposes.
The Access for HR & Admin Professional course is an introductory program tailored for HR and Admin personnel eager to discover how MS Access can significantly benefit a Human Resources department. The practical exercises are HR-centric, providing a solid foundation in desktop database creation. Participants will learn to construct a new Access database with employee data, establish Table Relationships, and develop Queries, Forms, and Reports. Additionally, the course enhances confidence in managing existing databases, given that databases form the core of all HRIS software. For a comprehensive understanding of the course content, please consult the detailed outline provided below.
Prerequisites: At least six months of experience working in Windows environment with mouse. Some keyboard skills also required. Some experience of working with Excel is desirable but not necessary.
Platform: Microsoft Windows
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Los Angeles, Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (New York, Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Instructor-led, Hands-on, Intensive, Interactive.
Course Delivery Format: Online Instructor-led. We do not use recorded videos for training.
Course Fee: USD $300 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Access_Database_for_HR
Cancellation & Date Change Policy: 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 also pre-approved for 6.5 CPD hours by
CPHR-BC &Yukon
CPHR-Manitoba
Testimonials
Rapid Computer Training takes pride in its Training Services. Here are a few testimonials from our past attendees.
“I recently attended two Excel workshops (Excel Formulas & Function and Excel Data Analysis) specifically targeted at HR professionals. I originally attended the workshops as a means of a refresher but discovered that there was so much more functionality within Excel that was either new or which I had not utilised previously. Suresh did an excellent job at tailoring the courses to HR subject matter, and supported the delivery of a lot of learning in a fun and informative manner. Both courses were delivered via an online platform, but the way the course was set up together with a comprehensive workbook, ensured that the learning experience was still awesome. You are never too far in your career to learn, and I enjoyed attending the workshops and the learning it provided.”
Beth Millard-Hales, CPHR, SHRM-SCP
“I took the Excel Formulas and Functions for Human Resources with Suresh in mid-December 2020 via an online platform. I really enjoyed the way the course was set up; we started with the “basics” (an excellent refresher and ensured that I could easily do them) then moved into the more specialized features (i.e. If, And, Nesting, VLOOKUP etc). Best of all, the course was customized for Human Resources professionals so it focused the Excel features that I can use right away on the job.
Suresh is an excellent instructor. He methodically walked through the process for each function; he was supportive and encouraging; and he answered all of my questions.
Each easy-to-follow step-by-step process is documented in the learner’s manual for future reference. Well done!”
Brit Cabral, MBA, CPHR, SHRM-SCP
Human Resources Director
BPL Auto Group
“I would highly recommend Excel for the HR Professionals course to any Human Resources or Administrative professional. I had some reservations about one day courses before, but this course proved me wrong. It addresses all the issues every HR professional faces on a daily basis, every minute you will learn something very useful. You will also receive an Excel file that you can later on refer to. The instructor is very knowledgeable and willing to go an extra mile to help the learner understand all the steps of the process. I wish I had taken this course earlier, it would have saved me so much time!”
Mila Gajic CHRP
Human Resources Specialist
KGHM International Ltd.
“I found the information in these (Excel for HR) courses to be extremely useful. The course materials and files are going to be a great resource to me. Suresh managed to compact many HR specific examples and exercises into a mere 2 days training which went by very quickly. I highly recommend this company and instructor, and am recommending to our management that the other HR Admins in our company should definitely take these courses. Thank you again for an exciting, fast paced 2 days of very interesting and job specific training!”
Diane Jensen, CHRP
Employee & Labour Relations Coordinator
Spectra Energy
“Thanks Suresh. I so enjoyed the Excel for HR course yesterday. I learned many tips and tricks that I know I will use in the future. The pace of the course was just right. While I did know some of the content, it was a great refresher. You were very patient with all of us and made the class fun. By the way, I can’t open the file you sent called Dorothy.xlw. I think you may have mentioned this as it was a file saved on the lap top? Thanks again.”
Dorothy Steele CHRP
Manager, Compensation & Benefits
London Drugs Ltd.
“Thank you, Suresh. I found the (Excel for HR) course to be excellent, and very good value for the time and money spent. I really appreciated your teaching style, and your sense of humour; the pace was perfect for me. The functions / tools that you selected to include in the course were all things that I will make use of back on the job, and the exercises you set up extremely relevant. Overall, I am extremely satisfied and will share that with colleagues.“
Cindy Dopson, MBA, CHRP
Director, HR
BC Cancer Foundation
“Suresh, thanks for the (Excel for HR) course file and thanks again for the training session….. very interesting and very valuable.”
Murray MacAlpine
B.Sc., CHRP, CRSP
Human Resources Manager
Novanni Stainless Inc.
“Thank you, Suresh! I was able to open the workbooks successfully. Both Kiki (HR Generalist) and I thought the training was excellent and will be applying our new knowledge to improve some of our existing tools and create some excellent new ones. The course design was very thoughtful, and I appreciated the many examples you gave for applying the Excel functions we covered to HR tools. I also appreciated that you provided our own workbooks with instructions as a takeaway, and your great sense of humour. The course was very engaging – time just flew! Thanks very much! I also plan to share my comments with BCHRMA.”
Margaret Ostrom
Sr. Human Resources Manager
Wallenius Wilhelmsen Logistics
“Hi Suresh, thank you for the files and for the training yesterday. I really enjoyed the Excel for HR course. You went at a pace that was easy to follow and you kept me engaged by putting it in context. I really appreciated that. I look forward to seeing what the next level of excel training looks like for HR Professionals.”
Fiona Ho
HR Generalist
Fortinet
“I attended the Excel for the HR Professionals course in Victoria. I have taken a couple of excel courses in the past from other companies, but Suresh, by far, was the best instructor……”
Jeannie Drew
HR Associate
Royal Roads University
Upcoming SHRM PDC Courses for
HR & Admin Professionals
| Course | Start Date | Location | Time Zone | Price-USD |
|---|---|---|---|---|
| Excel Formulas and Functions for HR | 15-Oct-2024 | OnLine | Pacific | 385.00 |
| Excel Data Analysis for HR | 18-Oct-2024 | OnLine | Pacific | 385.00 |
| Excel Formulas and Functions for HR | 28-Oct-2024 | OnLine | Eastern | 385.00 |
| Excel Data Analysis for HR | 01-Nov-2024 | OnLine | Eastern | 385.00 |
| Excel Formulas and Functions for HR | 12-Nov-2024 | OnLine | Pacific | 385.00 |
| Microsoft Access for HR | 14-Nov-2024 | OnLine | Pacific | 300.00 |
| Excel Data Analysis for HR | 19-Nov-2024 | OnLine | Pacific | 385.00 |
| Excel Formulas and Functions for HR | 25-Nov-2024 | OnLine | Eastern | 385.00 |
| Microsoft Access for HR | 28-Nov-2024 | OnLine | Eastern | 300.00 |
| Excel Data Analysis for HR | 29-Nov-2024 | OnLine | Eastern | 385.00 |
Thinking of Earning MICROSOFT CERTIFICATION?
Our MS Excel and MS Access courses for HR cover many hands-on skills measured by Microsoft in their 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 Microsoft site for more information on exams.
