These courses are designed for people who use Excel in their work but want to save time by learning how to use it properly.

 

You can book these courses separately or together depending on your individual requirements.

 

 

Excel 2007 Bite-Size Training, 1/2 Day Classroom Training


Stage 1: 

Sending Basic Information from Sage to Excel

Setting up links to Company Data in Sage Integrated Reporting

Copying Standard Reports enabling use in Sage Integrated Reporting

Modifying Existing Reports

Setting up ODBC Links to Sage

Using Microsoft Query
-          Selecting fields
-          Using Criteria
-          Sub Totals in a query
-          Joining multiple tables

This course costs £100 and you will receive your own PC, training manual and refreshments.



Stage 2: 

Amending Data Range Properties

Amending Parameters and Run Time Options

Using filters on Returned Data Tables

Generating Subtotals

Functions to use with Data Tables
-          Dsum
-          Vlookup
-          Hlookup

Generating and using Pivot Tables

This course costs £100 and you will receive your won PC, training manual and refreshments.  All prices exclude VAT



For further details, please don’t hesitate to call us: 020 7831 3050, or email us Anne-Marie@centrepointsoftware.co.uk

For availability, click here