,
Home | Short courses | SPREADSHEETS - The Next Level

SPREADSHEETS - The Next Level

Yes
State ID: BSBITU202

 

Description

This course is for anyone who is already using Microsoft Excel and wants to know more about the powerful features of the package for work or personal use.
Gain the skills necessary for spreadsheet design and performing complex work sheet functions.
The course covers:
    spreadsheet design
    working with multiple worksheets – linking; consolidating; importing; embedding
    lists – conditional sorting; filtering; subtotalling; pivot tables
    functions – statistical; financial; date and time; customising dates and number formats; logical and lookup formulas
    conditional formatting
    splitting the screen and freezing panes
    repeating headings on multiple pages
    printing – scaling to fit; row and column headings; headers and footers; printing formulas
    validating and protecting data
    charts

Entry requirements

It is a requirement that participants have either completed the Excel Introductory course or have basic Excel skills prior to completing this course.

Certification

On successful completion of this course, students will receive a statement of attainment for the following nationally accredited units:

    BSBITU202 Create and Use Spreadsheets

Pathways to further study

BSB20115 - Certificate II in Business

Pre-requisites

Study pathway

Job opportunities

Pre-requisites
Study pathway
Job opportunities

Delivery location, important dates and study options

Overview

Outline

Fees and charges

About the lecturer

Other requirements

Overview

Course Overview

Where Albany
Katanning
Duration

Albany Campus
Date: Register Your Interest
Time: To be advised
Duration: 2 Sessions

Katanning Campus
Date: Register Your Interest
Time: To be advised
Duration: 2 days

How
When
Outline
Fees and charges

Non-Concession: $104.10
Concession: $35.90
Commercial / International: $ to be advised

School age students
Students who would normally be attending year 12 or below in the current calendar year will be eligible to enrol at the commercial / international rate for this course.

International students
This courses isn’t available to Visa 500 International Students.
For information on international courses, please follow this link to the TAFE International WA website
Other visa holder students
All other visa holders (i.e 457, 300, 485, 489, 496) contact either South West or Great Southern Campuses to confirm your eligibility;
South West Campuses    studentservices@srtafe.wa.edu.au    0417 937 894
Great Southern Campuses    studentsupport@srtafe.wa.edu.au    1800 675 781

About the lecturer
Other requirements
Enquire now
Call us: 1800 621 445
Email us

Course enquiry

Application information available here.

For application help please contact your local campus.

 

Entrance Requirements

School Leaver Non-School Leaver AQF

Application information available here.

For application help please contact your local campus.

 

Entrance Requirements

School Leaver Non-School Leaver AQF

Qualification level

Clean up clone

Link to photo for PDF:

Photo override if needed:

TAFE title:

Course title:

National and state ID:

About this course:

Overview:

Entrance requirements:

Entrance requirements additional text:

Prerequisites

Study pathway

Job opportunities

Important information

Fees and charges

How to apply

Print units tab

Units

Generic info:

Page last updated May 21, 2019