Sage 200 with Microsoft Office Online Training Course

£350.00

Live link your Sage data to your own Excel spreadsheets for powerful management reporting. Open Database Connectivity (ODBC) is one of the secret tools in MS Excel that makes data in your Sage 200 system available to live link with Microsoft Office products, allowing you to use your familiar reporting tools with your live Sage data, once the report is written all you need to do is refresh it as required.

Course Content

  • Set up the links between MS Excel and your Sage data
  • Write your own reports
  • Use pivot tables
  • Refresh data in your spreadsheets to show the latest Sage information
  • Filter and sort data

 

SKU: N/A Category:

Your booking

Delegate Details

Description

Training Course Time

10am – 4pm

Training Course Location

Online training courses currently available. If you are going to attend our online courses, you will get a better experience using two monitors.

Who Should Attend?

This one-day trainer led course will benefit Financial Controllers, Accountants, Sales Managers or anyone involved in the preparation of reports using Sage 200 data. If you are currently re-keying data into a spreadsheet to generate key reports then this course is for you.