Two half-days of four hours
In this new Excel level 2 training developed specifically for payroll specialists, you will learn more about how to use Excel to reconcile data. This training will give you the tools to manipulate large databases and produce effective and professional reports. Discover several functions and methods to increase efficiency. You will also learn how to create graphics and a navigation system through a well-structured file.
We also see techniques for monitoring the quality and integrity of data.
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.
For intermediate users.
Must know the basic manipulations in Windows.
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 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.
Review (revision of topics already covered in previous training)
- Addressing absolute and mixed cells
- DATE function : DATEDIF
Functions (100% new exercises)
- Multiple search functions
- Several mathematical and statistical functions
- Technique to control the completeness of the data
Structure your data (80% new exercises)
- TABLE object
- Use of named fields
- Remove duplicates
- Using drop-down lists
- Using hyperlinks to navigate inside a file
- Example of an effective Excel file
Conditional formatting (100% new exercises)
- Using custom rules
- Identify duplicates
- Data Bars
3D functions (100% new exercises)
- Structure to respect when applying functions on multiple sheets
- Syntax of 3D functions
File Security (100% new exercises)
- Secure certain sections of a sheet to make cells inaccessible
Integrative exercise (100% new exercise)
- Use of several features seen in the course
- Add a chart to the produced report
Power Query Demo (New)
AI Demonstration (ChatGPT) (New)
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.