Sage Excel Integration & links to Microsoft Office - online course
Do you want to learn how to link Sage to Excel, Word or Access? We can offer an online course that is tailored to suit your needs. We can design any reports required as part of the training. We can either offer courses at your premises on a one-to-one basis using your data or online and they can be tailored as follows:
- We will use a copy of your Sage data for the training so that you get the best of out it
- We can produce reports that are required as part of the training
- For online courses, we recommend they are split into two hour sessions
Sage Excel Integrated Reporting (EIR) & Links to Microsoft Office Course
This course explores how to use the Sage Excel link to Sage 50 or Sage Payroll. It also covers the ODBC link which can be used to link to Access or Word. It explains features of the Microsoft Office products that can be used to manipulate the Sage data but could also be used to manipulate any other database information.
Overview
Sage Excel Integrated Reporting
Tables & Variables
ODBC Setup and using Microsoft Query
Links to Microsoft Word
Form Letters
Labels
Lists
Links to Excel
Sage Add-In Excel Integrated Reporting
Sage Functions
Filtering
Subtotalling
Pivot Tables
Linking raw data sheets
Linking to Access
Querying in Access
Creating Reports using the Wizard
This course explores how to use the Sage Excel link to Sage 50 or Sage Payroll. It also covers the ODBC link which can be used to link to Access or Word. It explains features of the Microsoft Office products that can be used to manipulate the Sage data but could also be used to manipulate any other database information.
Overview
Sage Excel Integrated Reporting
Tables & Variables
ODBC Setup and using Microsoft Query
Links to Microsoft Word
Form Letters
Labels
Lists
Links to Excel
Sage Add-In Excel Integrated Reporting
Sage Functions
Filtering
Subtotalling
Pivot Tables
Linking raw data sheets
Linking to Access
Querying in Access
Creating Reports using the Wizard
Just a short note to thank you. I have to say I found the whole training very useful and the end result was that I got a lot out of that I can put them into practice immediately. I thank you for that. I feel more confident about Report designing now. It obviously requires sitting down and designing reports to solidify what you thought me.
Byzantium Collection Ltd (Jewellers)
Sage Report Designer course - London
We contacted Jape Consulting for Sage training and were very pleased with the training received. The sessions were tailored to the needs of our business and completely relevant to our day to day work. The trainer was professional and knowledgeable but the sessions were informal and provided a really good basis for enjoyable learning. I would have no hesitation in recommending Jape Consulting.
Chemflow UK (Water treatment company)
Sage Training - Byfleet, Surrey
Learn how to use the Sage 50 or Sage 200 Report Designer? Call us today
We have provided Sage consultancy and training for small to medium businesses since 2002. We are based in Enfield, North London, UK but will travel to London, Hertfordshire, Middlesex, Essex, Norfolk, Suffolk, Kent, Surrey and around the M25 or online!