Advanced Microsoft Excel

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 Code

0417EXCEL3

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