Sage 50 Accounts - Linking to Microsoft Office

Product type
E-Learning

Sage 50 Accounts - Linking to Microsoft Office

£238check
  • VAT: excluding VAT
  • Price completeness: This price is complete, there are no hidden additional costs.
/E-Learning
Bridge Training Solutions
Get alternatives
Logo Bridge Training Solutions

Need more information? Get more details on the site of the provider.

Get alternatives
Description

Linking Sage 50 Accounts to Microsoft Office - Classroom Course - 1 Day Course

Training Schedule - Course Objectives (You will be able to:)



    • Have had a basic introduction to the ODBC (Open DataBase Connectivity) driver

    • Be able to navigate around the menu options available in Microsoft® Query

    • Know how to update the live link between the query and Sage 50 Accounts using the refresh option

    • Understand how to add both single and multiple calculations to a query, then return the data to Microsoft® Excel and format the cells

    • Be able to run a mail merge within Microsoft® Word to link the data in Sage 50 Accounts to a Word document

    • Know …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft Office (management), Microsoft Office, SAGE (Accounting Software), Microsoft Word, and Microsoft Powerpoint.

Linking Sage 50 Accounts to Microsoft Office - Classroom Course - 1 Day Course

Training Schedule - Course Objectives (You will be able to:)



  • Have had a basic introduction to the ODBC (Open DataBase Connectivity) driver
  • Be able to navigate around the menu options available in Microsoft® Query
  • Know how to update the live link between the query and Sage 50 Accounts using the refresh option
  • Understand how to add both single and multiple calculations to a query, then return the data to Microsoft® Excel and format the cells
  • Be able to run a mail merge within Microsoft® Word to link the data in Sage 50 Accounts to a Word document
  • Know how to create labelled envelopes from the names and addresses in Sage 50 Accounts
  • Understand how to use the If…Then…Else statement within Microsoft® Word
  • Be able to use multiple tables within Microsoft® Excel and join the tables together
  • Know how to use the cycle through totals option in Microsoft® Query
  • Be able to create graphs in Microsoft® Excel based on data from Sage 50 Accounts and create a live link to Microsoft® PowerPoint
  • Know how to create pivot tables and charts in Microsoft® Excel to dynamically interrogate the Sage 50 Accounts data
  • Know how to add criteria to select specific data from Sage 50 Accounts
  • Be able to set up parameter queries to enable specific ranges to be entered when requesting data from Sage 50 Accounts
There are no reviews yet.
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.