Linking Sage 50 Accounts to Microsoft® Ofice* Classroom Training 1 Day Course £280 + VATWhat do I learn?Learn everything you need to know about how Microsoft® Ofice 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 Open DataBase Connectivity (ODBC) 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 Accounts14*Microsoft Office 2003

Find out more. Call 0800 33 66 33 or visit www.sage.co.uk/trainingSage 50 Accounts Project Costing Classroom Training 1 Day Course £280 + VATWhat do I learn?Take a comprehensive look at the project lifecycle including costs, budgeting, resources, charges and billing.By the end of this course you will:. Be familiar with Project Costing and understand how to configure the module. Be able to set up Cost Types and Cost Codes. Know how to create and enter Project Records and Sub-Projects. Understand how to assign invoices and bank payments to projects. Be able to record committed costs. Understand the concept and use of resources, project charges and credits. Be familiar with project reporting, activity and on screen enquiries. Understand Billing and Project closure"This course satisfied my training requirements and gave me an appetite to sign up for another one."Stuart BratchellAudio Visual Unit Ltd15Other options availablePrivate and Onsite Training