Sage 50 Accounts Reporting with Microsoft Excel

LEARN HOW TO INTEGRATE YOUR ACCOUNTS DATA WITH MS OFFICE
1 DAY TRAINING COURSE

Sage 50 Accounts Training in London (EC3N 1NT)

 

Course objectives:
  -  How to use Sage 50 Accounts Integrated Reporting
  -  Create a live link from Sage 50 Accounts to Excel
  -  Query your accounts data
  -  Demystify powerful Excel commands such as; Pivot Tables, SumIF, DSum, vLookup,
     hLookup and Concatenate

Sage Integrated Reporting 
  -  Run reports into Excel from Sage
  -  Adding Reports from Sage into Excel
  -  Modifying existing reports

Live link between Excel and Sage 50 Accounts data
  -  Setting up ODBC to link Excel to Sage Data
  -  Using Microsoft Query 
  -  Amending Data range properties
  -  Using Filters on returned data tables 
  -  Functions to use with data tables, such as SumIF, DSum, vLookup, hLookup,
     Concatenate.

View client feedback 

This course costs £245 and you will receive your own PC and training manual.

If you have a colleague that would like to attend, then they may share your PC for an additional £100.  All prices exclude VAT.

 

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