"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

  Sage 50 Accounts And Microsoft Office. Duration: 1 Day

Course Overview

Create professional documentation, dynamically linked to your live Sage Accounts data. Training is delivered at the client site What do I learn? Learn everything you need to know about 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.


Linking Sage 50 Accounts to Excel and Word

Data for the ODBC driver

Finding the data path

Setting up the DSN

Upgrading Sage 50 Accounts

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

Sage 50 Accounts further Excel and Word

Using Expressions to Perform a Calculation

Using Multiple Expressions

Formatting cells in Excel

Sage 50 Accounts Linking to Word

Building the query and applying criteria

Building the mail merge document

Microsoft Word rules

Creating a mail merge from Sage 50 Accounts

Using Multiple Tables

Creating the query with multiple tables

Joining Tables

Viewing Joins

Totalling Data and Graphs

Custom fields in Sage 50 Accounts

Cycle through totals

Linking to Microsoft PowerPoint

Cycle through totals on an expression

Using Pivot Tables and Charts

Creating a query

Creating the PivotTable

Creating the Pivot Table

Parameter Queries

Building a multi-table query

Creating parameter queries

Changing the parameters in Excel

Table filter properties