Download Info Pack

Submit your details below to get your AOT info pack instantly.

BSBITU402 Develop and use complex spreadsheets

BSBITU402 Develop and use complex spreadsheets


Price:

$210.00

NRT logo

Select Payment Option:



TOTAL: $210.00

BSBITU402 Develop and use complex spreadsheets

$210.00

Quantity
TOTAL: $260.00 over 1 month
Initial Payment: $100.00
Succeeding Payments: $80.00 X 2 fortnightly payments

Units of Competency

1

Course Access

3 months access to online course

Support Hours

7am - 9pm AEST (Mon - Fri)

Why Study with AOT?

  • Over 15 years of delivering qualifications online
  • Dedicated eLearning and LMS development team
  • Courses developed in-house by industry experts
  • Courses written specifically for online delivery
  • Professional and industry skilled trainers
  • Rated ‘Excellent’ on independent review platform TrustPilot

Simulated Workplace

Full access to our unique virtual company that brings your course material to life.

Delivery Mode

100% online, available 24/7
No classroom attendance or work placement

Trainer Support

One-on-one unlimited

ALL SHORT COURSES ON SALE

Special Holiday Offer

USE DISCOUNT CODE: AOT10

CHOOSE YOUR COURSE

*Use coupon code AOT10 to receive 10% off when you pay upfront. Offer is not applicable for payment plans. Offer ends 31/12/20.
See Terms and Conditions for further details.

This is a single unit course.

This unit describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.

It applies to individuals employed in a range of work environments who require skills in creation of complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise, or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.

Upon successful completion of the unit you will be issued with a Statement of Attainment in partial completion of the BSB40215 Certificate IV in Business.

BSBITU402 Develop and use complex spreadsheets

Upon successful completion of this unit, you will:

  • follow organisational and safe work practices including:
    • ergonomic requirements
    • energy and resource conservation techniques
  • adhere to organisational requirements for:
    • ensuring consistency of style, design and layout
    • saving and printing documents within designated timelines
    • naming and storing documents
  • adhere to identified or task requirements when producing documents including:
    • editing macros and automating some tasks
    • using appropriate templates
    • creating graphs to represent data
    • resolve issues by referring to user documentation and online help
    • use appropriate data storage options
    • evaluate tasks to improve efficiency
    • apply knowledge of functions and features of contemporary computer applications
    • communicate with relevant personnel

Demonstrate knowledge of:

  • advanced functions of spreadsheet software applications
  • the impact of formatting and design on presentation and readability of data
  • organisational requirements for ergonomics, work periods and breaks, and conservation techniques

You will be assessed for these units of competency using a variety of tasks to assess your understanding and skills. A virtual session means you will be one on one with your assessor either answering questions or taking part in a role play, just as you would do in any classroom, only we do it online.

All of our assessments are marked by your assessor within ten (10) working days following the day you submitted your work. You have three (3) attempts for each assessment task to achieve a satisfactory outcome (100% pass mark), with your assessor giving you detailed feedback following each submission.

The type of assessment used in each unit is listed below.

Unit Short Answer
Questions
Virtual
Session
Scenario
/Case study
Reports Assignment
/Project
BSBITU402 Develop and use complex spreadsheetsShort Answer QuestionsVirtual SessionScenario/Case study

We provide you with three (3) months to complete the course. There is no minimum timeframe for completion.

The course is self-paced so the hours of study vary from student to student and are influenced by many factors including the amount of time you are able to dedicate to your studies. That is why we give you three (3) months and all the support you need. The rest is up to you!

Requirements

There are no formal requirements. However, learners will need:
  • Sufficient language, literacy and numeracy skills to complete the course
  • Basic computer skills
    • Knowledge of common computing terms and word processing
    • Proficiency with web browser software and sending/receiving e-mail including e-mail with attachment
    • Familiarity with navigating the Internet
  • Meet technology requirements

Technology requirements

  • Operating System: Windows 7 or higher (recommended); MAC OS X 10.6 (Snow Leopard) or higher (recommended)
  • CPU: Min. of 2 GB of RAM, Min. of 2 GB of spare disk space is recommended
  • Processor: 2.0 GHz processor or higher (32-bit or 64-bit)
  • Monitor with at least 1024x768 screen resolution
  • Internet access: Minimum ADSL1 with a speed of at least 1.5Mbps
  • Valid personal email address
  • Speakers and microphone or headset
  • The latest version of Adobe Reader
  • Microsoft Office (Word, Excel, PowerPoint, Publisher) or similar software
  • Up-to-date web browser version

Support you can expect from AOT

Our focus is to provide the real-world skills and knowledge that you need to advance your career, fulfil your goals and achieve success in the workplace. No matter what course you choose, here at AOT you will receive the assistance and support that will help make your study time convenient, manageable and worthwhile. The benefit of studying with us is that you don't have to schedule your time to attend face-to-face classroom sessions. You can study at times convenient to you in your own home or anywhere that suits your learning style. To support you in your study we provide:

Live chat

Trainer support available whilst you are studying 7am – 9pm AEST (Mon to Fri).

Contact us form

Contact us at any time using the Contact us form found within your course to create support tickets.

Mentoring sessions

You can book unlimited appointments with a trainer to discuss the learning material, assessment expectations, or assessment feedback.

Virtual classroom sessions

This can be booked with your trainer for specific assessments.

Course induction

You are provided with a course induction tutorial and you may also request for a Learner Support Officer to personally take you through the sauceLMS and your course.

Help and Support

A section on your sauceLMS dashboard with useful links.

Student Frequently Asked Questions

Find answer to your questions quickly and easily using the FAQs.
You are not alone in your study with AOT!

Want to know more?

Try a Demo Get a Free Info Pack
X