Home · Courses

Course Type





Course Categories

















Clear All

Virtual Class - Excel: Advanced Filters for Databases and Lists

Learn to use Advanced Filters in Excel  to summarise and analyse large data lists and complex data sets.
Duration: 90 minutes virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and sorting and filtering simple data lists
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

 

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Charts and Graphs

Learn how to display Excel data graphically using a variety of compelling charts.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Collaboration and shared workbooks

Learn to share and co-author Excel workbooks and collaborate with team members online.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and charts
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver

Learn how to use Scenario Manager, Goal Seek and Solver to perform complex spreadsheet modelling and how to quickly analyse options and make better decisions.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

 

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Formulas for financial analysis

Learn to use Excel formulas that work on financial data. Financial functions are used to calculate many finance related operations including loan repayments, depreciation of assets and rates of return on investments.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with formulas in Excel
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Excel: Formulas for more complex adding and multiplying

Learn to use Excel Functions for complex mathematical operations. Math functions are used for many mathematical operations including adding up totals, multiplying values and rounding numbers.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with formulas in Excel
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and charts
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Power Pivot and Power View

Learn to use Excel Power View and Power Pivot to connect to, analyze and visualize massive amounts of data.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and Pivot tables
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Excel: Quick viewing and printing tips

Learn tips and tricks for viewing and printing Excel data effectively and efficiently.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Top ten tips

Learn ten essential tips and shortcuts that will dramatically improve the way you use Excel.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Office 365: Beyond the basics

Learn about Office 365 collaboration tools and services including SharePoint, Teams, Planner, Delve and Sway. The session will provide an overview of how these cloud based applications and services can be used to increase productivity through smarter team communication, collaboration, and mobility.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Office 365
Versions: This course is suitable for Office 365 for Business

Virtual Class - Office 365: Getting started

Learn how to get started with the core Office 365 applications and services. The session will focus on using Office 365 in the cloud, on the desktop and on mobile devices with an emphasis on how to get up and running with the core office applications.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Office 365 for Business

Virtual Class - Office 365: OneDrive

Learn how to use OneDrive for Office 365 to share files with colleagues, upload and sync files to the cloud and work on your files from any location.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Office 365
Versions: This course is suitable for OneDrive with Office 365 for Business

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: Basic familiarity with Office 365
Versions: This course is suitable for OneNote with Office 365 for Business

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: Basic familiarity with Office 365
Versions: This course is suitable for Planner with Office 365 for Business

Virtual Class - Office 365: SharePoint Online

Learn how to use SharePoint Online with Office 365 to create Sites that enable teams to share content and collaborate online.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Office 365
Versions: This course is suitable for SharePoint Online with Office 365 for Business

Virtual Class - Office 365: Sway

Learn how to use Sway with Office 365 to create and share engaging, interactive online presentations, reports and stories.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: Basic familiarity with Office 365
Versions: This course is suitable for Sway with Office 365 for Business

Virtual Class - Office 365: Teams

Learn how to use Teams with Office 365 to create customisable, chat-based team workspaces for information and file sharing and for collaboration on team projects and events.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: Basic familiarity with Office 365
Versions: This course is suitable for Teams with Office 365 for Business

Virtual Class - Office 365: Yammer

Learn how to use Yammer with Office 365 as a private microblogging and collaboration platform for enterprise social networking.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: Basic familiarity with Office 365
Versions: This course is suitable for Yammer with Office 365 for Business

Virtual Class - Power BI Dashboards

Learn to use Power BI Desktop - a suite of business analytics tools - to analyse data and share insights. Create dashboards to monitor your business with rich, interactive reports and visual analytics.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and Pivot tables
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

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 tot he next during your presentation.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with PowerPoint
Versions: This course is suitable for PowerPoint versions 2010, 2013 and 2016

Virtual Class - PowerPoint: Creating your first slide show presentation

Learn how to create a dynamic, engaging slide show presentation using PowerPoint.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: Basic familiarity with Windows
Versions: This course is suitable for PowerPoint versions 2010, 2013 and 2016

Virtual Class - PowerPoint: Images, tables, charts and shapes

Learn how to insert and use images, tables, charts and shapes to improve the appearance and effectiveness of your PowerPoint presentation.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with PowerPoint
Versions: This course is suitable for PowerPoint versions 2010‚ 2013 and 2016

Virtual Class - PowerPoint: Top ten tips

Learn ten essential tips and shortcuts that will dramatically improve the way you use PowerPoint.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for PowerPoint versions 2010‚ 2013 and 2016

Virtual Class - Project: Lesson 1 Creating a project

Learn how to use MS Project to create and manage projects. This first lesson will cover the essentials skills for creating and saving your first project file. This is the first lesson of a four lesson course.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: Basic familiarity with Windows applications
Versions: This course is suitable for Project versions 2010‚ 2013 and 2016

Virtual Class - Project: Lesson 2 Scheduling tasks

Learn how to use MS Project to create and manage projects. This second lesson will cover the essentials skills for entering tasks and scheduling. This is the second lesson of a four lesson course.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Participants must have completed Project: Lesson 1 Creating a Project
Versions: This course is suitable for Project versions 2010‚ 2013 and 2016

 

Virtual Class - Project: Lesson 3 Resources, materials, costs and constraints

Learn how to use MS Project to create and manage projects. This third lesson will cover the essentials skills for managing resources, materials, costs and constraints associated with a project. This is the third lesson of a four lesson course.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Participants must have completed Project: Lesson 2 Scheduling tasks
Versions: This course is suitable for Project versions 2010‚ 2013 and 2016

Virtual Class - Project: Lesson 4 Tracking and reporting

Learn how to use MS Project to create and manage projects. This last lesson will cover the essentials skills for tracking and reporting on the progress of a project. This is the fourth lesson of a four lesson course.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Participants must have completed Project: Lesson 3 Resources, materials, costs and constraints
Versions: This course is suitable for Project versions 2010‚ 2013 and 2016

Virtual Class - Skype for Business

Learn how to use Skype for Business to send and receive instant messages, communicate with contacts and conduct online meetings..
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Skype for Business

Virtual Class - Visio: Lesson 1 Getting started

Learn how to use MS Visio to create a range of business diagrams. This first lesson will cover the essentials skills for navigating Visio, working with stencils and creating basic Visio shapes. This is the first lesson of a four lesson course.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: Basic familiarity with Windows applications
Versions: This course is suitable for Visio versions 2010‚ 2013 and 2016

Virtual Class - Visio: Lesson 2 Shapes, connectors and containers

Learn how to use Visio to create a range of business diagrams. This second lesson will cover the essentials skills for formatting shapes, working with connectors and working with containers. This is the second lesson of a four lesson course.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Participants must have completed Visio: Lesson 1 Getting started
Versions: This course is suitable for Visio versions 2010‚ 2013 and 2016

Virtual Class - Visio: Lesson 3 Working with text and pages

Learn how to use Visio to create a range of business diagrams. This lesson will cover the essentials skills for working with text and pages. This is the third lesson of a four lesson course.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Participants must have completed Visio: Lesson 2 Shapes, connectors and containers
Versions: This course is suitable for Visio versions 2010‚ 2013 and 2016

Virtual Class - Visio: Lesson 4 Org charts and flow diagrams

Learn how to use Visio to create a range of business diagrams. This lesson will cover the essentials skills for creating organisation charts and workflow diagrams. This is the fourth lesson of a four lesson course.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Participants must have completed Visio: Lesson 3 Working with text and pages
Versions: This course is suitable for Visio versions 2010‚ 2013 and 2016

Virtual Class - Word: Collaborating on documents with Track Changes

Learn how to collaborate on a Word document with co-workers by using Track Changes and other reviewing and document protection tools.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010‚ 2013 and 2016

Virtual Class - Word: Creating long documents using Master Documents

Learn how to compile a large document in Word with a Table of Contents by using a Master Document and Sub Documents.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010, 2013 and 2016

Virtual Class - Word: Creating long documents using Section breaks

Learn how to use Section breaks to create long documents with different page layouts and alternating headers and footers.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010‚ 2013 and 2016
 

Virtual Class - Word: Creating long documents using Styles

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.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010, 2013 and 2016

Virtual Class - Word: Mastering Fields

Learn how to use Fields to make your Word documents dynamic. You will learn about Formula fields, Date and Time fields and REF fields and learn how to use FILLIN fields to capture user input through pop-up dialogs.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010‚ 2013 and 2016

Virtual Class - Word: Mastering images and shapes

Learn how to insert and edit images into your Word documents and how to illustrate documents with shapes and drawn objects.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010‚ 2013 and 2016

Virtual Class - Word: Mastering Macros

Learn how to save time by automating routine tasks and processes in Word using the Macro recorder.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010‚ 2013 and 2016
 

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 groups of recipients.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010‚ 2013 and 2016

Virtual Class - Word: Mastering Tables

Learn to easily insert, edit and format Tables in Word documents to improve readability and document effectiveness.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010‚ 2013 and 2016

Virtual Class - Word: Mastering Templates

Learn how to save time by creating re-usable document templates and by using the built-in templates provided in Word.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010, 2013 and 2016

Virtual Class - Word: Top ten tips

Learn ten essential tips and shortcuts that will dramatically improve the way you use Word.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Word
Versions: This course is suitable for Word versions 2010, 2013 and 2016