Home | Short courses | MICROSOFT EXCEL - INTERMEDIATE

MICROSOFT EXCEL - INTERMEDIATE

State ID: G9230

 

This course assumes the learner has the skills and knowledge required to create, edit, print and chart simple worksheets including understanding ranges and the copying process. It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment. You’ll learn to use a variety of techniques including formulas and functions, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks

Specifically you will learn about:
•    use the fill operations available to fill a data series,
•    use a range of formula techniques,
•    use a range of logical functions,
•    apply a range of number formatting techniques to data,
•    apply conditional formatting to ranges in a worksheet,
•    apply borders to cells and ranges,
•    work with various elements of a worksheet,
•    use a range of techniques to work with worksheets,
•    use a range of find and replace techniques,
•    apply a variety of page setup techniques,
•    sort data in a list in a worksheet, and 
•    filter data in a table.

Upon completion of this course you will receive a Certificate of Participation.

Please also refer to the Student Fact Pack for additional College and support information.

Pre-requisites

Study pathway

Job opportunities

Pre-requisites
Study pathway
Job opportunities

Your qualification prepares you for roles such as:

Use Microsoft Excel proficiently in a work or home environment.

Delivery location, important dates and study options

Overview

Outline

Fees and charges

About the lecturer

Other requirements

Overview

Course Overview

Where Kalgoorlie
Duration 1 day
HowFace To Face (Subject To Quota)
When6 February 2018, 14 March 2018, 9 May 2018, 31 July 2018, 15 August 2018, 10 October 2018, 14 November 2018 and 5 December 2018
Outline
Fees and charges

$295.00

About the lecturer
Other requirements
Enquire now
Call us
Email us

Course enquiry

Please note: This form is only for course enquiries. If you would like to apply or require further application information, please visit our Apply and Enrol page.

For help enrolling or for more information contact: Commercial Business Coordinator - Tracy Hicks at 9088 6830 or tracy.hicks@crtafe.wa.edu.au.

Alternatively contact Client Services at 1800 672 700 or email: info@crtafe.wa.edu.au.

International students please contact www.tafeinternational.wa.edu.au .

Please note: All enrolling students will require a Unique Student Identifier number 

Entrance Requirements

School Leaver Non-School Leaver AQF

For help enrolling or for more information contact: Commercial Business Coordinator - Tracy Hicks at 9088 6830 or tracy.hicks@crtafe.wa.edu.au.

Alternatively contact Client Services at 1800 672 700 or email: info@crtafe.wa.edu.au.

International students please contact www.tafeinternational.wa.edu.au .

Please note: All enrolling students will require a Unique Student Identifier number 

Entrance Requirements

School Leaver Non-School Leaver AQF

Qualification level

Links

Page last updated February 23, 2018