Sage 50 Excel: Part 2 - Creating Pivot Reports linked to Sage Data

1/2 DAY TRAINING COURSE

Sage 50 Accounts Training in London
1 Rushworth Street, London, SE1 0RB

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 £175 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 Location




Training Venue:
1 Rushworth Street
London
SE1 ORB

 




To discuss your needs and see if this course is suitable please contact us on 020 7831 3050 or email: info@CentrePointSoftware.co.uk

 

Register your interest