Advantage Services (Europe) Ltd.
Click to view basket
You have nothing in your shopping basket
   » Home » Sage Training » Sage 50 Accounts Training » Link Sage 50 Accounts to MS Office Contact us  |  Bookmark this page   

Sage training: Linking Sage 50 Accounts with Microsoft Office course description

Linking Sage 50 Accounts with Microsoft Office is a one-day course. Our price is £195.00 (Sage's RRP is £270.00). Book today to save with us.Linking Sage 50 Accounts with Microsoft Office

» Overview: Create professional documentation, dynamically linked to your live Sage Accounts data.

» What do I learn?

Learn everything you need to know about how Microsoft® Office can integrate with Sage 50 Accounts. It includes dynamically linking spreadsheets in Excel, running mail merges in Word and creating live links to PowerPoint presentations.

» By the end of this course you will:

  • 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

» Detailed course content

Click to see the course content

Linking Sage 50 Accounts to Excel and Word course session 1 - Introduction to the ODBC Driver and SQL

  • Data for the ODBC driver
  • Finding the data path
  • Setting up the DSN
  • Upgrading Sage 50 Accounts

Linking Sage 50 Accounts to Excel and Word course session 2 - Linking Sage 50 Accounts With Microsoft Excel

  • Extracting data from Sage 50 Accounts into MS Excel
  • Creating a query using the Query wizard
  • Creating a Query without using the Query Wizard
  • Updating the link

Linking Sage 50 Accounts to Excel and Word course session 3 - Using Expressions

  • Using Expressions to Perform a Calculation
  • Using Multiple Expressions
  • Formatting cells in Excel

Linking Sage 50 Accounts to Excel and Word course session 4 - Linking Sage 50 Accounts to Word

  • Building the query and applying criteria
  • Building the mail merge document
  • Microsoft Word rules
  • Creating a mail merge from Sage 50 Accounts

Linking Sage 50 Accounts to Excel and Word course session 5 - Using Multiple Tables

  • Creating the query with multiple tables
  • Joining Tables
  • Viewing Joins

Linking Sage 50 Accounts to Excel and Word course session 6 - Totalling Data and Graphs

  • Custom fields in Sage 50 Accounts
  • Cycle through totals
  • Linking to Microsoft PowerPoint
  • Cycle through totals on an expression

Linking Sage 50 Accounts to Excel and Word course session 7 - Using Pivot Tables and Charts

  • Creating a query
  • Creating the PivotTable
  • Creating the Pivot Table

Linking Sage 50 Accounts to Excel and Word course session 8 - Parameter Queries

  • Building a multi-table query
  • Creating parameter queries
  • Changing the parameters in Excel
  • Table filter properties

Book now

Select your preferred training centre:
include all training centres
select specific centres from this list:
Birmingham
Bristol
Croydon
Glasgow
Leeds
Manchester
N.London
Newcastle
Reading

Search for Sage training courses
Make big savings on the RRP by booking your Sage training with Advantage Services

If you are planning on booking several days of training, do contact us for even better discounts. Save hundreds off the RRP with us!

Course Centre Start date Duration Total places Available places Book
Link Sage 50 Accs - MS OfficeN.London06/02/20121 day125
Link Sage 50 Accs - MS OfficeBristol10/02/20121 day106
Link Sage 50 Accs - MS OfficeBirmingham29/02/20121 day129
Link Sage 50 Accs - MS OfficeN.London01/03/20121 day128

Linking Sage 50 Accounts with Microsoft Office is a one-day course. Our price is £195.00 (Sage's RRP is £270.00).

You can book your course in several ways:

  • Online: Just click the "Book now" button (your payment will only be processed after we have booked your course with Sage).
  • Phone: Just call 0845 009 6566 to pay by card or arrange BACS or cheque payments.
  • Use the contact form: Click here and fill out the contact form.
See all courses on the Sage training home page. You can always contact a Sage training advisor on 0845 009 6566 or by email.

Important notes about booking your Sage classroom training course


  • When booking a course online, if the course is not for the paying cardholder, please enter the name it should be booked for in the notes section when paying.
  • If a vegetarian meal is required instead of the standard meal provided, please enter this in the notes section as well.
  • If a course is showing no availability it is still worth contacting us as there maybe cancellations or the possibility of switching the course to a bigger room.
  • Also note that the number of available places given is updated regularly, but it is not live, so it's always best to ask us for the latest availability if the number of available places is running low.
  • *for all courses except Instant Accounts, which is £215 and Payroll Year End, which is £190.


Other relevant links



   © Advantage Services (Europe) Limited 2012 About us  |  Contact us  |  Terms and conditions  |  Privacy policy  |  Site map