Introduction to Microsoft Excel

This course will teach you basic Microsoft Excel skills including all of the basic functions of the program.

  • Create and work with a new workbook
  • Open and navigate within workbooks and worksheets
  • Make changes to data in a workbook
  • Understand and work with ranges in a worksheet
  • Copy and paste data in excel
  • Use the fill operations available to fill a data series
  • Move the contents of cells and ranges within and between workbooks
  • Understand, create and work with formulas and functions
  • Understand and use formula cell referencing
  • Use font formatting techniques
  • Align the contents of cells in a number of ways
  • Understand and use the number formatting features in excel
  • Format rows and columns in a worksheet
  • Work with elements that make up the structure of a worksheet
  • Sort data in a list in a worksheet
  • Filter data in a table
  • Print your workbook data
  • Create effective charts in Microsoft Excel
  • Obtain help for excel whenever you need it
  • Understand points to consider to avoid problems in your worksheets

Course Code

0417EXCEL1

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