Duration: 1 Day (09:00 – 16:30)
Target audience: Payroll administrators and students
Add a new report: The Report Manager tool allows you to create customised reports and display the information in MS Excel.
Add parameters for the report: Parameters can be added to the reports to print only selected employees, e.g. sort employees per department or print employees for selected branches.
Use Excel functions to create customised reports: Once the report has been run, the data will be available in MS Excel. You are able to use MS Excel functions to create standard MS Excel spreadsheets.
Use Pivot Tables in MS Excel: A pivot table is a MS Excel automated function that allows you to organise and summarise your data into a table format that is easy to understand.
Create and link a template: Once the data in MS Excel is in the required format you can link the spreadsheet as a template. When the report is run, the data will automatically be displayed in the linked template format.
Create union reports: When a report is created, data fields from only one data container can be selected. You are able to combine the data from more than one data container by creating a union report. A union report enables you to select multiple reports to display the information as one report.
Book online now