Elearning - Create and use spreadsheets

This unit describes the performance outcomes, skills and knowledge required to correctly create and use spreadsheets and charts through the use of spreadsheet software. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement.

This unit applies to individuals who perform a range of routine tasks in the workplace using a limited range of practical skills and fundamental knowledge of creating spreadsheets in a defined context under direct supervision or with limited individual responsibility.

What will you achieve from this course?

• Creating simple charts
• Designing spreadsheets
• Formatting
• How to use cell-based formulae
• Producing spreadsheet functions
• Develop skills and knowledge to create your own spreadsheets using Microsoft Office Excel

Career Pathways

• Administrative/Office Assistant
• Payroll Clerk
• Information Officer
• Customer Service Officer
• Accounts Clerk
• Receptionist
• Secretary
• Personal Assistant

This is an elective unit for the qualification BSB20107 Certificate II in Business

How to gain your qualification faster

Recognition of Prior Learning (RPL) is “the acknowledgement of the skills and knowledge” that you have gained through previous studies, work and life experiences. If RPL is granted, this will mean that you will not have to complete the study or assessments for a unit or units of competency.

RPL (Recognition of Prior Learning) »

How long does this short course take?

Choosing to study online allows you to study at a pace that suits your lifestyle.

Help with the cost of your learning

You may be eligible for financial assistance as this course is approved for Centrelink student payments. Please contact your nearest Centrelink office to discuss your eligibility. AOT's Centrelink registration number is 4P727.