-
MS Excel for Beginners - Online or In Person
This course covers the basics of MS Excel and is designed for users new to MS Excel.
Download the Online Course Outline here
-
MS Excel Intermediate - Online or In Person
This course is designed for users of MS Excel but who have had no formal training. This course covers Formulas, Basic Functions, Charts, Data Consolidation and Working with Lists,
Download Online Course Outline here
-
MS Excel Advanced - Online or In Person
This course is designed to follow-on from MS Excel Intermediate. Having already familiarised yourself with the most efficient way of performing everyday tasks, and having covered some intermediate topics, it is now time to build on that knowledge. Useful functions such as IF and Lookups are covered in addition to Pivot Tables & Pivot Charts and an Introduction to Macros.
Download the Online Course Outline here
-
Excel Development - VBA/Macros - Online or In Person
By the end of this course you should be confident to create procedures for controlling the behaviour and appearance of Excel spreadsheets, create procedures to automate repetitive office tasks such as formatting, copying and pasting between workbooks and entering formulas.
Download the Online Course Outline here
-
Excel - Introduction to Power Query / Get & Transform - Online
OVERVIEW
This course is an introduction to Power Query. Using Power Query (also known as Get & Transform in Excel), data can be imported, or a connection can be created to external data that can then be shaped and transformed as required. For example, a column can be removed, a data type changed, or tables merged to meet the requirements at the time. It is then possible to load the data into Excel in order to create charts and reports. The data can be easily refreshed ensuring that it is always up to date. -
Data Visualisation using MS Excel Dashboards - Online or In Person
This course is suitable for users who need to interpret and communicate large quantities of information clearly by summarising it into easy-to-read tables and graphs.
Prerequisites - Participants should have extensive knowledge of Excel to Intermediate/Advanced or equivalent experience.Download the Online Course Outline here
