Microsoft Office Courses

This course is aimed at users with prior Microsoft Office experience who now have access to Microsoft Office 365.

Anyone wanting to create powerful interactive dashboards, chart and a range of visualisations to display data in a user friendly way from a range of sources. 

This intermediate course is ideal for those seeking to create a solid dataset underlying Power BI's reports and dashboards.

This course has been developed for SharePoint Site Owners using Office 365 who are required to create and maintain content on a team site.

This course is recommended for SharePoint site owners working with SharePoint 2013 Server, SharePoint 2016 Server and SharePoint Online (as part of Office 365). Participants in our public courses use SharePoint 2013 Server to complete the training activities. However, the training manual provided discusses all versions and highlights any differences.

Become a power user by streamlining content across your site and creating custom forms and workflows.

This course has been developed for people wanting to create a simple database to enter and extract data, and create reports.

This course has been developed for Access users want to report on and manipulate data and improve their working knowledge of the product.

This course has been developed for the Access “Power User” who requires advanced skills in manipulating and presenting data in Access to create an application front-end for other users.

This basic Microsoft Excel 2016 course is ideal for beginners who want to learn how to produce spreadsheets, work with data and perform basic calculations.

Uutilise Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

Learn to utilise Microsoft Excel to perform complex calculations, represent data as a chart, and manipulate database lists.

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course, including working with named ranges. Basic knowledge of a PivotTable is advantageous.

This course has been developed for users who need to clean up imported data, or build models for other users.

This course has been developed for people wanting to use more complex functionality of PivotTables within Microsoft Excel, including the PowerPivot add-in which allows you to analyse multiple files.

Microsoft Excel VBA

This course has been developed for people wanting to learn the fundamentals of Microsoft Word to create professional correspondence and documents.

This course has been developed for people who want to learn time saving techniques when working with Microsoft Word such as styles and bullets and numbering.

This course has been developed for people who want to use the complex features of Word to work with long documents, create forms and use automation to limit repetitive tasks.

This course has been developed for people who need to create standardised documents, using character, paragraph and list styles, as well as setting up headers and footers, and creating a standardised template.

This course has been developed for people wanting to use PowerPoint to produce presentation materials for seminars, training sessions, presentations or workshops.

This course is ideal for the Microsoft PowerPoint 2016 “power user” who would like to acquire more skills in manipulating data and objects in PowerPoint.

This course has been developed for people who want to learn the basic concepts for creating flowcharts including timesaving techniques and shortcuts.

This Microsoft Project 2016 course is ideal for project managers, coordinators or team members who need to track projects electronically.

This course is ideal for people wanting to utilise the more advanced features of Microsoft Project 2016 to manage tasks and resources, as well as track and report on projects.

This course has been developed for people wanting to utilise the advanced features of Microsoft Project 2016 to manage complex projects.