HomeLinking Sage 50 Accounts with Microsoft Office training course
Linking Sage 50 Accounts with Microsoft Office is a one-day course. Our price is £149.00 (Sage's RRP is £270.00).
» Overview: Create professional documentation, dynamically linked to your live Sage Accounts data.
» What do I learn?
See 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
- Data for the ODBC driver
- Finding the data path
- Setting up the DSN
- Upgrading Sage 50 Accounts
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
Session 3 - Using Expressions
- Using Expressions to Perform a Calculation
- Using Multiple Expressions
- Formatting cells in Excel
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
Session 5 - Using Multiple Tables
- Creating the query with multiple tables
- Joining Tables
- Viewing Joins
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
Session 7 - Using Pivot Tables and Charts
- Creating a query
- Creating the PivotTable
- Creating the Pivot Table
Session 8 - Parameter Queries
- Building a multi-table query
- Creating parameter queries
- Changing the parameters in Excel
- Table filter properties
Book now
| Course | Centre | Start date |
Duration | Total places | Available places | Book |
| Link Sage 50 Accs - MS Office | Bristol | 10/02/2012 | 1 day | 10 | 5 | |
| Link Sage 50 Accs - MS Office | Birmingham | 29/02/2012 | 1 day | 12 | 9 | |
| Link Sage 50 Accs - MS Office | N.London | 01/03/2012 | 1 day | 12 | 8 | |
| Link Sage 50 Accs - MS Office | Birmingham | 05/04/2012 | 1 day | 12 | 12 | |
| Link Sage 50 Accs - MS Office | Glasgow | 13/04/2012 | 1 day | 12 | 12 | |
| Link Sage 50 Accs - MS Office | Manchester | 17/04/2012 | 1 day | 12 | 11 | |
| Link Sage 50 Accs - MS Office | Croydon | 30/04/2012 | 1 day | 12 | 12 | |
| Link Sage 50 Accs - MS Office | N.London | 30/04/2012 | 1 day | 12 | 12 |
Linking Sage 50 Accounts with Microsoft Office is a one-day course. Our price is £149.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 3990 to pay by card or arrange BACS or cheque payments.
- Use the contact form: Click here and fill out the contact form.
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
- Sage 50 Accounts training menu
- Sage 50 Accounts Report Designer (2 days)
- Microsoft Excel - Stage 1 (1 day)
- Microsoft Excel - Stage 2 (1 day)
- Sage 50 Accounts essentials course(1 day)
- Sage 50 Accounts stage 1 (2 days)
- Sage 50 Accounts stage 2 (2 days)
