Courses

We have a great range of courses available including Vista and Office 2007. Have a read of our comprehensive course listing below.

	Microsoft Vista
1.	Introduction
	In this course we will introduce the new Vista operating system.
2.	Vista Basics
	Learn the basics and get up to scratch on a few of the new features of this operating system. This course gets you started by introducing Vista basics such as using the start menu, getting help and using the task bar in an easy to follow manner. Once your comfortable with the simple stuff move on for a more comprehensive understanding of customising the Start Menu, using Windows Flip commands, Windows Operations and using instant search.
3.	System Tools
	In this course you’ll learn about the system tools giving you a sound understanding of all the components that you need for effective use of your PC. Some of the topics cover include: Exploring your computer, using the control panel, the Recycle Bin, Notepad, WordPad, Paint, Disk Defragmenter, Freeing up disk space.
4.	Advanced Operations
	Take this advanced operations course to really master Microsoft Windows Vista! Advanced operations include: Creating User Accounts, Mapping a network drive, Adding a network printer.
5.	Customising Options
	Here we teach you some great ways to customize your computer so that it works best for you! Customisation covers: Windows sidebar and gadgets, customising the display properties, creating desktop shortcuts, customising options quiz.
6.	Final Review
	This final review will ensure that you’ve understood all the Vista courses so far!
Back To Top

	Microsoft Office 2007 - Excel
1.1	Introduction
	This course will give you a basic introduction to Excel, its purpose and power.
1.2	Excel Basics
	Learn the basics of Excel with this course which teaches you to open and close Excel and workbooks, understand the interface, enter dates and times, move and copy data, Autofill, insert, delete, and hide rows and columns.
1.3	Formulas, functions and analysis techniques
	Overview of formulas, functions and analysis techniques; in depth activities cover basic formulas, Autosum, relative and absolute references, basic sorting and filtering options, pivot tables and more!
1.4	Formatting techniques
	Overview of formatting techniques, border and shading, themes, creating simple charts and more!
1.5	Layout and Printing techniques
	Overview of Layout and Printing techniques, detailed tutorials and guides on Page Setup options, margins, headers and footers and more!
1.6	Final Review
	Test your knowledge by taking the final quiz.
Back To Top

	Microsoft Office 2007 - Word
2.1	Introduction
	This introduction to Word will give you a general understanding of the various uses of Word.
2.2	Word Basics
	Learn the basics of Word this course will take you through opening and closing Word documents, entering and editing text, using the find, replace and go to functions, working with tables, inserting pictures and objects and more!
2.3	Editing and Printing Techniques
	This course teaches you to use the spell and grammar check, inset page breaks, set margins and paper size as well as how to view and print your document.
2.4	Formatting Documents
	Master document formatting! This course covers aligning and spacing paragraphs, applying borders and shadings, inserting page numbers and headers and footers, creating columns and more!
2.5	Presentation and Security Techniques
	This course covers creating of simple charts, use of Quick Styles and Themes and security techniques so you can prevent unauthorized changes being made to your document and more!
2.6	Final Review
	Test your knowledge by taking the final quiz.
Back To Top

	Microsoft Office 2007 - Outlook
3.1	Introduction
	A great introduction to Outlook – understand its use and general functionality.
3.2	Outlook Basics
	Learn the basics of the Outlook email program; understand the screen, navigate, create and send messages, receive messages, send attachments, organise emails using colour categories.
3.3	Contacts and Calendar
	Learn to use Contacts and customise your Calendar! Add contacts, make appointments, create recurring events, plan meetings and create tasks! You’ll be organised in no time!
3.4	Folders and searching techniques
	Learn to create and use folders for organising your messages. Use instant search, sort your mail items, filter messages and deal with junk email.
3.5	Adjusting the default options
	This course teaches you to change the default options, making Outlook truly customised to your needs. Change message options, alert options, use rules and alerts, set print styles.
Back To Top

	Microsoft Office 2007 - Powerpoint
4.1	Introduction
	Get a great introduction to what you can do with PowerPoint – Microsoft’s slide presentation program.
4.2	PowerPoint Basics
	Learn the basics of PowerPoint! We’ll guide you through understanding the ribbon, creating a new presentation, entering text and text boxes, formatting text, adding new slides, applying themes and navigating your presentation.
4.3	Graphics and Tables
	Learn to use graphics, tables, and charts; add and format an object, use WordArt, insert a chart, table and media clips.
4.4	Master controls
	Learn the Master controls of Powerpoint; use the Slide Master, the Handout Master, the Notes Master, use headers and footers.
4.5	Previewing and Printing techniques
	Put the finishing touch on your presentation by applying slide transitions, animating objects on a slide, run the slide show and create a print out of your presentation.
Back To Top

	Intro To PCs
1.	Basic Components
	Start at the start - learn about the basic components of a PC: the keyboard, mouse and computer ports.
2.	System, Software & Setup
	Always been afraid of computers? This course will give you an easy to follow introduction to your PC’s operating system, software and setup.
3.	Computers in Society
	Computers have an ever increasing impact on our society. Learn about occupational health, the security problems they present and the copyright and legal implications of computer use.
4.	Intro to PCs Final Quiz
	Test your knowledge with our Intro to PCs final quiz!
Back To Top

	The World Wide Web
1.	Microsoft Internet Explorer
	Learn how to use this fantastic resource! We’ll show you how to use Microsoft’s Internet Explorer program including the address and standard tool bars as well as using the Favourites function and customising Internet Explorer to your needs, you’ll be surfing in no time!
2.	Other Browsers
	Learn about the other Internet browsers on the market.
3.	Email with Outlook Express
	Learn the basics of the Outlook Express; how to check for messages, open attachments, forward and reply to messages, send mail, add attachments, delete messages and add contacts.
4.	Handy hints and utilities
	These are the handiest hints we have come across: get free email accounts, MSN Messenger and free Spam and virus protection.
5.	The World Wide Web Final Quiz
	Test your World Wide Web knowledge with this quiz!
Back To Top

	Searching the Internet Effectively
1.	Internet Searching
	There’s so much on the internet, how do you find what you want? This course will teach you more about search engines which will help you find what you’re after much quicker! We’ll also introduce you to Subject Directories which you may find to be a great way of browsing the internet.
2.	Other Search features
	Learn about mailing lists, how they work, where you can find them and how to join. We’ll also introduce you to Newsgroups.
3.	Getting the most out of the Web
	Learn how you can download files from the internet so you can keep them on your computer for future reference, we’ll also show you how the internet can save you money!
4.	Searching the Internet Effectively Final Quiz
	Test your searching skills’ effectiveness with this quiz.
Back To Top

	Windows XP
1.	Basics
	All the basics you need to know to use a PC running Windows XP; starting up and shutting down windows, getting help, Windows Messenger, the Start Menu, using the Taskbar, Windows Operations, creating Desktop Shortcuts, exploring My Computer, using the Recycle Bin and much more!
2.	SystemTools
	Understand the primary system tools including those you may be familiar with such as Notepad, Wordpad, and Paint and those which may be new to you – the Disk Defragmenter, Disk Cleanup, Microsoft Management Console, Windows Explorer, Windows Security and Task Manager and more…
3.	Advanced Operations
	Learn the advanced operations of Windows XP; how to map a network drive, using a network, using offline network files, working remotely, synchronising files, the active desktop, adding new hardware and adding a printer.
Back To Top

	Word 2003
1.	Introduction to Word
	This introduction to Word will give you a general understanding of the various uses of Word.
2.	Creating a Word Document
	Learn the fundamentals of creating and modifying documents in Word; including highlighting and moving text, using the “find and replace” and “go to” functions, the international features of Word, applying and modifying styles to your document, creating and modifying tables and inserting other objects.
3.	Language Tools
	Word has a number of handy language tools that will assist you when creating documents, including spelling and grammar tools and a thesaurus as well as “autocorrect”, “autocomplete” and word count tools.
4.	Formatting Documents
	Learn the basics of formatting the appearance and layout of your documents including spacing and alignment of paragraphs, creating borders, columns and headers and footers, inserting page breaks and adding page numbers.
5.	Adding Styles
	Find out how to stylize your document and view the results including setting the margins, paper size and printing source of your document and using the reading layout view and print preview tools.
6.	Word 2003 Final Quiz
	Test your Word 2003 knowledge with this quiz.
Back To Top

	Word 2003 Advanced
1.	Automating Documents
	This advanced course teaches you how to use the in-built styles within Word, creating and modifying a style, inserting section breaks, applying different headers and footers to different sections, creating, navigating and updating a table of contents, using bookmarks and working with foot- and end-notes.
2.	Standard Documents
	Master the Mail Merge! Learn how to create and use templates in Word and create, use and customise mail merge documents, including envelopes and labels.
3.	Automatic Codes in Word
	Use Word to its full potential with embedded worksheets, linked charts, hyperlinks and macros; your documents will be professional and always up to date.
4.	Graphics in Word
	Learn how to insert and modify graphics in Word, including photos, objects and clipart.
Back To Top

	Excel 2003
1.	Introduction to Excel 2003
	Learn the basics of Excel with this introductory course including creating, opening and closing documents and how to use the Office Assistant.
2.	Using Excel
	The fundamentals of Excel are covered in this course including saving workbooks, managing files and folders and comparing Excel side by side.
3.	Entering and Manipulating Data
	Learn how to enter and manipulate data, change the data format, use the Autofill function, create lists and the various methods for selecting cells.
4.	Formulas and Functions
	This course teaches you about the various formula tools in Excel ,including reference operators, the Autosum function and other simple functions.
5.	Using the Edit Functions
	Edit your documents with ease. Learn how to edit your Excel documents including moving and copying data, using Autofill to copy formulae and inserting, deleting and hiding rows and columns in your spreadsheet.
6.	Formatting Cells
	Learn the many formatting tools in Excel including the ability to name ranges, relative and absolute references, cell reference styles, fonts, alignment, formatting numbers, rows and columns and conditional formatting.
7..	Formatting and Charts
	Create professional-looking charts and graphs with this course. Learn how to create and modify charts and format them by applying borders and patterns.
8.	Page Layout
	Learn how to best format and layout your page within Excel, including margins, headers and footers, sheet options, page breaks and print previewing.
9.	Excel 2003 Final Quiz
	Test what you have learned with this Quiz.
	Back To Top

	Excel 2003 Advanced
1.	Linking and Protecting
	Protect your work with this course. You will learn how to use the protect function as well as creating links within your workbook.
2.	Formatting and View Options
	Learn how to manage multiple workbooks and customise your view. You will learn how to create, use and delete custom views, scenarios and applying and removing conditional formatting.
3.	Templates
	Learn how to create, customise and use templates within Excel.
4.	Advanced Formulas
	In this course you will be taught some of the more advanced formula tools within Excel including the “Goal Seek” Function as well as the IF, AND and OR functions as well as calculating regular payments with PMT.
5.	Calculating Table Options
	Learn how to effectively create, use and format the more complex table functions in Excel, including variable data and pivot tables.
6.	Sorting and Filtering
	Sorts and filters are key tools in the Excel program, learn how to perform the sort and subtotal functions as well as applying and using the Autofilter.
7.	Automated Options
	Customise your spreadsheet by adding your own input and error messages, data validation, creating your own drop down lists and recording and running Macros as well as assigning them to specific tools.
Back To Top

	PowerPoint 2003
1.	Introduction to PowerPoint 2003
	Get started with PowerPoint, Microsoft’s professional presentation program. In this course you will learn how to start up and exit PowerPoint, create a Presentation, navigate the PowerPoint screen and use the AutoContent Wizard and help functions.
2.	Starting with Slides
	Learn how to navigate and modify slide layout, use and customise templates, create and format text and text boxes, add bullets and undo and redo actions in PowerPoint.
3.	Adding Images, Charts and Tables
	Enhance your slides with images, charts and tables; in this course you’ll learn how to add objects, optimise images, insert and modify charts and tables and create organisation charts.
4.	Master Operations
	Master Operations give you total control of your Presentation; you will learn how to effectively utilise the Slide, Title, Handout and Notes Masters as well as how to input Header and Footer information.
5.	Formatting Slides
	Customise the format of your slides including adding slide numbers, date and time information, slide transitions and slide timings, setting up and starting the slide show, using the slide show taskbar and performing a spell check on your slides.
6.	Display Media Options
	Learn how to professionally present your presentation on various media, including packaging your presentation for CD, optimal printing options and creating, saving and playing presentations for the internet.
7.	PowerPoint 2003 Final Quiz
	Test your knowledge with our PowerPoint 2003 Final Quiz
Back To Top

	Outlook 2003
1.	Introduction to Outlook 2003
	Get started with the fundamentals of Microsoft’s email, calendar and contacts program, Outlook 2003; including an Introduction to Outlook, navigating in Outlook and working with the Outlook Help features.
2.	Sending and Receiving E-Mail
	Learn all there is to know about creating, sending and receiving email messages, the various types of response to email messages, appending attachments, flagging emails and creating your own signature file.
3.	Managing Contacts
	Organise your Outlook contacts with this course; you will learn how to add and manage your contacts and use the contact shortcut menu.
4.	Using The Outlook Calendar
	Organise your day with Outlook calendar! This course will teach you all the basics of using the Outlook Calendar including arranging meetings and events, planning meetings and inviting attendees, creating, assigning and responding to tasks and using the notes function.
5.	Advanced Operations
	Master Outlook’s Advanced Operations with this course which includes creating and managing folders, finding items and files within Outlook, archiving, sorting and filtering Outlook items as well as setting your message options, changing alert options, using the rules wizard, setting your print styles and options, how to manage junk mail and the Outlook Arrange Feature.
6.	Outlook 2003 Final Quiz
	Test your knowledge with the Outlook 2003 Final Quiz.
Back To Top

	Access 2003
1.	Introduction to Access 2003
	Learn the fundamentals of the Access 2003 database creation and management program; you will learn how to open and close Access and what a database involves as well as the different types of databases and what to do when planning to set up a database.
2.	Access Basics
	Get a basic knowledge of the Access database program and how to navigate the Access object, database object views and groups, opening an existing database and creating a new one as well as using the Office Assistant.
3.	Creating and Working with Tables
	Learn how to create, save, close and delete a table, use the primary key function, using the datasheet view function and finding and replacing records using this function as well as Access 2003 Wildcards.
4.	Modifying Tables
	Customise your database to your needs; in this course you will learn how to modify, format, add, rename and delete columns and rows, add and save records, define relationships in your database and create field indexes as well as using the spell check and autocorrect functions in datasheet view.
5.	Working with Queries
	Learn how to use the query functions in Access 2003 including creating, opening, saving, closing and deleting queries, switching views in the queries, query sorting and criteria as well as hiding and ordering queries.
6.	Working with Forms and Reports
	Learn how to create and use forms and reports using the Access 2003 Wizard functions, this course also includes form and report navigation and Access 2003 Start up options.
7.	Access 2003 Final Quiz
	Test your Access 2003 knowledge with this quiz.
Back To Top

Want more out of your computer? QK offer a wide range of professional computer services to help you make the most of your technology. Call QK now to find out how we can help you!

:: Aus 1300 737 682

:: NZ 0800 441 251