Business & AdministrationEnquire now
About the Course
This short course will teach you to prepare, develop, and automate spreadsheets. This includes determining specifications for spreadsheets, utilise spreadsheet design software functions and formulae, link spreadsheets, format cells, test formulae, develop and use templates to ensure consistency of design and layout for forms and reports, create and use macros to automate spreadsheet automation, and create graphs with labels and titles from numerical data contained in a spreadsheet file.
This course also teaches you to organise personal work environment in accordance with ergonomic requirements, identify organisational and task requirements of data entry, storage, output, reporting, and presentation requirements, as well as to apply strategies as well as energy and resource conservation techniques to plan work activities.
This course can be taken as part of the Certificate IV in Accounting and Bookkeeping. If you would like to undertake this course as part of the online accounting course, please speak to one of our Student & Administration Support Managers prior to enrolling to find out more.