Unit 4 - Spreadsheets
(Unit 4)

 This course requires an enrolment key

AIMS: To provide the student with an understanding of fundamental spreadsheet concepts, practical experience in spreadsheet design and implementation of the basic functions involved within spreadsheets.

OBJECTIVES: After completing the guide the user will be able to: · Work with spreadsheets and save them in different file formats · Choose built in options, such as the Help function, within the application to enhance productivity · Enter data into cells and use good practice in creating lists; select, sort, copy, move and delete data · Edit rows and columns in a worksheet; copy, move, delete and appropriately rename worksheets · Create mathematical and logical formulas using standard spreadsheet functions; use good practice in formula creation and be able to recognise error values in formulas · Format numbers and text content in a spreadsheet · Choose, create and format charts to communicate information meaningfully · Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets.

This course requires an enrolment key