Computer Skills

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 course 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 course is for you.

This course 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 course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.

This course 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 course.

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 course 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 course is for you.

This course 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 course 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 course 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 course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.

This course 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 course 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.

Transform raw data into useable visualisations to gain more comprehensive insight into your organisation.  

If you have attended Power BI Desktop - Level 1, this course will build on your existing knowledge and introduce you to more advanced DAX (Data Analysis Expressions). 

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 course 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 course 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 course.

This course 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 course 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 course teaches participants how to use these advanced tracking techniques.

Creating clear diagrams and illustrations is easy with Microsoft Visio. This course 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 course is right for you.

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

Give your documents a more professional look by applying correct and clear formatting. This course 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 course is ideal.

Well-designed documents represent and showcase your organisation and can have a great impact. This course 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 course participants will use Microsoft Word, but you can apply the design concepts you will learn to documents created in any software program.

This course 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 course 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 course, you should have a sound knowledge of Word.

This course 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 course is for you.

Transform raw data into useable visualisations to gain more comprehensive insight into your organisation.  

If you have attended Power BI Desktop - Level 1, this course will build on your existing knowledge and introduce you to more advanced DAX (Data Analysis Expressions).