Intermediate Microsoft Excel

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 Code

0417EXCEL2

Course Type

Short Course

Study mode

On Campus

Duration

1 day

Location

Morwell

Times

9.00am-4.00pm

Career opportunities

  • Office administration

Opportunities for further study

N/A

Qualifications and Recognition

Upon completion of this course students will receive a Statement of Participation.

Placement

Not Applicable

Specialist Course Information

N/A

Material and Equipment Supplied by Students

Not Applicable

Entry Requirements

Not Applicable

Recognition of Prior Learning (RPL)

Many TAFE Gippsland courses offer Recognition of Prior Learning (RPL). To find out more visit the TAFE Gippsland website or contact us to discuss your option.

Course cost

For the course cost please visit the TAFE Gippsland website or cal 1300 133 717.
 

TAFE Gippsland has made every reasonable effort to ensure the information contained in this publication is current at the time of publishing. For updated information go to tafegippsland.edu.au or call 1300 133 717. Training is delivered with Victorian and Commonwealth Government funding. TAFE Gippsland reserves the right to alter this information and/or withdraw courses listed herein. © TAFE Gippsland 2024. National Provider Number 0417

TAFE Gippsland has made every reasonable effort to ensure the information contained in this publication is current at the time of publishing. For updated information go to tafegippsland.edu.au or call 1300 133 717. Training is delivered with Victorian and Commonwealth Government funding. TAFE Gippsland reserves the right to alter this information and/or withdraw courses listed herein. © TAFE Gippsland 2024. National Provider Number 0417