Computing

These workshops are based around introductory and intermediate software applications. Fully supported friendly trainers help you build your skills.




INTRODUCTION & INTERMEDIATE TRAINING

1/2 day coursesMicrosoft Outlook (introduction), Word (introduction & intermediate), Excel (introduction), and PowerPoint (introduction)

All training is modified to your personal and organisational requirements!

This training is ideal for absolute beginners!

 

Introduction to Microsoft Outlook

Microsoft Outlook offers numerous ways to achieve different tasks.  Microsoft Outlook is a program that helps you to manage your messages, appointments, contacts and tasks and can help you create, share and manage information easily.

Course Content

Element 1

An overview of Microsoft Outlook, including:

  • System requirements
  • Launching and closing Outlook
Element 2

The Outlook Interface, including:

  • Outlook today
  • Make Outlook the start up page
  • Items and foldersThe navigation pane
  • Adding folders to Outlook
  • The Reading Pane
Element 3

Customising Views, including:

  • Customising the navigation pane
  • Customising the folders list
  • Customising the shortcuts list
Element 4

Using toolbars, including:

  • An overview of toolbars
  • Customising toolbars
Element 5

Using Help and Support, including:

  • Outlook help
  • Microsoft support
Element 6

Address book, including:

  • Address book
  • Create a contact
  • Distribution lists
Element 7

Working with emails, including:

  • Unblocking image downloads
  • Research services
  • Create a message
  • Setting message importance
  • Information rights management
  • Using message flags
  • Message formats
  • Reply to a message
  • Forward a message
  • Move messages into folders
  • Print an item
  • Delete messages
  • Organising messages
  • Finding messages
  • Create a signature
  • File attachments
  • Creating a hyperlink in a message
Element 8

Calendar, including:

  • Create appointments
  • Appointment options
Element 9

Using notes, including:

  • Creating and editing notes
  • Note options
  • Customising the notes view
Element 10

Using the Outlook journal, including:

  • Setting journal options
  • Creating and editing a journal entry
Element 11               

Internet basics, including:

  • What is the Internet?
  • What is the World Wide Web?
  • Modems, browsers and ISP's
  • Bandwidth
  • Types of internet access
  • Surfing strategies
  • Favourites

 

Introduction to Microsoft Word

Microsoft Word is an absolute must for any job role in a computer environment.  You will be able to perform basic operations including the creation and formatting of documents, creating tables and printing.

Course Content

Element 1                 

Get familiar with Microsoft Word, including:

  • The Title Bar
  • The Menu Bar
  • Tool bars
  • The Ruler
  • Document view
  • Text area
  • Exiting Microsoft Word
  • Using Help
Element 2

What you need to know, including:

  • Click
  • Options
  • Highlighting text
  • Highlighting menu items
  • The cursor
  • Using the ALT key
  • Shortcut notations
  • Starting a new paragraph
Element 3

Basic features, including:

  • Typing and using the backspace key
  • The delete key
  • Inserting text, selecting text and deleting text
  • Overtype
  • Bold, underline and italics
  • Scrolling
  • Saving a document
  • Open file
  • Cutting and pasting
  • Copying and pasting
  • Auto text
  • Spell Check, Thesaurus
  • Find and replace
  • Font size
  • Fonts
  • Margins, page size and orientation
Element 4

Paragraphs, including:

  • Space before and after
  • Line spacing
  • First line indent
  • Indentation
  • Alignment
  • Hanging indent
  • Page breaks
Element 5

Tabs, bullets, numbering, undo, redo and printing, including:

  • Tabs
  • Bullets and numbering
  • Undo and Redo
  • Printing
Element 6

Tables, including:

  • Creating tables
  • Moving around tables
  • Entering text
  • Select rows and bold the text
  • Right aligning text
  • Add a new row to the end of a table
  • Add a new row within a table
  • Resize columns
  • Add a new column
  • Sorting a table
  • The Sum function
  • Delete a column
  • Delete a row
  • Recalculate
  • Merge cells
  • Table headings
  • Converting text to a table
  • Splitting a table
  • Table auto format

 

 

Intermediate Microsoft Word

Develop skills learned in the Introduction to Microsoft Word course to create professional looking tables, multi-page documents and using mail merge for letters and labels.

Course Content

Element 1

Viewing your files, including:

  • Comparing documents side by side
  • Splitting a document
Element 2

Formatting tools, including:

  • Working with templates
  • Creating and saving templates and using wizards
  • Opening a user-created template
Element 3

Tables, including:

  • Borders and shading
Element 4

Using delineation tools, including:

  • Inserting a section break
  • Using columns
Element 5

Hyperlinks, including:

  • Inserting a hyperlink
  • Editing a hyperlink
  • Removing a hyperlink
Element 6

Headers and footers, including:

  • About headers and footers
  • Creating a header or footer
  • Editing a header or footer
  • Removing a header or footer
  • Adjusting the size and position of headers and footers
  • Navigating through headers and footers
  • Aligning text
  • Adding graphics
  • Inserting auto text
Element 7

Page numbering, including:

  • Inserting page numbers
  • Changing page numbers
  • Editing page numbers
  • Formatting page numbers
  • Removing page numbers
Element 8

Using language tools, including:

  • Setting your language
Element 9

Inserting pre-defined text, including:

  • Inserting the date and time
  • Inserting a symbol
Element 10

Using smart tags, including:

  • Enabling smart tags
  • Types of smart tags
  • Making smart tags appear
  • Using smart tags
Element 11                

Mail merge using Wizards, including:

  • Introduction to Mail Merge
  • How to use the Mail Merge Wizard

 

  

Introduction to Microsoft Excel

This course will teach you basic skills in Microsoft Excel which include developing simple spreadsheets.

Course Content

Element 1                 

Entering and editing text and numbers, including:

  • The Microsoft Excel window
  • Moving quickly around the worksheet - shortcuts
  • Selecting cells
  • Entering data
  • Editing a cell
  • Changing a cell entry
  • Wrapping text
  • Deleting a cell entry
  • Entering numbers as labels or values
  • Smart tags
  • Using help
  • Spell check and Thesaurus
  • Find and replace
  • Undo / Redo
  • Save a file
  • Closing Excel
Element 2

Formatting text and performing mathematical calculations, including:

  • Choosing a default font
  • Adjusting standard column and row widths
  • Cell alignment
  • Using bold, underline and italics
  • Change the font, font size and font colour
  • Working with long text
  • Changing a single column width
  • Moving to a new worksheet
  • Setting the enter key direction
  • Creating numeric entries
  • Mathematical calculations
  • AutoSum icon
  • Automatic calculation
  • Formatting numbers
  • More advanced mathematical calculations
  • Cell addressing
  • Deleting columns
  • Deleting rows
  • Inserting columns
  • Inserting rows
  • Creating borders
  • Merge and centre
  • Add background colour
  • Auto format
  • Entering dates and times
  • Hide / Unhide columns and rows
Element 3

Numbers and mathematical calculations, including:

  • Reference Operators
  • Functions
  • Typing a function
  • Calculating an average
  • Calculating minimums
  • Calculating  maximums
  • Calculating Count
  • Filling cellls automatically
  • Printing
  • Print preview
Element 4

Creating charts, including:

  • Create a column chart
  • Change the size and position of a chart
  • Modify a chart

 

 

Introduction to Microsoft PowerPoint

Microsoft PowerPoint is a software product used to perform computer based presentations.  There are various circumstances in which a presentation is made: teaching a class, introducing a product, explaining an organisational structure etc.

Course Content

Element 1                 

PowerPoint basics, including:

  • Exploring the PowerPoint window
  • The slide views
  • The task pane
  • Pull-down menus
  • Slide layouts
  • Adding text to placeholders
  • Saving a presentation
  • Exiting PowerPoint
  • Opening a presentation
  • Inserting slides
  • Copying slides
  • Deleting slides
  • Slide sorter view
  • Normal view
  • Outline view
  • Slide show view
  • Apply a slide design template
  • Choose a colour scheme
  • AutoContent Wizard
Element 2

Develop your presentation, including:

  • Text boxes
  • Formatting text
  • Cut, copy and paste
  • Bulleted lists
  • Numbered lists
  • Clip art
  • Pictures
  • Resizing clip art and pictures
  • Charts
  • Diagrams
  • Tables
  • AutoShapes
  • Word Art
  • Hyperlinks
Element 3

Develop your slide show, including:

  • Animation schemes
  • Effects
  • Animation direction and speed
  • Animation text and bullets
  • Slide master
  • Slide master and text
  • Title master
  • Spell check
  • Printing
  • Transitions
  • Preparing the slide show
  • Previewing the slide show

 

Introduction to Microsoft Access

The world produces an enormous quantity of data from every imaginable aspect of living, e.g. credit cards, store merchandise, telephone systems and web sites etc.  Years ago it ws a manual task to track and report this information.  Today, computer systems and databases manage the information.  Databases simplify our lives.

Course Content

Element 1                   

Introduction and Database terminology, including:

  • The usefullness of a database
  • Define a relational database
  • Real examples of utilising a database
  • Database components
  • The role of tables, forms, queries and records
  • The main access window
  • The database window
  • Design windows
  • Datasheet basics
  • Field properties
  • Table relationships
  • The primary key
  • Open an existing database
  • Tables, forms and reports in a database
  • The database Wizard
  • Create a database utilising the Wizard
Element 2

Working with tables and forms, including

  • Tables in datasheet view
  • Table navigation
  • Record selector field
  • Adding a table record
  • Table columns
  • Table rows
  • Editing tables
  • Cut, copy and paste within tables
  • The undo feature
  • Spell check
  • Deleting within tables
  • Forms and the forms object button
  • Switchboard menu navigation
  • Records navigation
  • Add records to a table
  • Locate an existing form record
  • Edit a form record
Element 3

Sorting, finding, filters, queries, reports and printing, including:

  • Simple sorting
  • Multi-field sorting
  • Remove a sort
  • Save a sort
  • Finding
  • Utilising Wildcard to locate a record
  • Filter by selection
  • Removing filters
  • Filter excluding selections
  • Filters by form
  • Run an existing query
  • Single-table queries
  • Multiple-table queries
  • Develop reports
  • AutoReport
  • The Report Wizard
  • Print preview
  • Page set up
  • Printing

 

Course times: 9.00am > 1.00 pm