Home · Courses

Please select the category you are interested in:

Course Type




Course Categories




















Clear All

Access Advanced

This course focuses on how to design and create multi-table databases and how to automate operations using macros.

Access Intermediate

This course builds on the introductory skills of the Introduction course. You will learn how
to ensure that data is entered correctly, how to create more sophisticated and complex
queries, and how to use basic automation techniques involving macros.

Access Introduction

This course focuses on developing skills and knowledge to create databases. You will learn how to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.
 

Acrobat Introduction

This course introduces new and existing users of Adobe Acrobat to the skills and knowledge needed to create and modify Portable Document Format (PDF) files. You will learn how to view, create and modify PDF files You will also learn how to make your PDF files more accessible to your audience by adding navigation elements and security.
 
This course is available to be run on your site only.

 

Excel Advanced

This course focuses on learning how to use some of the complex Function formulas including IF and VLOOKUP as well as Financial and Text Functions. You will also learn how to use formulas to link and consolidate data across worksheets, Macros to automate routine tasks and Scenarios, Goal Seek and Solver to model spreadsheet data and make informed decisions.

Not sure which level to attend? Click here to take our quick online quiz.

Excel Intermediate

This course provides a solid grounding in the more commonly used formulas and functions in Excel and in the best practice methods for analysing data. You will learn techniques to help you find information, write formulas and analyse data in tables, lists and charts and how to get the most out of the powerful Pivot Tables and Pivot Chart data analysis tools.

Not sure which level to attend? Click here to take our quick online quiz.

Excel Introduction

This course introduces you to Excel spreadsheets and how they are used in business. You will learn to create, edit, format and print professional looking spreadsheets using simple formulas.

Not sure which level to attend? Click here to take our quick online quiz.

Excel VBA Advanced

Learn how to create string functions, manipulate charts, work with control and useform events and hot to create Excel applications that interacts with other programs. This Excel Visual Basic for Applications (VBA) Advanced course is suitable for all versions of Excel, and is held in Sydney and Melbourne.

Excel VBA Introduction

VBA is a programming language used to create and edit automated procedures in Excel called macros. Macros can be used in simple ways, such as automating a routine print process, and for more advanced application automation and design within Excel. On this course you will learn how to create and edit recorded macros, use Visual Basic programming to code and edit more complex procedures, design appropriate user interaction for your macros to make them easy to use and build error checks into your macros to handle errors and maintain integrity. You will also learn about good programming practices and how to write, edit and debug more complex VBA programs using the Visual Basic Editor.

Illustrator Introduction

Adobe Illustrator is an illustration and drawing program designed for people who want to create vector-based graphics for design, web design or desktop publishing material. You will learn to create professional artwork and documents and to create and modify illustrations and use colour, shapes and layers effectively.

This course is available to be run on your site only.

InDesign Introduction

Adobe InDesign is used to produce high quality, attractive publications. You will learn to use the tools and techniques needed to work confidently with text, graphics, colour and layout for professional publications.

This course is available to be run on your site only.

MS Teams Introduction

This course will introduce you to Microsoft Teams, a platform that combines workplace chat, meetings, notes, and attachments. The service integrates with the Office 365 subscription office productivity suite, including Microsoft Office and Skype. You will learn how to use MS Teams to share ideas and information and collaborate and communicate with work colleagues.

Office 365 for Business

This course will introduce you to Office 365 for Business and cloud computing. You will learn how to use the Office 365 apps and services to work on your files from anywhere and collaborate with co-workers using Office Online, OneDrive, SharePoint Online, Planner and Teams.
 

Outlook Introduction

This introductory course is for anyone who needs to use Microsoft Outlook to manage email, schedule appointments, and keep track of contact information.

Photoshop Introduction

Adobe Photoshop can be used to edit and manipulate photographic images. You will learn how to open, create, modify and apply various effects to photographic images. 

This course is available to be run on your site only.

PowerPoint Advanced

This course is for experienced PowerPoint users. You will learn how to work with the advanced image enhancement tools, animations and transitions, media and action buttons, slide masters and templates, how to import data into PowerPoint and how to work collaboratively on a presentation file.

Not sure which level to attend? Click here to take our quick online quiz.

PowerPoint Intermediate

This course builds on the skills and knowledge acquired in the PowerPoint Introduction course. You will learn how to work with themes, insert and modify images, tables, charts and shapes on your slides and how to animate content to make your presentations dynamic and engaging.

Not sure which level to attend? Click here to take our quick online quiz.

PowerPoint Introduction

This course is an introduction to the effective design, creation and presentation of information using Microsoft PowerPoint 2016. You will learn many tips and tricks to save time when creating presentations and you will explore the tools and features in PowerPoint that will help you create engaging and dynamic presentations. This PowerPoint course is running in Sydney and Melbourne.

Not sure which level to attend? Click here to take our quick online quiz.

Project Advanced

This course will take you into the more advanced levels of Microsoft Project. It covers a diverse range of topics including working simultaneously on multiple projects, sharing resources between several projects, downsizing very large projects, using templates, and automating operations with VBA.

Not sure which level to attend? Click here to take our quick online quiz.

Project Intermediate

This course is for existing users of Microsoft Project who want to extend their skills and knowledge beyond the creation of simple projects.

Not sure which level to attend? Click here to take our quick online quiz.

Project Introduction

This course will introduce you to Microsoft Project. You will learn how to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

Not sure which level to attend? Click here to take our quick online quiz.

SharePoint Level 1

This course will introduce you to Microsoft SharePoint. You will learn how to navigate SharePoint sites, find, edit and upload content to sites and create and manage sites and site permissions.

SharePoint Level 2

This course will extend and deepen your working knowledge of SharePoint. You will learn how to customise SharePoint elements, work with templates, create custom workflows, work with custom content types and document sets, manage security on sites and use social networking features.

Virtual Class - Excel: Advanced Filters for Databases and Lists

Learn to use Advanced Filters in Excel  to summarise and analyse large data lists and complex data sets.

Virtual Class - Excel: Automation with Macros

Learn to record, run and edit Macros to automate routine Excel tasks using the Macro Recorder and Visual Basic for Applications (VBA) programming code.

Virtual Class - Excel: Charts and Graphs

Learn how to display Excel data graphically using a variety of compelling charts.

Virtual Class - Excel: Collaboration and shared workbooks

Learn to share and co-author Excel workbooks and collaborate with team members online.

Virtual Class - Excel: Dashboards

Learn how to create a dashboard in Excel to help you keep a visual track of important performance measures and targets in your spreadsheet models.

Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver

Learn how to use Scenario Manager, Goal Seek and Solver to perform complex spreadsheet modelling and how to quickly analyse options and make better decisions.

Virtual Class - Excel: Error-proofing your spreadsheets

Learn how to find and fix common errors in spreadsheets and how to create models that have built-in error prevention mechanisms to help maintain data integrity.

Virtual Class - Excel: Fast formatting tips

Learn tips and tricks for fast formatting. Apply best practices and improve the layout and presentation of your Excel data quickly and easily.

Virtual Class - Excel: Formulas for everyday calculations

Learn how to write and edit simple formulas in Excel to calculate results. You will learn how to write formulas that add totals and calculate averages and how to use built-in formulas called Functions.

Virtual Class - Excel: Formulas for financial analysis

Learn to use Excel formulas that work on financial data. Financial functions are used to calculate many finance related operations including loan repayments, depreciation of assets and rates of return on investments.

Virtual Class - Excel: Formulas for statistical analysis

Learn how to use Excel Statistical Functions to calculate averages, standard deviations and other useful statistical information for analytical and reporting purposes.

Virtual Class - Excel: Formulas for What-If analysis

Learn how to write and edit IF formulas to return results based on variable conditions in your spreadsheet data.

Virtual Class - Excel: Formulas for working with text

Learn to use Excel Text Functions to clean up imported text and manipulate how textual data is stored and displayed.

Virtual Class - Excel: Mastering VLOOKUP formulas

Learn how to create and edit VLOOKUP and other Lookup formulas to extract data from Excel lists and tables based on variable conditions and criteria.

Virtual Class - Excel: Math Functions

Learn to use Excel Functions for complex mathematical operations. Math functions are used for many mathematical operations including adding up totals, multiplying values and rounding numbers.

Virtual Class - Excel: Pivot Tables and Pivot Charts

Learn how to create and edit Pivot Tables and Pivot Charts to quickly visualise and analyse large Excel data sets and make better business decisions.

Virtual Class - Excel: Power Pivot and Power View

Learn to use Excel Power View and Power Pivot to connect to, analyze and visualize massive amounts of data.

Virtual Class - Excel: Quick viewing and printing tips

Learn tips and tricks for viewing and printing Excel data effectively and efficiently.

Virtual Class - Excel: Sorting and Filtering Lists and Databases

Learn how to turn raw data into useful business information to help you make more informed decisions. Work with built-in, easy to use database and list management tools in Excel to analyse large sets of business data quickly and efficiently.

Virtual Class - Excel: Top ten tips

Learn ten essential tips and shortcuts that will dramatically improve the way you use Excel.

Virtual Class - Office 365: Getting started

Get started with the core Office 365 applications and services. The session will focus on using Office 365 in the cloud, on the desktop and on mobile devices with an emphasis on how to get up and running with the core office applications.
 

Virtual Class - Office 365: OneDrive

Learn how to use OneDrive for Office 365 to share files with colleagues, upload and sync files to the cloud and work on your files from any location.

Virtual Class - Office 365: OneNote

Learn how to use OneNote with Office 365 to create digital notebooks for capturing, organising and sharing information including meeting minutes, workshop notes and other important reminders.

Virtual Class - Office 365: Planner

Learn how to use Planner with Office 365 to establish and manage small projects, share files and assign and track group tasks.

Virtual Class - Office 365: Sway

Learn how to use Sway with Office 365 to create and share engaging, interactive online presentations, reports and stories.

Virtual Class - Office 365: Teams

Learn how to use Teams with Office 365 to create customisable, chat-based team workspaces for information and file sharing and for collaboration on team projects and events.

Virtual Class - Office 365: Yammer

Learn how to use Yammer with Office 365 as a private microblogging and collaboration platform for enterprise social networking.

Virtual Class - PowerPoint: Animation and transition effects

Learn how to use animation and slide transitions to make your presentations more dynamic and engaging. You will learn how to animate bullet points and other shapes and how to use engaging transition effects to move from one slide to the next during your presentation.

Virtual Class - PowerPoint: Creating your first slide show presentation

Learn how to create a dynamic, engaging slide show presentation using PowerPoint.

Virtual Class - PowerPoint: Images, tables, charts and shapes

Learn how to insert and use images, tables, charts and shapes to improve the appearance and effectiveness of your PowerPoint presentation.

Virtual Class - PowerPoint: Top ten tips

Learn ten essential tips and shortcuts that will dramatically improve the way you use PowerPoint.

Virtual Class - Project: Lesson 1 Creating a project

Learn how to use MS Project to create and manage projects. Our MS Project virtual training course is delivered as 4 x 90 minute lessons. Participants need to enroll in all 4 MS Project lessons. This first lesson will cover the essentials skills for creating and saving your first project file. 

Virtual Class - Project: Lesson 2 Scheduling tasks

Learn how to use MS Project to create and manage projects. Our MS Project virtual training course is delivered as 4 x 90 minute lessons. Participants need to enroll in all 4 MS Project lessons. This second lesson will cover the essentials skills for entering tasks and scheduling. 
 

Virtual Class - Project: Lesson 3 Resources, materials, costs and constraints

Learn how to use MS Project to create and manage projects. Our MS Project virtual training course is delivered as 4 x 90 minute lessons. Participants need to enroll in all 4 MS Project lessons. This third lesson will cover the essentials skills for managing resources, materials, costs and constraints associated with a project. 

Virtual Class - Project: Lesson 4 Tracking and reporting

Learn how to use MS Project to create and manage projects. This MS Project virtual training course is delivered as 4 x 90 minute lessons. Participants need to enroll in all 4 MS Project lessons. This last lesson will cover the essentials skills for tracking and reporting on the progress of a project. 

Virtual Class - Visio: Lesson 1 Getting started

Learn how to use MS Visio to create a range of business diagrams. The course is delivered as 4 x 90 minute lessons. Participants need to enroll in all 4 Visio lessons. This first lesson will cover the essentials skills for navigating Visio, working with stencils and creating basic Visio shapes.

Virtual Class - Visio: Lesson 2 Shapes, connectors and containers

Learn how to use Visio to create a range of business diagrams. The course is delivered as 4 x 90 minute lessons. Participants need to enroll in all 4 Visio lessons.This second lesson will cover the essentials skills for formatting shapes, working with connectors and working with containers. 

Virtual Class - Visio: Lesson 3 Working with text and pages

Learn how to use Visio to create a range of business diagrams. The course is delivered as 4 x 90 minute lessons. Participants need to enroll in all 4 Visio lessons.This lesson will cover the essentials skills for working with text and pages. 

Virtual Class - Visio: Lesson 4 Org charts and flow diagrams

Learn how to use Visio to create a range of business diagrams. The course is delivered as 4 x 90 minute lessons. Participants need to enroll in all 4 Visio lessons. This lesson will cover the essential skills for creating organisation charts and workflow diagrams. 

Virtual Class - Word: Collaborating on documents with Track Changes

Learn how to collaborate on a Word document with co-workers by using Track Changes and other reviewing and document protection tools.

Virtual Class - Word: Creating long documents using Section breaks

Learn how to use Section breaks to create long documents with different page layouts and alternating headers and footers.

Virtual Class - Word: Creating long documents using Styles

Learn how to create and use Word Styles to format headings and paragraph layouts consistently and quickly. You will also use Styles to generate a Table of Contents for a long document.

Virtual Class - Word: Mastering Fields

Learn how to use Fields to make your Word documents dynamic. You will learn about Formula fields, Date and Time fields and REF fields and learn how to use FILLIN fields to capture user input through pop-up dialogs.

Virtual Class - Word: Mastering images and shapes

Learn how to insert and edit images into your Word documents and how to illustrate documents with shapes and drawn objects.

Virtual Class - Word: Mastering Macros

Learn how to save time by automating routine tasks and processes in Word using the Macro recorder.

Virtual Class - Word: Mastering Mail Merge

Learn how to use Word's Mail Merge function to send out a personalised mail-out of a standard letter or document to a large group of recipients.

Virtual Class - Word: Mastering Tables

Learn to easily insert, edit and format Tables in Word documents to improve readability and document effectiveness.

Virtual Class - Word: Mastering Templates

Learn how to save time by using the built-in templates provided in Word and by creating your own customized, re-usable document templates

Virtual Class - Word: Top ten tips

Learn ten essential tips and shortcuts that will dramatically improve the way you use Word.

Visio Intermediate

Microsoft Visio Professional is an application used for creating diagram to simplify complex information.  
This course will help you build your skills in Visio to enable you to create complex diagrams including organisation charts, cross functional flowcharts and Gantt charts.

Visio Introduction

Microsoft Visio Professional is an application used for creating diagram to simplify complex information.  
This course introduces you to Microsoft Visio and the basic tools you need to use to create business diagrams. You will learn how to create shapes, use containers and connectors and work with text.

Word Advanced

This course is for experienced Microsoft Word users who need to know how to use the more advanced features of Word. You will learn how to automate processes with macros, create custom templates, collaborate on documents and track changes, use fields and electronic forms and create a table of contents for a long document.

Not sure which level to attend? Click here to take our quick online quiz.

Word Intermediate

This course is for experienced users of Microsoft Word who need to create longer, more complex documents. You will learn advanced techniques for laying out and presenting information using columns, tables, styles, section breaks, headers and footers, AutoText and Building Blocks. You will also learn how to perform a mail merge and how to work with pictures and SmartArt.

Not sure which level to attend? Click here to take our quick online quiz.

Word Introduction

This course will introduce new and existing users of Microsoft Word to the skills and knowledge needed to create common business documents including letters, memos and reports. You will also be introduced to Word's proofing tools for spelling and grammar as well as the automatic proofing and formatting tools such as AutoCorrect and AutoFormat.

Not sure which level to attend? Click here to take our quick online quiz.