The skills and knowledge acquired in ICTICT105 Operate Spreadsheet Applications are sufficient to be able to use spreadsheet applications, including creating spreadsheets, formatting data, incorporating charts and objects, and printing spreadsheets. It applies to individuals who perform a range of routine tasks in the workplace under direct supervision or with limited responsibility.

At the completion of this course you should be able to:

• create new workbooks in Microsoft Excel
• understand, create and work with formulas and functions
• work with workbooks created in Microsoft Excel
• copy and paste data in Excel
• save workbooks in a variety of formats
• use font formatting techniques
• align the contents of cells in a number of ways
• create and work with headers and footers
• insert pictures or create charts in a workbook
• print data from workbooks
• customise Microsoft Excel workbooks
• apply a variety of page setup techniques
• modify Excel options