Code:
0417EXCEL3
Course Type:
Short Course
Cost:
$280.00
Study Mode:
On Campus
Times:
9.00am-4.00pm
Location:
Morwell
Course Overview
This course will expand on your intermediate skills in Microsoft Excel and teach you advanced functions of the program.
- Modify Excel options
- Protect data in worksheets and workbooks
- Import data into Excel and export data from Excel
- Use data linking to create more efficient workbooks
- Group cells and use outlines to manipulate the worksheet
- Create summaries in your spreadsheets using subtotals
- Use the Data Consolidation feature to combine data from several workbooks into one
- Create, use and modify data tables
- Create and work with scenarios and the Scenario Manager
- Understand and create simple pivot tables
- Construct and operate pivot tables using some of the more advanced techniques
- Create and edit a pivot chart
- Use advanced filters to analyse data in a list
- Use a variety of data validation techniques
- Create and use a range of controls in a worksheet
- Share workbooks with other users
- Create recorded macros in excel
Course Dates
Qualifications and Recognition
Upon completion of this course students will receive a Statement of Participation.Career Opportunities
- Office administration
Opportunities for Further Study
N/A
Further Information
Course and Entry Requirements
Not Applicable
Pre-requisites
Not Applicable
Online requirement
Not Applicable
Fees
Course Cost
$280.00Materials Fees
Not Applicable
Specialist Course Information
N/A
Placement
Not ApplicablePathway to Industry Licence
Material and Equipment supplied by students
Not Applicable
Student Services
Support is available for students at every stage of the study journey. Please speak to any of our friendly reception or teaching staff.Recognition of Prior Learning
Many TAFE Gippsland courses offer Recognition of Prior Learning (RPL). Click to learn more about RPL and how it can benefit you.Course Structure
Course Modules
Assessment
Not Applicable