Not sure what career to choose? Contact us
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
There are no formal entry requirements for this course
Excel User, Administration Officer
A TAFE NSW Certificate IV or Diploma could give you up 6 to 12 months advanced standing in a university degree and some Advanced Diplomas offer even more credit.
Choosing a TAFE to University Pathway at North Coast TAFE is a great way to get practical ‘job ready’ skills and then gain entry to a university at an advanced stage.
More information can be found on our TAFE 2 uni page on our website.
Why study something again if you already have the skills and knowledge? Recognition of Prior Learning (RPL) is about helping you get your qualification faster and getting you to where you want to be!
Working with one of our RPL assessors we’ll review your life and work experiences as well as any previous study you may have done to confirm just what we can match up with your current course of study.
Note: Some short, licensing or compliance courses, eg Food Safety for Supervisors or First Aid are not granted RPL as demonstrated competency is required by regulatory authorities.
Find out more about RPL at North Coast TAFE
Thank you for your interest in this course. To register your interest, contact us.
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.
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.