Duration
1 x 3 hour class
Schedule
Upcoming Courses -
Please 'Register your Interest' to be notified of more upcoming dates as they are published.
What You Learn
This course is ideal for students who understand the basics of Microsoft Excel and need to extend their knowledge and application. Topics covered include:
- Development of formulas
- Macros
• Go to Special
• Pivot tables
• Named Ranges
• Drop down lists
• Conditional formatting
• Excel tables for data analysis
• Using Sparklines
• Text to column
What You Get
Students extend their knowledge and application of Microsoft Excel. Students will be provided with a digital resource summary of learning for future reference.
Non Accredited Training
This course is non-accredited which means no Unit of Competency is completed, no assessment is required and no Statement of Attainment will be issued. Students will receive a Certificate of Attendance to acknowledge their participation.
Materials to Bring
Photo identification (including your date of birth).
Pen and Notepaper
Dress Code
Casual
Description
This course is ideal for students who understand the basics of Microsoft Excel and need to extend their knowledge and application. Topics covered include:
- Development of formulas
- Macros
- Go to Special
- Pivot tables
- Named Ranges
- Drop down lists
- Conditional formatting
- Excel tables for data analysis
- Using Sparklines
- Text to column
Student Support
At South West TAFE we’re here to help you complete your studies happily and successfully.
From the moment you start thinking about course options until you finish, you’ll have access to a range of student support options, covering enrolment, education, social and personal issues, including:
-
Education Pathway Officers who can help you with information sessions, fee payment options, TAFE and university pathways, career pathways and campus tours
-
A DHHS registered Disability Support Team
-
Koorie Liaison Officer
-
Student Wellbeing Officer supporting your personal and social needs
-
Library and Research Centre
-
Bookshop supplying a range of textbooks and stationery
- Student Learning Support including literacy and numeracy