Search our courses

Microsoft Excel Charts – Masterclass

Course Duration – 1 day Course Subjects Excel Charting Concepts Understanding chart terminology – Identifying chart elements (such as like plot area, chart area, gridlines, and legends) – Selecting the right chart type – Understanding the Ribbon and the Design, Layout, and Format tabs Creating Basic Charts Quickly – Selecting data to display as a … Continued

Microsoft Excel – Power Query

Course Duration – 1 day Course Subjects:- Overview Power Query Editor and basic transformations Quick insights and data quality & distribution Connecting to multiple data sources Load data into Excel from Multiple Sources such as SharePoint, csv, Web, and even Email Refresh Data and Power Query Refresh options Common Transformations Split Columns (e.g. by delimiter, … Continued

Microsoft Power BI – Intermediate – 2 days

Course Duration: 2 days Prerequisites: It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops as well as Power Bi Introduction, or have equivalent experience.  It is expected that you have a good understanding of Excel functions such as IF and VLOOKUP functions, as well as Defined Names, Importing … Continued

Microsoft Power BI – Introduction – 1 Day

Course Duration:  1 day Overview: With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. This allows you to then produce detailed reports through a comprehensive range of visualizations. The reward is to then be able to share those reports with … Continued

Microsoft Power BI – Data Modelling with DAX

Course Duration: 1 day Overview: DAX, or Data Analysis Expressions, is the language that’s used to create formulas for Power BI that extend our data model. DAX gives us the ability to create additional information at runtime so that we can quickly and easily generate new information beyond the information that’s in our model already. … Continued

Microsoft Power BI – Advanced – 2 Days

This 2-day course is aimed at experienced Power BI users. It delves into the use of Azure, as well as the use of advanced DAX formulas and data modelling.  Its focus is on using Power Query, Workflows and Custom Advanced Visuals. Advanced DAX formulas and techniques Advanced Data Modelling Using Power Query Pre-aggregating data Merging … Continued

Microsoft Power BI – Introduction – 2 Days

Overview –  This two-day course goes beyond just the basics and includes a comprehensive look at using Power BI Desktop, as well as Microsoft’s Power BI Pro online service. With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. This allows … Continued

Microsoft Office – Conversion from 2010 to 2016

Target students Existing users of 2010 who are converting to Office 2016. Course Content General Office Changes Navigate the Microsoft Office 2016 screen Find the commands they commonly use Customise the Quick Access Toolbar and Ribbon Be aware of the new features in Excel, Word, PowerPoint and Outlook Create charts and SmartArt graphics Save files … Continued

Microsoft Visio 2016 – Introduction

Course Summary In this course, you’ll learn fundamental skills while creating several types of diagrams using Microsoft Office Visio Professional. You will create a directional map, a block diagram, a basic and a cross-functional flowchart, an organization chart, and an office layout. As you create these drawings, you will learn techniques to drag and manipulate … Continued

Microsoft Visio 2016 – Intermediate

Course Summary In this course, you’ll learn intermediate skills using Microsoft Office Visio Professional, including creating organisational charts, network diagrams, customised charts and graphs, and cross-functional flowcharts.