Sage Software, Stationery & Training

Northern Computer Services (Manchester) Limited
Falcon Business Centre, Victoria Street,
Chadderton, Oldham, OL9 0HB

T 0844 824 3478
F 0844 824 3479
E sales@ncsgroup.co.uk
W www.ncsgroup.co.uk

 
[ Up ] [ Top ] [ Terms & Conditions ] [ Search ] [ View Basket ] [ Process Order ] [ Contact Us ] [ Login ]  


 


Sage Stationery
Sage Training Courses
Sage Software & Training Bundle Deals
Sage Software
Sage Additions Software



Sage Software Online > Sage Training Courses > Other Sage Courses

Linking Sage 50 to MS Office - Normal Price £260 - Our Price £139 Linking Sage 50 to MS Office - Normal Price £260 - Our Price £139

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:   £139.00 (Excluding: VAT at 17.5%)



Introduction to Sage Bookkeeping - Normal Price £260 - Our Price £139 Introduction to Sage Bookkeeping - Normal Price £260 - Our Price £139
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:   £139.00 (Excluding: VAT at 17.5%)


Sage Software Online > Sage Training Courses > Other Sage Courses