Excel - Intermediate

State ID: MAC17
Share this course on your social media page

Description

This unit describes the skills and knowledge required to develop spreadsheets through the use of both cloud-based and non-cloud based spreadsheet applications.

It applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision. These individuals are generally required to have intermediate knowledge and understanding of a number of spreadsheet applications

What will you learn in this course?

  1. follow correct ergonomic, conservation requirements and relevant organisational and statutory requirements
  2. design spreadsheets that address a range of data and organisational requirements
    1. documents that align to document purpose and appropriate to target audience
    2. use software functions, graphics and support materials to create spreadsheets that adhere to organisational requirements relating to style and presentation
  3. key elements of formatting of spreadsheets appropriate to workplace documents, including the ability to calculate:
    1. sum totals
    2. averages
    3. counts of values
    4. formulas and functions with:
      1. addition, subtraction, division, multiplication
      2. brackets
    5. create and modify intermediate-level charts that analyse the dataset.

 

Certification

On successful completion of this course, students will receive a statement of attainment for the following nationally accredited unit.
   BSBITU314 - Design and produce spreadsheets

Non concession: $102.60

Concession: $34.40

 

What will you need to know before the course?

Students should have some experience using spreadsheets to enter data, perform basic tasks e.g. help functions, simple formatting and create simple charts.

If you have language, numeracy or literacy concerns, please discuss them with us before the course starts.

Study options and next steps

Click on your preferred study mode below to get started with your application or enrolment.

Details
Duration 3 hr sessions x 3 weeks
When Date: Register Your Interest
Time: 9.30 am - 12.30 pm
Where Albany

Get help

Please note This form is only for course enquiries. If you would like to apply, please refer to the 'How to apply' tab above.