Excel as a Payroll Tool – Advanced Level

This popular course is ideal for those with some Excel experience who would like to learn how to enhance their skills using Excel to improve their payroll procedures. The new DPS service which replaced the Internet Secure Mailbox, allows employers to download information into a CSV file to import into the payroll. This course shows you how to import CSV files onto the payroll.

Our tutor will demonstrate how to utilise the application to your advantage, which will enable you to free more of your value time to concentrate on the key activities of the department.

Computers are provided on this course to ensure that delegates receive hands on
practical experience.

Course Programme
• Amend the format of spreadsheets that have been set up
• Perform mass editing & formatting of spreadsheets
• Merge cells & workbooks
• Sort & filter data
• Use lookup tables
• Apply conditional statements
• Transpose & copy data
• Create automatic links between spreadsheets
• Automate regular commands using MACROS – how to record & apply them
• Convert data to Excel format or import to your payroll system using text & comma    separated values (CSV) facilities
• Use Excel with Outlook
• Use data as a mail merge in Word

Comprehensive handouts are provided showing details of all the above with step-by-step guidance to each delegate attending this worthwhile course.

Back to overview