Sage 50 Training
Sage 50 Training provides your team with the knowledge they need
Sage 50 combines the power of desktop accounting with cloud computing, allowing you to access your critical information any time, from anywhere. With Sage 50 Training your users can improve their knowledge & efficiency when using Sage 50 – saving valuable time.
Yes, Sage 50 can do wonders for your business, but to get the most out of it, you need effective training.
And although Sage 50 can be intuitive to a point, chances are without the right training, you’ll only scratch the surface of what it can do for you.
GCC run & offer expert Sage 50 Training courses:
Sage Reporting with Microsoft Excel – Session 1 & 2: Fundamentals & ODBC
Learn how to integrate your Sage 50 Accounts data with Microsoft Excel. And learn how to run Microsoft Excel Query on your data.
Sage Reporting with Microsoft Excel – Session 3: Pivot Reporting
Learn how to construct Microsoft Excel Pivot Reports form your Sage 50 Accounts data. And how to build-in Microsoft Query to your Pivot Reports.
Sage Reporting with Microsoft Excel Session 4: Using Excel functions to produce reports
Learn how to use: Sumifs, Dsum, Vlookup & H lookup in Microsoft Excel – connected to your Sage 50 accounts data.
Sage 50 Training
All Sage 50 Training courses are held at GCC’s London office – 20 Bowling Green Lane, London, EC1R 0BD.
However, if you would like online training GCC have the technology to deliver training online. Simply contact us to discuss your training needs.
To view upcoming Sage 50 Training Course dates please view GCC’s events.
Need to move Sage 50 Accounts into the cloud?
Sage Reporting with Microsoft Excel – Session 1 & 2: Fundamentals & ODBC
1-day Sage 50 Training Course: 9.30am – 5pm
Learn how to integrate your Sage 50 Accounts data with Microsoft Excel using ODBC & running Microsoft Excel Query.
This 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
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 £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 to discuss your needs.
Sage Reporting with Microsoft Excel: Session 1 & 2
Sage Reporting with Microsoft Excel – Session 3: Pivot Reporting
1/2-day Sage 50 Training Course: 9.30am – 1pm
Learn how to integrate your Sage 50 Accounts data with Microsoft Excel using ODBC – producing Pivot Reports.
Training will allow users to become proficient in:
- Using Data returned from Sage via ODBC to construct Pivot reports
- Using Microsoft Query to select tables and data
- Setting up criteria in Microsoft Query
- Pivot report layout options
- Expanding and collapsing data field
- Inserting totals and subtotals
- Inserting Slicers/Timelines
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 to discuss your needs.
Sage Reporting with Microsoft Excel: Session 3
Sage Reporting with Microsoft Excel – Session 4: Using Excel Functions to produce Reports
1/2-day Sage 50 Training Course: 9.30am – 1pm
Learn how to integrate your Sage 50 Accounts data with Microsoft Excel using ODBC – producing Pivot Reports.
Training will allow users to become proficient in:
- Using Range names and absolute address
- Using the Sumifs function
- Using Dsum function
- Using Vlookup function
- Using Hlookup function
This course is £250, and you will receive our own training manual. (All prices exclude VAT).
A pricing discount is available if you book multiple sessions – please get in touch to discuss your needs.
Sage Reporting with Microsoft Excel: Session 4
Why Sage 50
Access from anywhere
Sage 50cloud can be installed on-premise or in the cloud (with Microsoft Azure) – you choose.
Microsoft Office 365 Integration
Connects with Microsoft 365, giving you integrated access to trusted applications such as Word, Excel, PowerPoint, and Outlook from any device.
Cash flow & Invoicing
Manage cash flow, income, expenses, and payments. Create professional personalised invoices & quotes.
Reporting & Insights
Powerful built-in reporting & dashboards – get a real time view of your numbers by different departments, cost types and cost codes.
Stock & Inventory
Track and manage stock – keeping control of your assets with stock valuations & audits.
Payments and Banking
Streamline processes with integrated payments – get paid on time, every time by automating payment collection.
Customer Testimonials
Sage 50 Support
GCC provide ‘Sage 50 Accounts Support’ to Sage 50 Accounts users, which includes:
- Telephone support
- Remote dial in support
- Data repair service
- Report designer assistance
- Online Portal Access
Speak to a member of the GCC team to find out how we can support your Sage 50.
Contact usProducts – Business Software – ERP & CRM
Business Software can help your business to become more competitive, more efficient & more productive.
GCC has the expertise and experience to help you decide on the right Business Software for your business, from the many options available.
Sage 200 can give you an in-depth insight into your business – growing & adapting as your business grows.
Business Central is the cloud-based all-in-one business management solution from Microsoft.
Microsoft Power Platform unleashes the potential of your business with better insights & improved efficiency.
Connect your sales, marketing and service teams with Microsoft Dynamics 365 CRM.