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: 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…