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…
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…
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…
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.…
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…
This course provides an understanding of the processes behind the creation of charts to graphically represent data. The topics are:
This course provides an introduction to the most commonly used logical functions. The topics are:
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…
A beginner’s guide to the spreadsheet application of Microsoft Excel.
Please confirm you want to block this member.
You will no longer be able to:
Please allow a few minutes for this process to complete.