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 (Class Room)
When

This is a one (1) day course delivered at the Kalgoorlie Campus

Next delivery date:     30 November 2017

2018 course dates will be published as soon as they are available.

Outline
Fees and charges

$290.00

About the lecturer
Other requirements

It's easy! Apply now by calling the Campus that the course is offered at OR email us at info@crtafe.wa.edu.au and we will get back to you!

 

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 November 17, 2017