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

Course study options
Campus  

Offered on 1 campus

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 available

Campuses

On-Campus Learning - Study at our place for all or some of your course and access the on-campus TAFE experience.

Fees

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.

To view accurate fees for your course, please choose your study option below;

Select your study option