|
Training
Services
We offer a comprehensive range of training,
from basic through advanced level, to individual
customised personal training programs. This
page gives an overview of standard training,
but many other applications can be catered for
on request. Please note that all training should
be prefaced by a full Training
Needs Analysis to ensure a good match between
skills and needs.
All training is carried out in a 'hands-on'
style, and concentrates on completing exercises
designed to demonstrate specific functions and
skills. All sample files are presented in 'before
and after' versions so that progress can be
checked against the ideal solution.
Each training course is available in pdf format,
with all supporting files, and may be purchased
as is, or customised to your specific requirements.
The courses may also be delivered by one of
our instructors on-site at your location.
Microsoft Windows
The user interface of Windows is very richly
featured and also quite confusing to the new
user. For new users, this course covers the
basic topics to enable efficient use of this
operating system.
- Introduction to the components of a computer
- processor, memory, disks, i/o devices, keyboard,
mouse, start-up and shutdown
- The windows user interface - Window layout,
control menus, TaskBar and Start menus
- Desktop components- Recycle Bin, Network
Neighbourhood, My Computer, Control Panel
- The Windows Help system
- Windows Explorer - hard disk organisation,
folder structure, managing files and folders,
running drive diagnostics
- Finding files and folders
- Using the Network - using network drives,
printers and applications
- Customising Windows - the Desktop, the Start
Menu, display options
Microsoft Word
Microsoft Word is capable of almost any type
of text manipulation from a simple memo to a
graphic layout that approaches the complexity
which would have formerly needed a separate
Desktop Publishing Package.
Fundamentals
- Introduction - screen, menus and help System
- Creating documents - inserting text, saving,
printing
- Editing - text selection, find and replace,
simple formatting
- Page and paragraph layout - margins, page
numbers, indents, tabs, fonts and character
effects, creating and applying styles
- Document views - normal, print, web and
outline views
- Headers and Footers
- Creating and drawing tables
- Mail merge to labels and standard letters
- Spelling and Grammar checking
- Customising Word
Advanced
- Top-down document formatting - rulers, gutter
and mirror margins, page and section breaks,
header and footer control
- Paragraph format - text alignment, line
spacing, text flow, borders and shading, bullets,
numbers and outlines
- Styles - built in, user defined, modifying,
attaching to global template
- font decoration - colour, special effects,
spacing, position, kerning, highlighting,
AutoFormat and AutoText entries
- Advanced table design, manipulating columns
and rows, table, cell and text alignment,
freehand tables, inserting Excel worksheets
- Text columns
- Inserting graphics - flowing text round
pictures, text boxes and AutoShapes
- Creating forms and saving form data
- Advanced mail merge, using word, Outlook
and Excel
- Simple VBA macros
- Creating and editing Normal, Global and
Document templates
- Managing large documents with Master and
Sub documents
- Footnotes, Endnotes, Bookmarks, cross references,
table of contents, table of figures and table
of authority
Microsoft Excel
Excel is one of the most commonly used applications
and is capable of a wide range of functions
other than simple manipulation of rows and columns
of figures.
There are three courses available, from basics
to using Visual Basic macros.
Fundamentals
- Introduction - screen, menus, worksheets
and cells, toolbars
- Creating a worksheet - entering text and
numbers, AutoComplete and AutoCorrect,fonts,
copying cells, entering formulae, editing
and aligning cells, printing, saving and closing
- Editing worksheets - date formats, borders
and patterns, styles, cell references, using
functions and names
- More editing - rounding numbers, correcting
formulae errors, inserting rows and columns,
AutoFormat, managing files and folders
- Using Excel Charts - chart components, embedded
charts, chart menus and toolbars, the chart
library
- Printing charts and worksheets - headers
and footers, page breaks and the print area
- Manipulating worksheets - AutoFill, the
Format Painter, moving formulas, sorting,
splitting, freezing and zooming worksheets
- Multiple workbooks - inserting and deleting
worksheets, copying between workbooks, group
editing
Advanced
- Complex worksheets - absolute and relative
references, cell names, array formula, custom
number formats, styles, special text effects
- Viewing and outlining - hiding rows and
columns , using views and reports
- Manipulating Charts - chart types, moving
and sizing, adding chart items, changing axes,
changing values, plot order, adding data series
to a chart
- Chart formats - AutoFormat, multiple chart
types and axes, formatting chart items
- Analysing data - forecasts and trends, pivot
tables and pivot charts
- Problem solving - scenarios and data tables
- Simple excel macros
- Creating and using forms
- Worksheet consolidation - 3-D formulas,
external references, linking consolidated
worksheets
- Data handling - creating a data list, looking
up values, sorting and filtering, data validation
and tracking
- Workbook, worksheet and cell security
- Sharing workbooks on the web
- Customising Excel
Excel VBA
This course is a basic introduction to the
use of Visual Basic for Applications (VBA) macros
within Excel. It is not a traditional programming
course, but concentrates on providing the ability
to edit and improve simple macros created by
the Excel Macro Recorder
- Recording and editing macros - absolute
and relative recording, running macros from
menu, toolbar, or graphic button
- The Visual Basic Environment - modules,
the Visual Basic Editor, the Help system
- Definition of variables, arrays, constants,
operators, expressions and functions
- Object Oriented Programming - objects, properties
and methods
- User interaction - message boxes, input
boxes and data validation
- Flow control Statements - if, go to, select
case, for, do
- Debugging and error handling
- Custom forms and dialogue boxes
- Custom menus and toolbars
- Sample projects
Microsoft Access
Access is an extremely powerful database, but
only a large portion of its function is 'hidden'
behind its user interface. The main limitation
to its efficient use is that it does require
an understanding of database design principles.
These skills are a main feature of the courses
offered
Fundamentals
- Introduction and overview - terminology,
relational database concepts viewing a sample
database
- Creating a database - creating a table and
adding fields, setting field properties, importing
tables
- Editing records, formatting the datasheet,
selecting, sorting and filtering records
- Queries - query types, creating select queries,
adding criteria, queries on multiple tables
- Form design - using the form wizard, changing
the form in design view, selecting and moving
form controls, adding calculated controls,
combo boxes and lookup tables
- Creating end editing reports
- Using the database wizard
Advanced
- Database design concepts - the design window,
fields and properties
- Table design - fields, formats, masks, caption,
default values, validation rules, required
property, indexes, key fields, lookup fields
- Functions and expressions - using the Expression
Builder, calculated controls, text functions,
date and time functions, domain Aggregate
functions
- Queries - Make Table, Update, Delete, Append,
Crosstab, Find Duplicates, Find Unmatched,
Multi-table, Concatenation queries
- Forms - control properties, macros, Combo
Boxes, main and subforms, search combos, command
buttons, adding domain aggregate controls
- Reports - Group and Totals, sorting and
grouping, running reports from forms
- Database Maintenance - building menus, automatic
macros, backup, repair and compacting, security
- Sample projects - password protection, linked
combo boxes, finding missing items
Microsoft Powerpoint
Powerpoint is one of the most popular presentation
packages currently in use. This course is based
around preparing a complete presentation from
scratch. It starts with a single slide and finishes
with a fully customised presentation of around
15 slides
- Starting Powerpoint and running a presentation
- Overview - the screen, menus, toolbars and
views
- Title Slides - adding titles and bullets,
outline levels, rearranging slide items, formatting
text, indents, line spacing and tabs
- The Help system - context help and searching
- Drawing - drawing tools, creating shapes,
selecting and moving, adding text to shapes,
adding clip art, aligning with guides
- Adding an organisation chart - entering
the chart text, formatting
- Graphs - the chart and datasheet windows,
default graph, editing the legend, axes and
chart type
- Importing Excel data as a chart
- Using the Templates and the Slide Masters
- applying a template, editing the Slide Master,
adding and removing Master objects, inserting
background text and headers / footers
- Standard Templates and Presentation Designs
- using and modifying standard presentations
- Running a slide show - hiding slides, adding
transitions animation and builds, setting
slide timings for automatic presentations
- Printing - slides, speaker notes, handouts
and outlines
- Tabular text - creating with Powerpoint
and inserting Word text
Web Design
Designing web sites is not a difficult procedure
as there are a considerable number of packages
available which are very similar in use to document
creation within Microsoft Word. It is not possible
however to get beyond very basic site design
without having a simple working knowledge of
the HTML mark-up language used to create web
pages. For this reason, we offer three courses.
An introduction to HTML gives the minimum required
knowledge to create and publish a web site with
very simple text and graphics. For more complex
sites, we offer either Macromedia Dreamweaver
or Microsoft Frontpage.
HTML Fundamentals
This course demonstrates simple web page design
using a text editor such as Notepad and concentrates
on HTML syntax. It is a prerequisite to obtaining
full function from standard web design packages
- Overview of the Internet - how it works,
browser types, HTML versions, script languages
- Creating a web page - using logical tags,
formatting using physical tags
- Hyperlinks - types of hyperlink, linking
to documents, mail addresses, bookmarks and
external web sites
- Adding graphics - graphic file types, creating
and editing images inserting and aligning,
background colour and images
- Using Microsoft Word as a web page editor
- creating the page, adding titles, headings,
text, images, lists and links
- Publishing the web - web site structure,
using FTP to transfer the site to a server
- Browsing the finished site
Web Site Design
This course can be based around Frontpage 98,
Frontpage 2000 or Dreamweaver In each case,
a complete web site is developed and published.
- Introduction to the design package - preview
of the finished site, overview of the package
interface
- Creating a new site - using a template,
inserting external text, files and web pages
- Organising site folders and creating a correct
structure
- Inserting mail, bookmark and web links,
text Vs graphics links
- Page formatting - Text format, in-line styles,
spelling checks, search and replace functions,
Cascading Style Sheet styles, common text
and library items
- Multimedia - graphics, sound movies, image
position and transparency, image maps, Macromedia
Fireworks and Flash
- Forms - creating forms, adding fields, field
types, data validation, data collection, server
side scripts for form handling
- Frames - purpose of a frame, frame pros
and cons, creating the frameset and adding
pages to it, navigating frame pages
- Publishing guidelines - choosing an ISP,
getting server script support
Microsoft Outlook
Outlook is a superb e-mail package, equally
at home for thousands of users in a large company,
or a private user with only a few messages each
week.
- Overview of Outlook - the folder groups,
toolbars, folder list
- Creating and sending messages - addressing,
formatting, adding a signature, spelling,
message options, attaching files, inserting
hyperlinks and mail addresses
- Reading mail - replying, sorting the display,
finding items, printing and deleting messages
- Folders and Address Books - creating folders,
using the contacts folder, creating nicknames,
using a distribution list
- Diaries and Meetings - the calendar, adding
appointments, setting reminders, printing,
requesting meetings, inviting attendees, accepting
meeting requests
- Personal folders - how to use them, location,
creating and moving item to them, archiving
- Remote access - getting the mail on the
move
- Dial up access from a laptop - off-line
folders, global address list
- Advanced topics - recalling messages, voting
messages, grouping and organising and filtering
messages, junk mail, creating message handling
rules, recurring appointments and tasks, file
import and export, sharing mail folders, delegating
mail to others, mail merge from the Contacts
folder
Other Applications
On request, we will attempt to arrange training
on most standard software, Quicken, Quickbooks,
Tax packages, disk partitioning utilities, antivirus
programs, backup software etc.
Download
A sample
of our workshop style training material may
be downloaded here
|