Winter_header"



Excel : Advanced

Description

Advance your abilities using Microsoft Excel to design and produce complex spreadsheets. This course also requires participants to complete an assessment online after the session. This course is delivered in a blend of face-to-face and self-paced online learning to develop the skills and knowledge required. BSBTEC402 Design and produce complex spreadsheets CM7200 File Management

Westfield Penrith on Wednesday

Beginning 2/11/2022 from 9:00:00 to 17:00:00

for 1 Day

$152 Your training may be subsidised by the NSW Government. Contact the College to confirm your eligibility.

** This Course is Nationally Recognised Accredited Training. See the Description for the Units of Competency included **

Topics Covered include:

1. Organise personal work environment in accordance with ergonomic requirements and analyse task and determine specifications for spreadsheets 2. Use spreadsheet design software functions and formulae to meet identified requirements. Link spreadsheets according to software procedures 3. Evaluate and identify tasks requiring automation. Create, use and edit macros to fulfil requirements of task and automate spreadsheet operation 4. Enter, check and amend data according to organisational and task requirements. Import and export data between compatible spreadsheets and adjust documents, according to software and organisational procedures 5. Determine style of graph to meet specified requirements and manipulate spreadsheet data, where required. Create graphs with labels and titles from numerical data contained in a spreadsheet file

Course Outcome

At the end of this course learners will have intermediate skills in spreadsheet design, use and production using Microsoft Excel.

On the first session bring

Pen USB (min 2G) $10

Items to be purchased during the course

No

Special Issues To Note

Workshop, no concession

NCC Code: 83EX2M422

 

 

Home | Courses | Registration | About Us | RTO Number 1223 | Smart and Skilled