Excel as a Payroll Tool – Intermediate

This course has been introduced by popular request to ensure that those with less
experience of Excel who want to get more to grips with it are brought up to speed
before attending the more advanced course.
Computers are provided on this course to ensure that delegates receive hands on
practical experience.

Course Programme
• Sort, sub-total & average data within your spreadsheets
• Ensure data integrity with check totals, passwords & permissions
• Make your data more interesting with embedded graphs & charts
• Use Auto shapes & Flow charts to map & improve your processes
• Convert spreadsheets into web pages & link them with Hyperlinks
• Perform efficient month-end tax reconciliations
• Generate electronic payroll timetables
• Use the If function to efficiently manipulate data
• Create organisation charts
• Track your changes when altering an existing spreadsheet
• Alter the options within your default spreadsheets
• Get the most out of the Help function

Each area will gain from the following:
• A payroll related worked example
• An understanding of its benefits to the payroll department

Back to overview