Course |
|
Description |
| WORD
Introduction
Dates:
19 Mar 09
08 May 09
26 Jun 09
Time:
9:30am - 4:30pm
Fee:
£100 + VAT
|
|
A one day introduction to the basic principles of computers, Windows & Word.
- What is Windows
- PC components
- Information networks
- Creating, moving and copying folders
- Starting and exiting programs and finding files
- Using Word to enter, delete, edit and format text
- Using tabs and tables, spelling and printing
By the end of the course participants will feel confident to move on to the more challenging aspects of Microsoft software packages.
Return to Top
|
WORD
Intermediate
Dates:
06 Mar 09
22 May 09
12 Jun 09
Time:
9:30am - 4:30pm
Fee:
£120 + VAT
|
|
A one day course that introduces how to use Word to create documents that look professional and are easy to edit.
- Page margins
- Tabs and leader tabs
- Using tables to enhance page layout
- Paragraph bullets and numbering
- Paragraph formatting
- Page breaks and section breaks
- Using heading levels
By the end of the course delegates will be aware of the tools that are available to enable consistent formatting, tabulation and management of long documents.
Return to Top |
POWERPOINT
Introduction
Dates:
19 Jun 09
Time:
9:30am - 4:30pm
Fee:
£100 + VAT
|
|
A one day introduction to creating PowerPoint presentations.
- Creating slides
- Using text, graphics and pictures
- Organisation flowchart
- Autoshapes and flowchart tools
- Object alignment and groupings
- Slide transition
- Object animation
- Formatting slide backgrounds
By the end of the course participants will be able to create a professional and original presentation that fully utilises the functionality of PowerPoint.
Return to Top |
ADVANCING WITH POWERPOINT
Dates:
09 Mar 09
Time:
9:30am - 4:30pm
Fee:
£110 + VAT
|
|
A one day course using the advanced features of PowerPoint to create professional and interactive presentations.
- Using the slide master
- Adding media enhancements
- Creating a menu system
- Saving presentation for the web
- Using advanced hyperlinks and web functionality
- Setting up an LCD projector and laptop
Also available as one-to-one training for £150 + VAT for a half day.
Return to Top |
ACCESS
Introduction
Dates:
03 Apr 09
05 Jun 09
Time:
9:30am - 4:30pm
Fee:
£100 + VAT
|
|
A one day introduction course to the principles of databases using Microsoft Access.
- Database design
- Creating queries
- Creating reports
- Creating tables
- Creating forms
- Printing
- Simple calculations
- Sort and filter
By the end of the course delegates will be able to produce a basic database that will enable further growth and development.
Also available as one-to-one training for £150 + VAT for half a day.
Return to Top |
ACCESS
Intermediate
Dates:
13 Mar 09
03 July 09
Time:
9:30am - 4:30pm
Fee:
£120 + VAT
|
|
A one day course that builds on the Introductory course and focuses on complex formulae in "Queries", "Forms" and "Reports".
- Simple formulae
- Using expression builder
- Using expression builder to create functions
- Aggregate queries
- Crosstab queries
- Update queries
- Make table queries
By the end of the course delegates will be able to use the features contained within Access to carry out complex data analysis.
Return to Top |
ACCESS
Calculations
Dates:
Courses can be arranged for small groups or on a
one-to-one basis
Time:
9:30am - 4:30pm
Fee:
£120 + VAT
|
|
A one day course that introduces the use of basic and complex calculations using Access. Delegates will learn how to create derived data using functions and calculations that provide:
- Basic arithmetic
- Aggregate queries
- Crosstab queries
- Logical functions
- Data functions
- Text functions
- Lookup tables
Also available as one-to-one training for £150 + VAT for half a day.
Return to Top |
EXCEL
Introduction
Dates:
24 Apr 09
11 Jun 09
Time:
9:30am - 4:30pm
Fee:
£100 + VAT
|
|
A one day introduction course to using Excel to build spreadsheets as calculation tools and databases.
- Entering text, numbers and dates
- Formulae
- Absolute and relative cell references
- Sort and filter
- Basic functions
- Graphs
- Formatting text and numbers
- Printing
By the end of the course delegates will be able to produce a functional and professional spreadsheet that is fully automated to provide data analysis.
Return to Top |
EXCEL
Intermediate
Dates:
27 Feb 09
20 Mar 09
15 May 09
06 July 09
Time:
9:30am - 4:30pm
Fee:
£120 + VAT
|
|
A one day course that builds on topics covered in the introductory course. Participants will learn how to control user input and make the spreadsheet more powerful through the use of functions and data analysis tools.
- Management tools
- Conditional formatting
- Controlling input
- Functions and nested functions
- Linking e-worksheets
- Pivot tables
- Subtotals
- Goal seek
- Scenarios
By the end of the course delegates will be able to produce a functional and professional spreadsheet that is fully automated to provide data analysis.
Return to Top |
EXCEL
Statistical Analysis
Dates:
Courses can be arranged for small groups or on a
one-to-one basis.
Time:
9:30am - 4:30pm
Fee:
£110 + VAT
|
|
A one day course that concentrates on using the statistical tools available within Excel. Rather than use specialist software it is possible to create spreadsheets to collect, process and display complex data.
- Setting up data collection sheets
- Statistical functions
- Data analysis tools
- Using graphs to display data
By the end of the course delegates will be able to design a spreadsheet to collect, process and display complex data.
Return to Top |
| SPREADSHEET DEVELOPMENT |
|
In order to harness the power of Excel sometimes a high level of training is required. Quest can offer a more cost effective method for "one-off" projects. Quest will design the application to meet your requirements, providing an efficient and easy to use solution.
Quest can train end users to ensure perceived benefits are delivered both in terms of day-to-day administration and data analysis.
Please call Mike Fitzpatrick to discuss your requirements.
Return to Top |
WEB DESIGN
Introduction
Dates:
Courses can be arranged for small groups or on a
one-to-one basis
Time:
9:30am - 4:30pm
Fee:
£120 + VAT
|
|
A one day introduction to the basic features of website design using HTML and JavaScript. The course will include:
- Using the HTML (Hyper Text Mark-up Language) coding language
- Using Dreamweaver web design software
- Creating forms to collect user input
- Uploading web pages using FTP (File Transfer Protocol)
BY the end of the course delegates will be able to create a basic website using HTML, Microsoft Office and Javascript.
Return to Top |
WEB DESIGN
Databases
Dates:
Courses can be arranged for small groups or on a
one-to-one basis
Time:
9:30am - 4:30pm
Fee:
£150 + VAT
|
|
A one day course demonstrating how PHP and MySQL work together. Using Dreamweaver and PHP-Dev you will learn how to build a simple web database and then use PHP function with your database.
- What is PHP
- Data flow
- Embedding PHP with HTML
- Variables and Operators
- Introduction Conditionals
- Sending and receiving data
Return to Top |
FLASH
Web Animation Software
Dates:
Courses can be arranged for small groups or on a
one-to-one basis
Time:
9:30am - 4:30pm
Fee:
£125 + VAT
|
|
A one day introduction to Flash. You will learn how to design and deliver distinctive animated graphics using Macromedia Flash software.
- Understanding the Flash framework
- Drawing and painting tools
- Working with text
- Using timelines
- Animating in Flash
- Controlling movie clips
By the end of the course participants will be able to create movies that add interactivity and originality to web pages.
Return to Top |
PHOTOSHOP
Introduction
Dates:
Courses can be arranged for small groups or on a
one-to-one basis
|
