Training Courses

Click on the course for a brief description.

If you would like to attend one of these courses then please e-mail: clare.reynolds@action-file.co.uk or call her direct on 01295 222670.


Date Course Cost
Thur 01/05/11 HR Report Writer £150
Thur 08/05/11 HR Refresher £150
Thur 15/05/11 Payroll ODBC £150
Thur 22/05/11 Payroll Refresher £150
Thur 05/06/11 Advanced Excel £150
Thur 12/06/11 HR Report Writer £150
Thur 19/06/11 HR Refresher £150
Thur 10/07/11 Payroll ODBC £150
Thur 17/07/11 Payroll Refresher £150
Thur 24/07/11 Advanced Excel £150
     
Course costs are per person. All courses are held at our Banbury Office for directions click here.
 


Payroll Refresher Course Includes:

System Parameters
Company Reference Data
Payroll parameters
Review of current system set up
Employee Defaults
Tricks 'n' tips
Advanced Software Features
AEO's
Supplementary Payruns
User Defined Reports
Pay Input Screen
Bulk Updates


Back to top


ODBC Course Includes:

Introduction to ODBC Table Structure
Linking History Tables
Design Reports with Excel
Mail Merge with Word
General Reporting assistance as required


Back to top


HR Report Writer Course Includes:

Introduction to Access Table Structure
Linking Queries
Design Reports with Access
Mail Merge with Word
General Reporting assistance as required


Back to top


HR Refresher Course Includes:

System Parameters
Company Reference Data
HR parameters
Review of current system set up
Employee Defaults
Tricks 'n' tips
Advanced Software Features
Standard Reports
Employee Input Screen
Updates
Introduction to Access Report Writer


Back to top


Advanced Excel

Number formatting
Dates and times
Conditional formatting
Styles and themes
Validation and protection
Range names and absolute references
Multiple worksheets
IF and LOOKUP functions
Linking to other data
Tables
Pivot tables
Charts
Consolidation
Recording Macros
Tips and Tricks
Customising Excel
List Management
Common Functions and Formulas

 

Back to top










 

Addone IT Services Investors in PeopleHM Revenue and CustomsBACS Microsoft Certified