Courses Available

If you are a new computer user we recommend our "Introduction to Computers" 

We offer onsite training and consulting in your workplace in the following programs:

• MYOB
• Word
• Excel
• Access
• Outlook

We offer courses ranging from beginners to advanced in the following programs:

• Word
  
• Video Editing
• Excel
• SKYPE
• Outlook
• Access
• Digital Camera
• Desktop Publishing
• Burn CDs
• PowerPoint
• Courses for Seniors
• MYOB
• Touch Typing
• Email & Internet
• Xubuntu & other Linus programs
• Using a USB Memory Stick
• Create PDF files for free
• And Many More...

Course Content, saving, opening, printing and closing

Intro to Outlook 2010

• Email
• Contacts
• Calendar
• Tasks
• Notes
• Mail merge with Word
• Integrating all of the above

Intro to Word 2010

• Format text
• Bullets, formatting bullets
• Headers and footers and page numbers
• Inserting page breaks
• Save As command
• Spell checker, grammar checker and thesaurus
• Saving, opening and printing
• Copy and paste
• Aligning text
• Page orientation and size
• Print to different printers
• Margins
• Line spacing
• ClipArt - inserting and wrapping text around it
• Insert symbols
• Auto correct
• Zoom control and views of a document
• Paragraph and page borders
• Coloured text and highlighter pen
• Using templates

Intermediate Word 2010

• Tabs, leader tabs
• Tables
• Indents
• Columns
• Drop cap
• Scanned images and images from CD
• Create folders
• Clipboard for copy and paste
• Some keyboard shortcuts
• Layered bullets
• Create templates
• Create web page

Advanced Word 2010

• Mail Merge
• Copy and paste from other applications
• Online form
• Macros
• Symbols, keyboard shortcuts
• Watermarks
• WordArt and text boxes
• Footnotes and endnotes, bookmarks
• Table of contents and index for large files
• Hyperlinks and bookmarks
• SmartArt
• WordArt
  

Intro to Excel 2010

• Opening, saving and printing
• Navigating a workbook
• Enter data and edit data
• Auto sum
• Fill handle, auto fill
• Formatting and auto formatting
• Sorting data
• Create simple graphs
• Use print preview, set-up for page, gridlines, black and white printing, centre horizontally, header and footer
• Average, count, max and min formulas
• Subtraction, multiplication and division formulas
• Borders
• Column width and row height
• Name worksheets

Intermediate Excel 2010

• Sorting by more than one criteria
• More complex formulas
• Set print area
• Freeze panes
• Formatting cells, alignment, number
• Filters, auto filters
• Templates, using and creating
  
• WordArt and ClipArt, insert images
• Relative and absolute cell references
• Percentage

Advanced Excel 2010

• Images in graphs
• "If" formulas
• Pivot tables
• Macros
• Validation for data entry
• Naming cells
• Trendlines in graphs
• 3D formula
• V-lookup
• PMT formulas
• Goal seek
• Use web data to update an Excel worksheet
  

Intro to Access 2010

• The main areas of an Access database
• Entering data
• Editing data
• Finding data in a large table or form
• Create a new database
• Create a new table, field names and data types
• Create a form and auto form
• Create a query, criteria for queries
• Modify a query and use Save As
• Create simple reports
• Create mailing labels

Intermediate Access 2010

• Import data from Excel
• Link data to Excel
• Changing the data types in a table
• Adding a second table to a database and then develop a relationship with the first complex queries with more than one table
• Reports to group data
• Create reports to calculate, sum, average, percentage
• Limit data size
• Export reports to Word
• Export tables and queries to Excel
• Create queries to calculate

Intro to Desktop Publishing 2010

Use a Publisher Wizard to create:

• Business card
• Letterhead
• Business form
• Greeting card
• Invitation
• Sign
• Banner
• With compliments card
• Calendar
• Labels
• From scratch create simple signs using text boxes, WordArt, ClipArt, images from file, tables
• Draw shapes and layer them

Intermediate Desktop Publishing 2010

Use a Publisher Wizard to create:

• Newsletters
• Brochures
• Advertisements
• Catalogues
• Make some of the above from scratch
• Insert design gallery objects and text files
• Use a digital camera
• Create web pages
• Mail merge in Publisher

Intro to PowerPoint 2010

PowerPoint Presentation from scratch to include:

• Slide layout
• Text
• Graphics from ClipArt, CDs and scans
• Charts
• Tables
• Apply design template
• Add builds and transition for effect
• Add sounds
• Add video clips
• Add timing to slides and set to Auto Run
• Change background colours and objects
• Make a presentation using a Auto Content Wizard

Intermediate PowerPoint 2010

• Download templates from Microsoft website, including resume PowerPoint template
• Make own templates
• Change the master
• Animate text and graphics including drawing own shapes and animating them
• Hyperlinks for PowerPoint navigation
• Exporting to Word
• Saving a slide show for email
• Package to CD

Create your own Web Page

Use Trellian to create Web Pages with:

• Text
• Images
• Tables
• Backgrounds
  
• Scrolling marquee
• Links to other Web Pages and the rest of the Internet

Intro to Internet

• Follow links on a Web Page
• Use the toolbar navigation buttons
• Using a web sites URL
• Using a search engine
• Placing sites in the favourites menu for easy retrieval
• Save text, images and music
• Sending email
• Reading email
• Returning email
• Attaching images to an email
• Create an entry in an address book
• Add a signature to an email

Intermediate Internet

• Search the web with more advanced skills
• Saving files from a web site (games)
• Checking for viruses
• Updating virus checker from the web
• Opening Adobe Acrobat files on a web site
• Setting and using newsgroups in Windows Live Mail
• Chat in a chat room
• Using MS Messenger to chat with friends
• Listen to online radio stations

Intro to MYOB Version 19

• Using features of the program
• Identifying icons and buttons
• Creating your own file
• Sessions reports and backing up
• Opening balances
• Activities - purchases
• Activities - inventory
• Activities - sales
• Activities - bank deposits
• Getting reports
• Create cards

Intermediate MYOB Version 19

• Setting up BAS
• Reconciling bank accounts
• Working with your Accountant
• Setting up a simple payroll
• Designing invoices and reports

Using Hotmail

• Learn how to set up and then use a Hotmail web based email account
• Use from the library, home, on holidays, cyber cafes, at the airport, at a friends etc

Using a Digital Camera

• Take photos, download them to the computer
• Resize them and improve them
• Make them lighter etc
• Send them with an email

Burning CDs

• Using Nero Burn learn how to burn software and music to a CD
• Burn video to a DVD
  

Use a Scanner

• Use a scanner to take photos and place them in your computer as a digital copy
• Resize them and then attach them to email or use them in a document
• OCR (Optical Character Recognition) converts a paper document into a word file

Copy LPs to CD

• Use Audacity software to record tracks from LPs to the computer
• Edit the contents and then burn the tracks to CD

Weblog (BLOG)

• Create a weblog (BLOG) to keep an online diary or commentary
• Free software and free hosting

Computer Tech

• Take a computer apart, add new hard drives and CD or DVD player
• Add more RAM to improve performance
• Add new sound cards and video cards for better sound or graphics

Computer Software Maintenance

• Make your computer run better by fixing the software
• Update and run virus and spyware checkers
• Download Windows updates
• Defrag the hard drive

Buy and Sell on EBay

• Register and learn how to find objects on EBay
• How to bid
• How to track your item
• How to list and check sellers
• How to sell items
• How to upload photos of items you are selling
• The costs involved

Using a USB Memory Stick

• Saving files to a memory stick using Save As
• Copy files to the memory stick from the hard drive
• Using Sync Toy to synchronise a folder with the USB memory stick

Create PDF files for free

• Download and install Cute PDF Writer
• Use Cute PDF Writer to convert Word and Excel documents to PDF format

Upload Video to Youtube

• Register at Youtube
• Optimise videos for uploading
• Uploading
• Email and embed code
• Tagging the video