Sage 50 Accounts Training – Sage Reporting with Microsoft Excel – Session 1 & 2: Fundamentals & ODBC
Join us on Tuesday 27th September for a full day Sage 50 course – Training on ‘Sage Reporting with Microsoft Excel – Session 1 & 2: Fundamentals & ODBC’.
Date: Tuesday 27th September 2022
Time: 09:30am – 5pm
Sage 50 Course Training Location:
GCC Offices, 20 Bowling Green Lane, London, EC1R 0BD
If you would like online training GCC have the technology to deliver this course online.
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 1: Fundamentals).
Training will allow users to advance their skills in:
- Selecting column data to Excel
- Selecting and Modifying Column Layout in Sage to send
- Using quick filters and advanced filters to control information
- Saving existing previewed Sage reports in Excel
- Using Sage Integrated Reporting with standard given reports
- Modifying other Sage reports to work with Integrated Reporting
- Using Sage Functions
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
If this course does not meet your needs GCC run a range of Sage 50 Accounts training – view all the courses GCC offer.
If you would like online training GCC have the technology to deliver this course online. So please get in touch to discuss your needs.
This course is £450, 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.
Sage 50 Course (Classroom) Training
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.
Join us on Tuesday 27th September for a full day Sage 50 course – 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 analysis.
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.
Find out for yourself how customers are enjoying success with IT solutions & GCC services to support their business.
Start-up company Dyaco UK invest in Sage 200 to meet their stock management needs and accelerate growth.
GCC helps Chipping Campden School meet their business asset register requirements by utilising Sicon Fixed Assets for Sage 200.
The heat is on! Strong Energy chooses GCC to supply and support Microsoft 365.