Course Objective:

Rapid digitalisation and the growth of data have made analytical and quantitative skills some of the most important tools to improve productivity at work. By having the skill in Spreadsheets, you will be able to handle data accurately and produce precise work output regardless of your job responsibilities within the company. This course will equip you with the basic knowledge about the functions of Spreadsheets to ensure that you become a proficient user.

Course Content:

1. Work with spreadsheets and save them in different file formats
2. Choose built-in options such as the ‘Help’ function within the application to enhance productivity
3. Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
4. Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
5. Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
6. Format numbers and text content in a spreadsheet
7. Choose, create and format charts to communicate information meaningfully
8. Adjust spreadsheet page settings, check and correct spreadsheet content before finally printing spreadsheets