IT Services
IT Training Courses
These courses are developed to support beginners, intermediate and advanced learners. Open courses run with a
minimum of four delegates. In-house training group sizes should preferably not be more than 8 delegates (but we are flexible!).
Before a course runs, delegates will be asked to complete a questionnaire and indicate areas that they need to
improve skills in; courses will be developed to suit the needs of the delegates. Contact us to discuss your needs.
We use a number of superbly-equipped training centres in the Portsmouth area, selected for their facilities, ease of access and pleasantness of environment.
On full-day courses lunches are provided and refreshments are always included.
Click on any of the course titles below to see more details. For additional dates, see our Long-term Programme (pdf).
For costs and courses running in the next few months, look at our short-term programme with prices(pdf).
Thurs 1st April 2010 - Portsmouth
Get to the next level with topic-based modules that can cover:
- Customisation of the Excel working environment
- How Names can transform your use of Excel
- Data normalisation
- Data Sorting and Filtering
- Using Pivot Tables
- Using Advanced Formulae
- How to make the best use of Charts
...and much more. Discuss your requirements with us and we will work out a programme to fill the gaps in your Excel knowledge.
Book now for April or register interest
Close
Tues 6th April 2010 - Portsmouth
This full-day introductory course is for those users of the Microsoft Office suite of programs who wish to leverage
their knowledge of the applications by learning how to automate repetitive tasks, or add functionality appropriate to
their business needs. The main focus will be directed towards the Excel object model.
Book now April or register interest
Close
Weds 7th April 2010 - Portsmouth
This full-day advanced course builds on the knowledge covered in the introductory sessions. The tutor will cover forms, events, arrays, collections, references, dealing with files, and creating add-ins.
The afternoon session can be dedicated to developing possible approaches to a particular business requirement if requested.
Book now for April or register interest
Close
Weds 14th April 2010 - Portsmouth
Move to the next level in Word. Topic-based modules that can cover:
- Proper use of Styles
- Outlining and numbering
- Getting the most out of Auto-correct
- Mastering Tables
- Importing and placing objects, files and pictures
- Developing templates to match a 'House Style'
- Mail-merge - working with external data
...and much more. Discuss your requirements with us and we will work out a programme that suits you.
Book now for April or register interest
Close
Thurs 22nd April 2010 - Portsmouth
This full-day introductory course is for those users of the Microsoft Office suite of programs who wish to add a working knowledge of the Access Database application for handling larger datasets. The main focus will be directed towards
understanding the power of the software. Learn about tables, fields, datasets, queries, the dashboard, reports and how to manipulate the data within an existing database.
Book now for April or register interest
Close
(beginners or intermediate levels)
Tues 27th April 2010
Part of the Creative Suite, InDesign is the world-leading print and media publication design tool from Adobe.
Book now for April or register interest
Close
A half-day beginners' course to get you started
Tues 4th May 2010 - Portsmouth
- Uses of Excel
- The Excel window: grid, menus and toolbars; formula, status and name bars
- Navigation; short-cut keys
- Entering data: text, numbers and formulae
- Formatting: fonts, colours, borders, patterns, numbers, dates
- Cut, copy and paste; autofill
- Column and row manipulations; freeze panes, split windows
- References, ranges
- Page setup, print preview and printing
- Basic formula operations; autosum
- Filtering, sorting, finding data
- Linking; absolute and relative references
...and much more. Discuss your requirements with us and we will work out a suitable programme for you.
Book now May or register interest
Close
(beginners, intermediate or advanced levels)
Thurs 6th May 2010 - Portsmouth
Purpose:
To enable you to carry out routine procedures using Sage Accounts Software
Objectives:
At the end of the training, clients will be able to:
- Create Customer Invoices & update the Sales Ledger using the quickest methods
- Process Purchases & Expenses and account for VAT
- Reconcile Bank, Credit Card & Cash Accounts
- Enter Nominal Journals for Wages & recurring Bank Payments
- Produce Management Accounts for a sample month, including Budget comparisons
- Finalise VAT Return
Particular attention will be paid to the use of shortcuts and the memory facilities within the programme to minimise
the time taken to carry out the daily posting routine.
Book now for May or register interest
Close
Weds 12th May 2010 - Portsmouth
Get to grips with the fundamentals in Word.
Discuss your requirements with us and we will work out a programme to fill the gaps in your Word knowledge.
Book now for May or register interest
Close
Thurs 13th May 2010 - Portsmouth
This full-day intermediate course is for those users of Microsoft Access who wish to move on to the next level and start building their own databases. Build table relationships,
parameterised queries, and design your own reports. Learn how to interface with other sources of data. get introduced to Visual Basic and basic programming.
Book now for May or register interest
Close
Weds 19th May 2010 - Portsmouth
This full-day advanced course is for experienced users of Microsoft Access who wish to move on as database application developers. Visual Basic for Applications
will be extensively explored to push back the boundaries of your knowledge. Skills gained in the prior courses will be polished enabling you to move towards building a professional-looking and secure business application.
Book now for May or register interest
Close
Remember - this is just a small subset of the training courses our specialist IT Trainers can provide. If there is IT training not listed here that
you need individually or as a company contact us to discuss your needs.
Top
