Computer Skills

This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.

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 Intermediate Excel training course provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills.

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.

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.

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.

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 and inserting tables, pictures and diagrams. You will learn how to work with section breaks, headers, footers and troubleshooting skills for when formatting goes wrong. You will also learn to send emails and letters to large groups of people using mail merge. If you have used Word for some time and want to improve the presentation of your documents, this course is for you.

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.

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

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