×

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 Teams – Introduction

Course Summary Microsoft Teams is a chat-based workspace for groups of co-workers. Teams provides a single window workspace where team members can chat with instant messaging or video calls, make notes and share files instantly. By creating a ‘Team’, you will automatically be allocated a team Group, OneNote space, SharePoint Site and Plan – so … Continued

Adobe Photoshop

This course aims to provide a solid foundation in the use of Adobe Photoshop to edit and manipulate images for those who are new to the product.

Adobe InDesign

Duration of the Course:- 1 Day Overview of the Course This course aims to provide a solid foundation in the use of Adobe InDesign to create documents for those who are new to the product. Emphasis will be placed on applying practical techniques whilst ensuring the user develops an efficient working style.   Getting Started … Continued