Excel Training for Payroll Professionals - Level 1
(1 Ratings)
No reviews
One half-day of four hours
This new training will give you the tools to feel comfortable in the Microsoft Excel environment. You will learn several basic features accessible through the ribbons or using keyboard shortcuts. You will learn the difference between formulas and functions as well as the use of some of them. Finally, you will be introduced to Excel tables and pivot tables.
The Trainers
Your team of specialized trainers consist of Stéphanie Perreault, CPA, Marcel Dubé, Silène Saadeh, Stéphane L'Archevêque (ADM.A) and François Jasmin, CPA. They have extensive experience in finance and accounting or IT departments. This training was developed with the tasks and responsibilities of payroll professionals in mind.
Prerequisites
This training is not designed for Apple computer users.
Participants must have access to 2 screens, or 2 laptops or a laptop and a tablet.
- Connect one laptop on ZOOM and upload the exercises on the second laptop.
- Connect the tablet on ZOOM and upload the exercises on the laptop.
Access to a microphone is preferable.
How to access your session:
Three business days before the live event, you will be sent information on how to access your online seminar. If you do not receive the login information three days before the seminar, check your email SPAM folder. If it's not there, please contact membership@payroll.ca as soon as possible.
Environment
- Ribbons and Excel structure
- Home ribbon commands
- Keyboard shortcuts
- Find and replace functionality
- Addressing absolute and mixed cells
Functions
- DATE Functions
- TEXT Functions
- STATISTICAL functions
File Security
- Understand the difference between protecting a file, a workbook, or a sheet
Overview of Excel tables and pivot tables
- How to create a table?
- What is a pivot table?
- Creating the pivot table
- Updating a pivot table
Conclusion
Please note that after registering online for this event, you will receive an email confirmation that confirms your registration. Confirmation emails are sent approximately within 2 business days after the registration has been processed.
Three business days before the live event, you will be sent the link to access the online PD seminar on the scheduled day.
Also, detailed instructions on accessing the online PD seminar will be emailed to you on the morning of the event.
Cancellations or Transfers: requests must be received in writing at least four (4) business days prior to the online seminar date. Please note a cancellation fee or transfer fee in the amount of $50 plus applicable taxes will be applied. Cancellation or transfer requests received after the login information has been provided are not eligible for a transfer or refund.