Sage 200 with Microsoft Office Online Training Course
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.
This online course will show you how to:
• 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.
The course will be run online in a virtual classroom environment using Microsoft Teams.*
Who should attend?
This online 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.
Training Course Price
£350.00 (plus VAT)
How to book
Book Your Place > https://espi.net/product/sage-200-with-microsoft-office-training-course/
Please note: If you are going to attend our online courses, you will get a better experience using two monitors.
*To access the course all attendees must have a device with a front facing camera, a microphone and device sound, and access to Microsoft Teams (free to download as an app).