Home · Courses

Please select the category you are interested in:

Course Type

Course Categories

Clear All

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

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.

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.

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: 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: 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 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: 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: 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: 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 - 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 - 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: Styles and Tables of Content

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.

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.