Computer Skills

Adobe Acrobat can create PDF files from documents produced in other software programs while preserving the original document layout and content. Learn how to convert files from Microsoft Word, Excel and other programs and how to protect PDF files with a password. Find out how to extract, delete or move pages in PDF files.

This program introduces the more advanced features of Adobe Acrobat and shows you how to create forms, work with groups of PDF files and add multimedia elements to PDF files.

Understanding the fundamental concepts and terminology and learning the basic features is essential when starting out in Adobe InDesign CS6. Learn how to create documents, place text or graphics and how to create custom colour swatches. During this program you will format text, work with layers, print documents and package documents for commercial printing.

As a first introduction to Photoshop this program shows you how to customise Photoshop and how to create professional looking images. It explains various uses of images and the difference between raster and vector graphics. You will modify images, switch image modes and adjust colour and contrast attributes. If you are new to Photoshop or have little experience with Photoshop, this program is for you.

This program shows you how to work with databases in Microsoft Excel (using filtering, sorting and subtotals). It introduces PivotTables, Macros and Hyperlinks and teaches logical, lookup, reference and statistical functions. If you are experienced in designing and modifying spreadsheets, can write formulas and have worked with IF and VLOOKUP functions, this is for you.

This program concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.

This program is for high-end users who want to make the most of the power of Microsoft Excel. It introduces programming techniques and concepts such as variables, scoping, importing data, passing values and debug techniques. If you have experience with the macro recorder and introductory programming, you will benefit from this program.

This program outlines Microsoft Excel’s What-If Analysis tools which can be very useful for business planning and modelling techniques. They are used to look at a range of plausible outcomes and determine what input values are needed to achieve those outcomes.

This program focuses on Microsoft Excel’s array formulas; extremely powerful formulas that can perform complex calculations on one or more series of data values. They are very useful in decision and financial modelling.

Descriptive, predictive and prescriptive analytics are interrelated, helping companies make the most out of their data. Excel is a tool that can be used for analysis; to collect, clean, transform and analyse data and generate reports.

Do you need to create or modify spreadsheets using Microsoft Excel? In this program you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations. If you use computers but are new to Excel or don't have much experience with Excel, then this program is for you.

This program focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

If you have used Microsoft Excel for some time and need to learn more, this Perth based training program provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills. This hands-on class lays the foundations for building a stronger, more advanced understanding of Microsoft Excel and will coach you to be confident with Microsoft Excel functions commonly used in the workplace. Learn how to identify ranges with names, use workbooks with multiple sheets, protect worksheets and files, link worksheets, audit files and create templates. Work interactively with functions such as IF and VLOOKUP. To benefit from this short course, you should be a confident user of Microsoft Excel.

If you need to quickly and accurately make sense of your Company's raw data, this is for you. We introduce you to Key Performance Indicators (KPIs) and dashboard design processes, and help you build an interactive KPI Dashboard. You will learn how to handle raw data, use functions to create performance metrics, and build mini charts, pivot tables and pivot charts typically used in dashboards.

This program will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.

This program concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.

With Power Query, discover, connect to and import data into Microsoft Excel. Then, using PowerPivot, remodel and enhance the imported data by writing queries through Power Query M language.

This program focuses on the main features of Microsoft Excel PowerPivot; a very fast, space-saving, columnar add-on database that can handle vast amounts of data far beyond the limits of an Excel worksheet.

This program introduces the visualisation layer of Microsoft’s Power BI Desktop called Dashboards. This report creation feature provides the means of creating reports that provide dynamic perspectives and insight into your data.

Finding out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and keep track of time, is probably the best decision you'll ever make! If you have used Outlook for some time, but need to become more efficient when dealing with your messages, organising meetings and storing contact information, this program is for you.

Do you want to create presentations with a difference? Including movie clips and sound tracks is easier than you might think. They bring presentations to life and can make your message truly memorable. Learn all of this and find out how to avoid the most common PowerPoint mistakes by creating well-designed templates and by using the advanced features PowerPoint has to offer.

Most people remember information best if they not only hear it, but also see it. That's why PowerPoint presentations need to support the message of a presentation effectively while at the same time, making it easy for presenters to deliver the message. If you have little experience with PowerPoint or are new to PowerPoint, this program will help you to create well designed PowerPoint slides.

Learn to work with multiple projects and to split tasks and share resources. In this program you will manage project schedules, format reports or project views and customise the Microsoft Project environment. If you are familiar with Project, but have problems applying it to your specific project needs or if you need to resolve project difficulties, you will benefit from this program.

This program highlights the concepts of project management and introduces Microsoft Project’s key features of how to set up a schedule and a resource pool, how to assign resources to tasks and how to track a project.

This program examines Microsoft Project’s ability to store custom data and to prepare the data for presentation to clients and other stakeholders using customised views and reports.

A vast majority of projects that suffer cost and time overruns (overruns that are not due to external dependencies) do so because they lack professional scheduling. Professional scheduling means understanding the agreed scheduling method such as Critical Path Method (CPM), and efficiently using a scheduling tool to build the schedule model. It also means tracking the variance between planned versus actual performance and deriving suitable metrics.

Planning is fundamental to the success of your project. It’s vital the execution of the plan is tracked, monitored and controlled. Microsoft Project allows you to take a snapshot of the project plan, to capture actual performance and to compare actuals against the baseline. From this you can analyse the progress and status of your project and forecast the project performance using a technique called Earned Value Management (EVM). This program teaches participants how to use these advanced tracking techniques.

Creating clear diagrams and illustrations is easy with Microsoft Visio. This program shows how to use Visio's drawing tools and stencils to create simple flowcharts, organisation charts, network diagrams and floor plans. It explains how to manipulate drawings and how to add text or hyperlinks. If you have some computing skills but have little or no experience with Visio, this program is right for you.

Using Microsoft Word efficiently will help you create good looking documents quickly. This program develops essential Word skills needed to create, edit, format and print documents and explores many of the most important features of the program. If you have some computing skills, but have little experience with Word or are new to Word, this program is right for you.

This program introduces tables and text columns and shows how to insert images or create simple diagrams. You will learn how to copy text or graphics from other programs and how to send personalised letters and emails to a large group of people using mail merge. If you have used Word for some time and need to use these features, this program is for you.

Give your documents a more professional look by applying correct and clear formatting. This program introduces the necessary formatting features and teaches you trouble-shooting skills to apply when formatting goes wrong. Learn to work with section breaks and how to add headers and footers to multi-page documents. If you have used Word for some time and struggle with formatting skills, this program is ideal.

Well-designed documents represent and showcase your organisation and can have a great impact. This program introduces you to important design ideas and principles and shows you techniques for effective document design using text, graphics and other visual elements. During the program participants will use Microsoft Word, but you can apply the design concepts you will learn to documents created in any software program.

This program is all about time-savers in Microsoft Word. It shows how to automate standard documents and how to create your own shortcuts for frequently used tasks which you then can add to your toolbar or ribbon. Learn how to work with Autotext or Quick Parts and how to use Macros and Fields. This program is for you, if you are a confident Word user.

Working with long documents in Microsoft Word can be a challenge. We will show you how to format documents quickly and consistently, how to add numbered headings, create a table of contents, an index, table or figure captions and cross-references. Learn how to avoid formatting problems when copying text between different documents. To benefit from this program, you should have a sound knowledge of Word.

This program introduces the visualisation layer of Microsoft’s Power BI Desktop called Dashboards. This report creation feature provides the means of creating reports that provide dynamic perspectives and insight into your data.