Spring_header"



Computers : Excel Advanced

Description

Is your business ready to take it's spreadsheet to the next level? This course will cover spreadsheet development and include linked spreadsheet solutions, automation and standardisation of spreadsheet operation, data import and export and graphing using numerical data. BSBITU402 Develop and use complex spreadsheets FSKDIG03 Use digital technology for routine workplace tasks

Westfield Penrith Weekend on Sunday

Beginning 15/9/2019 from 9:30:00 to 17:30:00

for 1 Day

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

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

Topics Covered include:

Identify task and purpose, audience and presentation requirements. Using technology perform and review task Learn the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents Analyse task and determine specification for spreadsheets, identify task requirements, data entry, storage, output, reporting and presentation requirements Utilise spreadsheet design functions and formulae, link spreadsheets, format cells and test formulae Learn the skills and knowledge required to use digital technology to undertake routine workplace tasks Create, use and edit macros, develop edit and use templates Enter, check and amend data, import and export data between compatible spreadsheets, use manual and online help to overcome problems, preview, adjust and print spreadsheet Determine style of graph, create graphs with labels and titles, save view and print

Course Outcome

Students will be able to use spreadsheet software to complete business tasks and produce complex documents.

On the first session bring

Notebook and pen. Please wear warm clothing in Autumn and Winter as the air conditioning can be cold.

Items to be purchased during the course

Special Issues To Note

Workshop, no concession

NCC Code: 97EX3W319

 

 

Home | Courses | Registration | About Us | RTO Number 1223