Register Online Today!

Upcoming Dates
La Prairie - September 28 (French)
Montreal - October 12 (French)
Laval - October 19 (French)
Montreal - October 25 (French)
Laval - Dec 8 (French)

Rates

CPA Members - Early-bird (register 14 days prior to seminar date)
$399.00 plus taxes
CPA Members - Regular:
$449.00 plus taxes
Non-member - Early-bird (register 14 days prior to seminar date)
$499.00 plus taxes
Non-member - Regular:
$549.00 plus taxes

Excel Training for Payroll Professionals (French Only)

One-Day Seminar

For certified members, this seminar counts toward 7.5 hours of Continuing Professional Education. Click here to find a date and location in your area.

Developed especially for payroll professionals looking to enhance their Excel skills, this seminar will significantly increase your productivity and improve the completeness of your reports to ensure compliance with the various government requirements. Expert instructors François Jasmin (CPA, CA) and Stéphane L’Archevêque (AICB) each have over 20 years of experience, having managed and supervised payroll departments.

Learn through hands-on, interactive exercises tailored to the roles and responsibilities of payroll professionals and understand Excel tips and tricks for activities and reports including:

  • Tracking of salary increases
  • Production of workforce budgets
  • Tracking of actual labour costs versus budgets
  • Tracking of sick leave and vacation banks
  • Year-end reconciliation of fringe benefits (CNT, CNESST, RRQ, Employment Insurance)
  • Tables for tracking garnishments, alimony and child support
  • Spreadsheets for retroactive pay increases

To attend this training, you must have basic knowledge of Excel.

Course description

  • Upgrading
    • Addressing absolute and mixed cells
    • Database structure
  • Importing data
    • Converting data from payroll systems
    • Cleaning data
    • Data transformation
    • Connecting with external databases
  • Essential functions to be mastered
    • Date functions
    • Text functions
    • Logical functions
    • Search functions
    • Statistical functions
  • Array formulas (synthesis formula)
    • Creating tables
    • Using named fields
    • Drop-down menus
    • Structure of array formulas
  • Conditional formatting
    • Rules for highlighting cells
    • Icon sets
    • Custom rules
    • Creating check and validation rules
  • Navigation sheets
    • Home page
    • Hyperlinks
  • 3D functions
    • Consolidating data for multi-tab files
  • Managing security
    • Protecting a workbook
    • Protecting a worksheet
    • Controlling editable areas
  • Technical clarification

Solutions d'affaires SLV Inc. will provide the notebook computers and USB flash drives required for this seminar.