Microsoft Office
These quick tips and tricks, help you to brush up on some of those computer skills you haven't used in a while/or never used. Find out how to upgrade to the next or latest version of the Microsoft Office Suite.
Before beginning the Course, you will be asked to follow the link and complete an on-line, skills assessment (if you have not already done so), which will identify your current skill level prior to the course and then, again after the session, to demonstrate the skills attained and those gaps in your learning, that will require further attention.

Microsoft Basics
This course is designed for those who have basic computer skills. If you are unsure about your skill level, please email us before taking your pre test. We have many assessment tools and skill building activities that will help to bring you up to the necessary skill set. Microsoft Basics contains 9 Introductory Modules. You will move to the next level by covering:

• MS Outlook - Introduction to e-mail, creating contacts, sending and receiving attachments, saving and downloading attachments.
• MS Word - Creating a document, adding text, clipart and formatting a document.
• MS Excel - Open Excel and take a look at different types of documents you can create using Excel.
        Open a blank workbook:
  
  •       Look at the ribbon.
  •       Types of Entries.
        Open a spreadsheet create a simple list to demonstrate:
  •       Copying, moving and deleting.
  •       Format cells, using simple formulas.
  •       Insert and Merging Columns and Rows(changing width and row height).
  •       Close and Saving data.
  •       How to define Print areas and Print.
  •       Your workbook will also contain Definitions, concepts and terms.
        [½ Day Workshop]
• MS Publisher - Creating greeting cards using text, font and images and publishing (DTP).
• MS Powerpoint - Formulating slideshows using templates, inserting images, audio and video, adding animation and saving.
• MS OneDrive, Office Online-Office Online contains free pared-down versions of Word, Excel and PowerPoint that users can access online. Create, upload, manage and share files in the cloud.
• MS Access - Introduction to Access, the database-mangement software.
• MS Excel Formulas - Basics of creating formulas in Excel, Google Sheets and other spreadsheet programs which offer opportunities to practice real world examples.
• Google Docs - The basics of creating, formatting, sharing and managing files in the cloud using the documents featured in Google Drive.

• Look at changes to Word, Excel, PowerPoint and Outlook 2007.
• Complete the practice exercises along with the PowerPoint.
• You will complete your work at a dedicated workstation, following along with your Workbook.
• Time will be given to interact with your Instructor.
• A look at OneDrive.
• How to save a document in OneDrive, your document is stored in a central location that you can access from nearly anywhere.
• You will send a link rather than an attachment.
• Make revisions to that document, so everyone has access to one document, not multiples.
• Follow the PowerPoint for Word, Excel, PowerPoint and Outlook 2010.
• Time will be given to use the practice exercises outlined in the PowerPoint.

• Interact with the New Ribbon Interface
• New file extensions and compatibility considerations
• Formatting Themes
• Picture Formatting
• Options for Smart Art and Graphics
• New Zoom Bar
• Compatibility/Check reports
• Upload docs to the web with Sky Drive (requires Windows Live ID)
• Support for Macros

• The differences between old to new Operating Systems
• Saving data to 'The Cloud' (One Drive)
• Look at the new 'Start' Screen and how Recent Files are organised in the tile layout
• Locate applications and configure a default application to open your different file types
• Learn some new keyboard shortcuts.
• This session will allow you hands-on use of a touch screen device.
• Follow along with the PowerPoint and your workbook.
• Connect via Chrome Cast to a 27" Screen and carry out some workbook instructions.

Office 365 New Feature - The Microsoft Office 'Cloud System'
Here you will look at 365, its tools required to create, edit and share Office files, how to collaborate and communicate with others inside and outside of your organization.

• Overview of the Office 365 System
• Coauthoring and Collaboration
• Connecting resources to Outlook
• Accessing your Office 365 data from a smartphone or tablet.

OneNote 2013 - An Organisational Tool 'Manage Information and Share'
Create, edit, organize and enhance notes to integrate them with other applications. We will explore the Microsoft Office applications OneNote is used in conjunction with, such as Outlook, Word, Excel and PowerPoint. You will use templates and organize content, ready to share with other people. You will follow along your workshop document at a workstation.

• The ribbon, definitions, concepts and terms.
• Types of Entries.

• Save, open files, share with others and Print.
• You will receive instruction on how to configure your Office account for OneDrive or for your Office 365 account.

Operating Systems
What is an operating system?
A basic introduction to the different types of operating systems today.
What they allow you to do and how efficiently they do their job:
   Hardware, Software and Storage.
We will look at a few examples:
   Draw comparisions
   Look at their better known uses and cost structure.
Look at the OS Environment:

• Getting Started
• Windows Controls
• Working with Objects

• Open and Close files
• Create Files and folders
• Save and close

The Internet
What is the Internet?
A look at why the World Wide Web was created and its' uses.
How it has evolved.

Computer Basics
Are you looking to upgrade your computer?
This Workshop will help you to decide what is the best fit.
Look at the basics of how a computer works and the options available to you.
A hands on look within this session, at different types of computers.
Look at periferals and software options.

Business Management -' Information Systems Tools'
Thinking of starting up your own Business?
These workshops help you to find and configure the The Information System tools you can use to create those documents relevant to todays Business. You will use a Case Study to help define some of the aspects required in, the development of effective Management Planning Skills to:

1. Establish Business Goals and Objectives, using Word and other applications.
2. Write a Business Plan. Using a Word template and other applications.
3. Formulate milestones using a Project Planning template.
4. Write an Induction Manual for your Business, with reference to your 'Vision', 'Best Practice' and 'Risk Management' Proceedures. Using an Excel template.

Budgeting and Cashflow Management - 'Creating an Excel Workbook'
Never used excel?
In this workshop you will open an Excel Spreadsheet, gain some basic tips and tricks in producing simple budgets and cashflows.
We have several examples you will look at to help with the breakdown of costs relating to your own business needs and gain real insight to how you can apply this tool, to many other business functions.
NB* If you are training with one of our Course Group Workshops, we will use the beginning of this workshop to view the 'Induction Manuals' already completed by members of your group.

Accounting for Non Accountants - 'Preparing a Cash Book'
What is Accounting and why do we need it?
We will look at the Accounting Process, creating an Excel Workbook using simple spreadsheet formats to insert formulas and Cell formating. Cash book entries, allowing for GST and End of Year Summary exercises.
You will have a manual to work from, a Case study and use new features in Excel at a workstation.

Business Presentation - 'Creating A Promo'
Prerequisite is to have attended at least 1 other Workshop of the Full Course. Complete the Homework tasks ready for sharing. This session requires you bring along at least 20 photographs relating to your business operation.
We will begin with:

1. Looking at some examples of the type of presentations readily found on websites today.
2. Using a Power Point Template, you will create a Business Presentation promoting your business.
3. You will cover features as adding text, audio(As scripted in a previous session using Word), adding pictures and configuring animation and transition to your work. Saving your presentation in several formats to best fit where you will display and play.

Microsoft Word - 'Essentials'
You may have used Word before, perhaps to keep notes or to produce a simple document. In this session you will cover the Word Processing Basics:

1. Look at the ribbon, familiarise yourself with some of its' functions including the 'Help' section.
2. Look at the many templates Microsoft have developed for easy access. Use 'Quick start' to open a blank Word document, add text, edit the text, select and format text.
3. Look at page layout, paragraph formating, spell check and Auto correct.
4. Show select, shape and paste.
5. Learn some keyboard shortcuts, save, print (print preview) and save as a pdf for sending or filing.

Microsoft Word - 'Intermediate'
This Course takes you to the next skill level:

1. Review the basics.
2. Open a document, insert headers, footers, page numbering and section breaks.
3. Create a table on the document.
4. Using the ribbon we will identify and use Graphics, insert Bullets and Numbering, use Symbols and show tabs and indents.
5. Complete the Quiz.