This course in intended for anyone who has a basic understanding of Excel and needs to enhance their proficiency in data analysis and in planning, producing and using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

Topics include:

• Go to special option

• Named range

• Drop down lists

• Conditional formatting

• Create excel table to sort, filter and analyse data

• Use the idea button