Microsoft Excel - Advanced - Level Three

TAFE PLUS Statement

Course information

About the course

Course Number: 160-25901V01

This course provides the skills and knowledge for individuals to perform digital literacy tasks using a personal computer and learn an advanced level knowledge for the Microsoft Excel software application.
Classroom environment with one desktop computer per participant and course notes will be provided.

Topics include:
* Using Named Ranges
- Naming Ranges
- Inserting Names into Formulae
- Editing and Deleting names
* Functions
- Recap on Max, Min, Count, StDev, Avg functions
- If Function
- Nested IF formulae
- VLookup and HLookup function
- Date and Time functions
- Financial functions, PMT function, PV function
- INT function
* Formatting
- Customised formatting
- Conditional formatting
* Data Validation
- Using the data validation command to create a drop down list of options
- Other data validation options
* Summarising Options
- Grouping and outlining
- Creating Pivot Tables
- Rearranging fields and items
- Grouping items in a pivot table
- Tricks with Pivot tables
* Recording and Running Macros
- Recording macros
- Running Macros
- Press button spreadsheets
- Viewing and editing macros
* If Analysis (if time permits)
- Data tables
- 1 input cells and 2 input cells
- Scenario manager

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.