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 

 

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