Home | Short courses | MICROSOFT EXCEL - ADVANCED

MICROSOFT EXCEL - ADVANCED

State ID: G9231

 

You will learn the more advanced features of Microsoft Excel including analytical tools, pivot tables, Solver, outlining and summarising and some key automation features such as Macros.  This course assumes a good general understanding of the software and experience in the construction and modification of workbooks. The student should be able to copy within Excel, create charts, and create basic formulas.

Specifically you will learn about:
•    use a range of formula techniques,
•    protect data in worksheets and workbooks,
•    use an advanced filter to analyse data in a list,
•    use a variety of data validation techniques,
•    apply conditional formatting to ranges in a worksheet,
•    use goal seeking to determine the values required to read a desired result,
•    create, use and modify data tables,
•    create and work with scenarios and Scenario Manager,
•    understand and create simple PivotTables,
•    construct and operate PivotTables using some of the more advanced
      techniques,
•    use data linking to create more efficient workbooks, and 
•    use the Data Consolidation feature to combine data form several
     workbooks into one.

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:

Using Excel in a formal work situation or at home.

Delivery location, important dates and study options

Overview

Outline

Fees and charges

About the lecturer

Other requirements

Overview

Course Overview

Where Kalgoorlie
Duration 2 days
HowFace To Face (Class Room)
When

This is a two (2) day course delivered at the Kalgoorlie Campus 

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

Outline
Fees and charges

$590.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.

Or Alternatively contact Client Services at 1800 672 700 or  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.

Or Alternatively contact Client Services at 1800 672 700 or  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 23, 2017