Microsoft Excel - Intermediate Level Two

TAFE PLUS Statement

Course information

About the course

Course Number: 160-25902V01

This course provides the skills and knowledge for individuals to perform digital literacy tasks using a personal computer and learn an intermediate level of knowledge for the Microsoft Excel software application.
Classroom environment with one desktop computer per participant and course notes will be provided.
Topics include:
* More on formulae (covered extensively in this course)
- Inputting formulae
- +/*-
- Using Brackets in formulae
- Autosum
- Copying formulae:relative addresses
- making components of a formula absolute
- isolating variables and making them absolute references in formulae
- percentages
- formulae across sheets
* Functions
- average, maximum, minimum and count functions and awareness of other functions
- the IF function
* Charts (graphs)
- Creating and customising charts
- Using Excel for database management
* Sorts
* Filters and customised filters
- Borders and shading
- Headers and footers
- Comments
- Freezing titles
- Replace and find

TAFE to Uni Pathway
Not available
  • What you'll learn

  • Entry requirements

  • Career opportunities

  • TAFE 2 uni pathways

  • Get credit for previous study and life experience

Other student services offered with this course

Counselling and career services
Disability support services
Libraries and information services

Study Modes

Thank you for your interest in this course. To register your interest, contact us.

Enquire about this course


North Coast TAFE offers a wide choice of courses, some that attract government subsidies and some that do not. The fees payable will vary, depending on your personal circumstances, your study history and the course you choose.

Calculate fees

Your government subsidised fee, and your eligibility for concessions, exemptions and scholarships, are all calculated and confirmed during the enrolment process.

The 2017 subsidised fees indicated on this page are indicative only and based on 2016 fees. The state government may make some small changes to fees and subsidies for 2017 enrolments and we will update our site if and when that happens.

Chat with us

Please give us some more information to get started.

Leave Customer Help a message

Sorry, live chat is not available at this time. Our office hours are 8am-8pm Monday - Thursday and 8am-5pm on Fridays.
Please leave a note with your email address and we will contact you as soon as we can.