Outlook: What’s New?
A course aimed at those requiring knowledge of new features in the Microsoft 365 version of Outlook. The topics are:
Course Category: NECS
Excel: How to Cleanse Raw Data
Raw data often requires cleansing to make it meaningful, useful and usable. This course is for those requiring an understanding of the techniques available to…
Excel: Introduction to XLOOKUP
This course provides a demonstration of the XLOOKUP function which can be used in place of the functions VLOOKUP and HLOOKUP, both of which have…
Excel: Introduction to Data Validation techniques
This course provides an understanding of how Data Validation can be applied and then used to control what values can be entered into a cell.…
Excel: Conditional Formatting
Conditional Formatting is a great way to quickly visualise data in a spreadsheet. This course is for those requiring an understanding of how Conditional Formatting can be…
Excel: Introduction to Creating Charts
This course provides an understanding of the processes behind the creation of charts to graphically represent data. The topics are:
Excel: Introduction to Logical Functions
This course provides an introduction to the most commonly used logical functions. The topics are:
Excel: Introduction to Formulae and Functions
This course is for those requiring an understanding of formulae construction within Excel. The usage of the functions SUM, AVERAGE, MAX, MIN, COUNT and TODAY…