Intermediate Excel Skill Set
Complete the Intermediate Excel skill set
This unit describes the skills and knowledge required to develop spreadsheets through the use of both cloud-based and non-cloud based spreadsheet applications.
CampusesEsperance. Katanning.
When All year round.
Study Mode On Campus.
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?
- Follow correct ergonomic, conservation requirements and relevant organisational and statutory requirements
- Design spreadsheets that address a range of data and organisational requirements
- documents that align to document purpose and appropriate to target audience
- use software functions, graphics and support materials to create spreadsheets that adhere to organisational requirements relating to style and presentation
- Key elements of formatting of spreadsheets appropriate to workplace documents, including the ability to calculate:
- sum totals
- averages
- counts of values
- formulas and functions with:
- addition, subtraction, division, multiplication
- brackets
- create and modify intermediate-level charts that analyse the dataset.
On successful completion of this course, students will receive a statement of attainment for the following nationally accredited unit BSBTEC302 Design and produce spreadsheets.
Select your preferred campus and apply
All year round, 2024
Details
Units
National ID | Unit title |
---|---|
BSBTEC302 | Design and produce spreadsheets |
Details
Units
National ID | Unit title |
---|---|
BSBTEC302 | Design and produce spreadsheets |