| Appraisal Skills |
| Assertiveness for Managers |
| Basic Employment Law |
| Change Management |
| Coaching for Performance |
| Equality and Diversity |
| Facilitating Effective Meetings |
| Finance for Non-Financial Managers |
| Recruitment and Selection |
| Stress Management |
| Supervisory Management |
| The Middle Managers Toolkit |
| Time Management for Managers |
| Access |
| AutoCAD Intermediate |
| AutoCAD Introduction |
| Crystal Reports |
| Excel |
| Lotus Notes |
| Microsoft Office Upgrade Courses |
| Outlook Advanced |
| Outlook Introduction |
| PC Awareness - Level 1 |
| PC Awareness - Level 2 |
| Powerpoint |
| Project Advanced |
| Project Introduction |
| Publisher |
| Sageline Accounts |
| Sageline Payroll |
| SharePoint Administration |
| Sharepoint End-User |
| VBA |
| Visio Advanced |
| Visio Introduction |
| Word |
| A+ |
| Active Directory |
| Configuring Windows Server 2008 Active Directory |
| Exchange 2000/2003 Administration |
| Exchange 2007 |
| Exchange 2010 |
| Introduction to PC Technology |
| MCDST |
| Microsoft Exchange Server 2010 |
| Network + |
| Oracle Database 10g: Administration |
| SQL 2005 |
| SQL 2008 |
| TCP/IP |
| Windows 7 |
| Windows 7 Enterprise Desktop Support Technician |
| Windows Desktop Support Skills |
| Windows SBS |
| Windows Server 2003 MCP |
| Windows Server 2008 Administration |
| Windows Server 2008 New Features |
| WLAN Networking |
| ITIL® Foundation V3 |
| PRINCE2® Combined Foundation and Practitioner |
| PRINCE2® Foundation |
| PRINCE2® Overview |
| PRINCE2® to Practical |
| Advanced Presentation Skills |
| Assertiveness |
| Business & Letter Writing |
| Cold Calling |
| Communication Skills |
| Creating Sales People that Sell! |
| Customer Care |
| Dealing with Aggressive Callers |
| Introduction to Marketing |
| Managing the Anger Habit |
| Minutes & Note-Taking |
| NLP |
| Participating Effectively in Meetings |
| Persuasive Selling |
| Presentation Skills |
| Presentation Skills for Sales People |
| Report Writing |
| Sales Skills and Strategy |
| Telephone Techniques |
| The Effective Receptionist |
| The Executive Secretary |
| The Training Administrator |
| Time Management |
| Train the Trainer |
| Requirements for Electrical Installations 3-days |
| Requirements for Electrical Installations 5-days |
| Working at Height |
Crystal Reports
Duration 2 daysCourse Content
Overview
What is Crystal Reports
Preview sample reports
Preview sample databases
The Crystal Report window
Using help
Creating Basic Reports
Creating a new report
Inserting database fields
Previewing a report
Selecting multiple objects
Moving and resizing objects
Inserting text objects
Formatting objects
Saving a report
Saved data vs. refresh data
Sorting, Grouping and Summarizing
Sorting records
Inserting groups
Group Name field
Changing group options
Creating specified groups
Inserting subtotals
Inserting grand totals
Inserting summary fields
Top N group expert
Record Selection
Selection records
Multiple selection criteria
Editing the record selection formula
Creating Formulas
Why use formulas
Formula components
Using the Formula Editor
Editing a formula
Renaming a formula
Deleting a formula
String functions
Date Functions
Formulas using summary fields
If-Then-Else formulas
Linking
What is linking?
Join types
Self joins
PC database links
SQL/ODBC database links
Using the visual linking expert
Using the Report Expert
Creating a report using the Report Expert
Edit report using the Report Expert
Section Formatting
Report section definitions
Using the Section Expert
Section format options
Summary/Drill-Down Reports
Basic Cross-Tabs
What is a Cross-Tab?
Using the Cross-Tab Expert
Editing a Cross-Tab layout
Additional Cross-Tab layout features
Report Distribution
Exporting a report to another format
Mailing a report
Compiling a report
Additional Formatting & File Options
Inserting special fields
Inserting fields in text objects
Moving and copying objects
Inserting lines and boxes
Inserting pictures
Changing file options
Excel Intermediate
Very knowledgeable, not stumped by any questions and flexible to diverge
Very knowledgeable, not stumped by any questions and flexible to diverge
Cory Bros
Excel Introduction
Created friendly working atmosphere, very knowledgeable
Created friendly working atmosphere, very knowledgeable
Billericay Dental
Microsoft Office 2007 Upgrade
All round excellence
All round excellence
Barker Gotelee
Bespoke Word and Excel Combined Course
Excellent, we got through everything that I particularly needed to know about, very well planned and executed tuition
Excellent, we got through everything that I particularly needed to know about, very well planned and executed tuition
Coping with Breast Cancer
Sage Line 50 Accounts
Very good. Worked closely with me so that I gained all the knowledge I needed from the course.
Very good. Worked closely with me so that I gained all the knowledge I needed from the course.
Bethesda Eventide Homes
Access 2003
Ivan (the trainer) showed great ability to deal with a wide range of queries and always did the little bit extra to make sure we learnt all we needed to.
Ivan (the trainer) showed great ability to deal with a wide range of queries and always did the little bit extra to make sure we learnt all we needed to.
British Energy