1 Day

Overview
This course is designed as an introduction to the Unit4 ERP Excel add in tool, Excelerator. This course will enable you to directly query your Unit4 ERP system directly from Excel and build comprehensive spreadsheet-based management report packs.

Attendees will work through sample worksheets as practical examples during the course.

Course Agenda

• Introduction / Overview of Excelerator Reporting
• Excel workbook components
• Structure of the report sheet
• Basic Excelerator keywords
• The Source section
• Retrieving report data
• The Column section
• The BREAK keyword to send the output to multiple sheets
• Formatting numerical values
• The Row section
• Sub-sets, crosstabs and subtotals
• Parameters: Define and use
• Traditional methods of reporting on ERP data
• Creating and working with report template sheets
• The SHEET keyword
• Creating management reporting packs

 
Cost per Attendee = €400 / £350

Please read our cancellation policy and booking terms and conditions. 

The Row section