Code:
0417EXCEL2
Course Type:
Short Course
Cost:
$269.00
Study Mode:
On Campus
Times:
9.00am-4.00pm
Location:
Morwell
Course Overview
This course will expand on your knowledge of basic Microsoft Excel and teach you intermediate functions of the program.
- Use the fill operations available to fill a data series
- Use a range of techniques to work with worksheets
- Apply a variety of page set up techniques
- Apply borders to cells and ranges in a worksheet
- Use common worksheet functions
- Create more complex formulas and functions
- Create and use defined names in a workbook
- Apply a range of number formatting techniques to worksheet cells
- Apply conditional formatting to ranges in a worksheet
- Use goal seeking to determine the values required to reach a desired result
- Understand and use Excel’s Quick Analysis tool
- Create and work with tables
- Use a range of elements and features to enhance charts
- Select and change the format of objects in a chart
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
$269.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