If you would like to create and automate Management Reports, from your Sage 50 Accounts data, this course is for you. Learn how to create a live data link between Sage 50 Accounts and Microsoft Excel.
This Central London Sage 50 Accounts training course, may contribute to ACCA members' Continuing Professional Development requirements.
Sage 50 Accounts Reporting with Microsoft Excel - 1 Day training Course
Course objectives:
How to use Sage 50 Accounts Integrated Reporting
Create a live link from Sage 50 Accounts to Excel
Query your accounts data
Demystify powerful Excel commands such as; Pivot Tables, SumIF, DSum, vLookup, hLookup and Concatenate
Sage Integrated Reporting
Run reports into Excel from Sage
Adding Reports from Sage into Excel
Modifying existing reports
Live link between Excel and Sage 50 Accounts data
Setting up ODBC to link Excel to Sage Data
Using Microsoft Query
Amending Data range properties
Using Filters on returned data tables
Functions to use with data tables, such as SumIF, DSum, vLookup, hLookup, Concatenate.
For further details, please don't hesitate to call or email us.
This course costs £245 and you will receive your own PC, training manual, refreshments and a light lunch.
If you have a colleague that would like to attend, then they may share your PC for an additional £100. All prices exclude VAT.