GCC Events

Sage 50 Accounts Training – Sage Reporting with Microsoft Excel – Session 2: ODBC

Join us on Friday 18th March for a half day of online classroom training on ‘Sage Reporting with Microsoft Excel – Session 2: ODBC’.

Date: Friday 18th March 2022

Time: 09:30am – 1:00pm

Online Training

To book your place please contact our training team on 0345 260 1161 or email David.Foster@gcc.co.uk

Learn how to integrate your Sage 50 accounts data with Microsoft Excel (Session 2: ODBC).

Training will allow users to become proficient in:

  • Setting up ODBC link between Sage & Excel
  • Using Microsoft Query to select tables and data
  • Setting up criteria in Microsoft Query
  • Using Run Time criteria
  • Joining Multiply tables in Query and in Excel
  • Edit and modify queries previously written

This course is £250 and you will receive your own training manual.  (All prices exclude VAT) 

A pricing discount is available if you book multiple sessions – please get in touch on 0345 260 1161 to talk to us.

Online Training

Due to the current situation concerning COVID, all training will take place online.

Using the latest technology, we can offer an online classroom where students can interact with the tutor live. The tutor can watch each students screen simultaneously to ensure no-one falls behind – getting the maximum benefit from the session.

To give you the best value, classroom sizes will be kept small with no more than 5 students – with breaks as required.

  • Each student will receive a PDF copy of the training manual in advance of the session.
  • All classes will be recorded and distributed after the session, so you can re-watch as and when needed.

Prior to the training the tutor will be in touch, logging onto each student’s computer:

  • Checking set-up, applications and access for the day of training.
  • Setting up Sage demonstration data – so that all students are working from a compatible data set.

Join us on Friday 18th March for a half day of online classroom training on ‘Sage Reporting with Microsoft Excel’

To discuss your needs and see if this course is suitable for you, contact our training team on 0345 260 1161 or email David.Foster@gcc.co.uk

If you have any questions regarding this event we’re here to assist.

Why Sage 50

Cash flow & Invoicing

See what you’re owed, manage late payments, and schedule supplier payments.

Reporting & Insights

Get a real time view of business performance: simple in-depth reporting or customisable reports, plus cash flow anayalsis.

Stock & Inventory

Perform stock takes updating stock levels automatically, and also create multi-product builds and keep control of your assets with stock valuations and audits.

Simple, powerful VAT management

Calculate VAT quickly, reconcile to only pay what you owe & automatically file returns securely online with HMRC.

Microsoft Office 365 Integration

Sage 50 integrates with Microsoft 365, giving you access to essential apps and financials on any device, anywhere.

Payments and Banking

Streamline processes with integrated payments – get paid on time, every time by automating payment collection.

Case Studies

Find out for yourself how customers are enjoying success with IT solutions & GCC services to support their business.

Dyaco UK

Start-up company Dyaco UK invest in Sage 200 to meet their stock management needs and accelerate growth.

Read more
Insight Gloucestershire

GCC helps Gloucestershire’s oldest charity increase productivity with Microsoft Dynamics CRM.

Read more
Medical Supermarket

Medical Supermarket invests in Microsoft Dynamics 365 Business Central to support their growth.

Read more