Sage 50 Excel: Part 2 - Creating Pivot Reports linked to Sage Data
1/2 DAY TRAINING COURSE
Sage 50 Accounts Training in London
7 Pepys Street, London, EC3N 4AF
Whilst the course: Sage 50 Accounts Reporting with Microsoft Excel, is still available CentrePoint has now broken this down into 2 day sessions:
- Sage 50 Excel: Part 1 - Sage Reporting and Live Link Excel ODBC
- Sage 50 Excel: Part 2 - Creating Pivot Reports linked to Sage Data
You can spend more time on working through examples and focus in on different aspects of the syllabus.
Sage 50 Excel: Part 2 - Creating Pivot Reports linked to Sage Data
This course is only suitable for delegates who have knowledge of Sage Excel ODBC, and for those who have attended Sage 50 Excel: Part 1 course.
With your data as a table in Excel this course concentrates on how to build Pivot Reports from the data.
Including very practical examples the course will demonstrate:
- Setting up pivot reports
- Selecting Field and Criteria Options
- Grouping fields with and without subtotals
- How to build Nominal Ledger and Profit and Loss drill down reports with filters to
select departments and or date ranges that span more than 12 months.
- Debtor and creditor reports that are able to include due dates as well as original
transaction dates
- Sales analysis reports that help you identify who bought what and when with
information from Sage Invoices and Stock modules.
This course costs from £250 and you will receive your own PC, training manual and refreshments. (All prices exclude VAT)
All delegates will receive a memory stick to take away examples and workings which can be loaded to your own systems)
Training Venue:
DoubleTree by Hilton London - Tower of London
7 Pepys Street, London, EC3N 4AF
To discuss your needs and see if this course is suitable please contact us on 020 7831 3050 or email: info@CentrePointSoftware.co.uk