*Email us to request Microsoft Word format brochures.

Introduction to Computers

	Introduction to Computers course is designed for beginners. It will cover the following topics:
	Start computer and access basic system information & features
	Computer functions
	Navigate and manipulate desktop environment using mouse and keyboard
	Organise basic directory and folder structures
	Storage devices and basic categories
	Organise files for user and/or organisational requirements
	Basic parts of a computer and various hardware components
	Basic keyboarding skills
	Saving and retrieving files to various locations
	Reading and writing at a level where basic workplace documents are understood
	Interpretation of user manuals and help functions
	Learn about computer security and virus protection
	Operating Health and Safety issues
	Conservation techniques in the office
	Copyright
	Computer terminology
	Professional Ethics
	Computer Jobs
	Shut down

Go Back

Desktop Publishing with Microsoft Word

Design and create newsletters and columns using Microsoft Word

Create Flyers

Import and modify graphics (drawings and photographs)

Create a booklet

Create invitations and cards

Create business cards

Work with forms

Create mass mailings and merges

Create a Logo

Work advanced tables

Work Section Breaks

Advanced Headers and Footers

Work with Tabs

Work with Watermarks

Work with WordArt

Work with Templates with autofeatures

Work with borders and lines

Work with Text Boxes and Callouts

Work with forms and advanced tables

Create Table of Contents

Create Index and Table of Figures

Create Comments and Footnotes

Create a Webpage in Word

Create a booklet

Autocorrect and Autotext

Import/Export to PowerPoint, Photoshop and other programs

Use Word shortcuts

Go Back

Microsoft Windows and Computer Administration

Desktop manipulation

Multitasking - Work with several applications

Customise the Start Button and the Taskbar

Customise Toolbars 

Controlling, tiling and sizing Windows   

Organising Files

Work with a CD/DVD/USB

Recycle Bin

Customize Desktop (screen saver, colours, etc)

Printer installation and management

Disk Cleanup and freeing of space

Hard Disk maintenance: ScanDisk

Disk Defragmenter

Create a Startup Disk

Add and Remove Windows Components

Compress folders and files and graphics

Change System Settings

Plug and Play

Hibernation and Standby

Shortcuts and "Scraps"

Import and compress graphics from camera/scanner

Create Folders and subfolders

Backup and System Restoration

Change Date/Time

Languages Support

Security with Passwords

Spy cookie removal

Virus Protection

Finding Files

Work with Windows Explorer and My Computer

Control Panel

Get Help in Windows

Install Drivers

Customise Icons

Customise Send to Menu

The Network Neighbourhood

Work with Fonts

Accessories: Calculator, Notepad, Clipboard, Paint

Install and Remove Software

Internet software; privacy, crime and social concerns

CD/DVD/Floppy care and management

Ergonomics

Input and Output devices, computer system connection

Go Back

Excel: Tips and Tricks Intermediate

	Revision of Excel Basics
	Excel Auto features
	Right Mouse Button Fill
	Left Mouse Button AutoFill
	Creating a Custom List
	Page Layout Features
	Relative and Absolute References
	Filter the List (Database)
	Subtotal List (Database)
	Consolidate Data
	Name ranges and Worsksheets
	Group and Outlining
	3D Formulas (file and sheet linking)
	Excel Charts
	Insert Comments
	Track Changes
	Paste Special
	Find and Replace
	Conditional Formatting
	Statistical and Math Functions
	Logical functions
	Dates functions
	Text functions
	Pivot tables
	Create Pivot Charts

Go Back

Excel: Tips and Tricks Advanced

	Working with Range names
	Nesting functions with IF
	SUMIF functions
	ROUND functions
	Using the PMT function
	Using the VLOOKUP, MATCH, and INDEX functions
	Using data tables
	Validating data
	Using database functions
	Importing/exporting data to text files
	Object Linking and Embedding
	Using Goal Seek
	Using Solver
	Installing Analysis ToolPak
	Creating Views
	Creating Scenarios
	Working with macros and VBA
	Creating custom functions
	Creating Document Workspaces
	SharePoint server
	Web Query
	Templates
	Pivot Tables and Pivot Charts
	Security
	File Password Protection

Go Back

Microsoft Word: Tips and Tricks Intermediate

	Create letters, fax forms and multi-page documents
	Format text and tables
	Insert graphics
	Spell Check and Grammar Check
	Work in Print Preview
	Autocorrect and Autoformat
	Work with shortcuts
	Tabs
	Page Setup and Page breaks
	Headers and Footers
	Work with various views
	Date and Time
	Copy and Paste data
	Find and Replace data
	Undo mistakes
	Work with bullets
	Create a newsletter, a flier and forms
	Mail Merge
	Format Painter
	Advanced Tables
	Formulas
	Sorting data
	WordArt
	Create forms
	Drop Caps
	Work with formulas and sorting
	Import external data (PowerPoint, Excel, Explorer)
	Drawing Toolbar
	Create labels and business cards
	Autoformat
	Autotext and Spike
	Work with multiple windows
	Insert Symbols

Go Back

Microsoft Word: Tips and Tricks Advanced

	Import and modify graphics (drawings and photographs)
	Work with forms
	Create mass mailings and merges
	Advanced tables
	Section Breaks
	Advanced Headers and Footers
	Work with Tabs
	Work with Watermarks
	Work with WordArt
	Work with Templates with auto features
	Work with borders and lines
	Work with Text Boxes and Callouts
	Work with forms
	Create Table of Contents
	Create Index and Table of Figures
	Create Comments and Footnotes
	Create a Webpage in Word
	Autocorrect
	Autotext and Spike
	Import/Export to PowerPoint, Photoshop and other programs
	Use Word shortcuts
	Work with styles
	Work with fill-in form fields
	Track Changes
	Customise screen and toolbars
	Macros
	Document Protection
	Work with multiple toolbars
	Insert Footnotes
	Insert Comments
	Bookmarks
	Create Master document and subdocuments
	Advanced document layout and formatting
	Work in Print Preview
	Autoformat
	Work with shortcuts
	Page Setup and Page breaks
	Work with various views
	Date and Time
	Copy and Paste data
	Find and Replace data
	Customise bullets
	Format Painter
	Sorting data
	WordArt
	Create forms
	Drop Caps
	Work with formulas and sorting
	Import external data (PowerPoint, Excel, Explorer)
	Drawing Toolbar
	Create labels and business cards
	Work with multiple windows
	Insert Symbols
	Documents Compare
	Research facilities

 Go Back

Microsoft Powerpoint

	Create text, bullet and title charts
	Format text, backgrounds and objects
	Work in various views
	Create organisational charts
	Create graphs
	Create flowcharts
	Design and manipulate graphics
	Create special animation and sound effects
	Create a web page
	Create slide show
	Create Tables
	Slide Transitions
	Templates
	Print Handouts options
	Macro buttons
	Shortcuts
	Import/Export Word/Excel

Go Back

Web Design using Front Page and HTML

Creating a Web
-Overview of Web Development
-Design a Web Page Layout
-Create a New Web Site
-Create and Format Web Page Text
-Import Web Pages

Creating Links
-Add Hyperlinks
-Add Bookmark Links
-Link from an Image

Adding and modifying Tables

Create customised bullets

Create Navigation Bar

Use lines and dividers

Work with graphics (JPG and GIF)

Work with Frames

Formatting a Web Page
-Work with Themes
-Set the Background

Publishing a Web
-Optimise page for search engines
-Downloading process of the page
-Web Page Hosting and Name Registration

Go Back

Microsoft Access – Intermediate

 
Go Back

Microsoft Access – Advanced

Go Back

Outlook Tips and Tricks