Sage Training Courses at Official Sage Training Centres throughout the UK

Sage Software Online | Sage Training Courses | Other Sage Courses

	Linking Sage 50 to MS Office - Normal Price £260 - Our Price £109 This course explains everything you need to know transfer data from Sage Line 50 to a Microsoft program such as Word or Excel. Creating charts and graphs and running mail merges are some of the key topics covered. Who Should Attend This course is suitable for existing users of Sage Line 50 ho regularly transfer data from Sage Line 50 into a Microsoft program. Course Content Introduction to the ODBC (Open DataBase Connectivity) driver Setting up multiple DSNs (Data Source Names) Navigating around the menu options available in MS Query Updating the live link between the query and Sage Line 50 using the refresh option Adding both single and multiple calculations to a query, then returning the data to Microsoft Excel and formatting the cells Running a mail merge within Microsoft Word to link the data in Sage Line 50 to a Word document Creating labelled envelopes from the names and addresses in Sage Line 50 Using the If…Then…Else statement within Microsoft Word Using multiple tables within Microsoft Excel and joining the tables together Using the cycle through totals option is MS Query Creating graphs in Microsoft Excel based on data from Sage Line 50 and creating a live link to Microsoft PowerPoint Creating pivot tables and charts in Microsoft Excel to dynamically interrogate the Sage Line 50 data Add criteria to select specific data from Sage Line 50 Set up parameter queries to enable specific ranges to be entered when requesting data from Sage Line 50 Official Sage Classroom training is held at Sage Training Centres throughout the UK. Click here to find your nearest venue. Price: £109.00 (Excluding: VAT at 17.5%)


	Introduction to Sage Bookkeeping - Normal Price £260 - Our Price £109 This course explains everything you need to know about basic double-entry bookkeeping. Debits and credits, the Nominal Ledger and the Trial Balance are some of the key topics covered.!!> Who Should Attend This course is suitable for any individual that requires an understanding of double-entry bookkeeping. Identify the differences between debits and credits and learn basic double entry. Course Content Discover the reasons for nominal ledger analysis Learn how to create a Trial Balance Understanding banking using double entry How to record VAT using double entry bookkeeping Understanding debtors and creditors control How to operate a sales ledger that links to the nominal ledger How to operate a purchase ledger that links to the nominal ledger Overview of computerised accounts and their benefits Official Sage Classroom training is held at Sage Training Centres throughout the UK. Click here to find your nearest venue. Price: £109.00 (Excluding: VAT at 17.5%)

Sage Software Online | Sage Training Courses | Other Sage Courses

T 0870 787 1451 - F 0870 787 1452 - E sales@ncsgroup.co.uk -

All training offers apply to businesses within mainland U.K. only.